SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM dtb_products AS p
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2024-05-21 20:34:20')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 582)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
919 The Devil Wears Prada Virus Allover Print T-Shirt
5638 OF MICE & MEN EAGLE T-Shirt
6021 OF MICE & MEN Faithfulness Black T-Shirt
6022 OF MICE & MEN Ice Age Black
7448 ISSUES I Have - Heather Grey
7466 MEMPHIS MAY FIRE Richer Black
7467 MEMPHIS MAY FIRE Crest Black Tank Top
7477 ISSUES These Colors Don't Bleed Black
7495 OF MICE & MEN Wave Black Tank Top
9022 ISSUES Effing Tri-Heather Gray T-SHIRT
9023 ISSUES Effing Black T-SHIRT
9026 OF MICE & MEN Wave Black T-Shirt
9313 MEMPHIS MAY FIRE Identity Navy Blue
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
9317 MEMPHIS MAY FIRE Challenger Black T-Shirt
9386 CHELSEA GRIN Evolve Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
9394 DANCE GAVIN DANCE WWJCD Black
9409 SLEEPING WITH SIRENS Detailed Feather Whit T-Shirt
9410 SLEEPING WITH SIRENS Feather White T-Shirt
10264 FIVE FINGER DEATH PUNCH WOTF NINJA T-Shirt
10265 FIVE FINGER DEATH PUNCH THE CREW T-Shirt
10266 FIVE FINGER DEATH PUNCH THE WAY T-Shirt
11160 MEMPHIS MAY FIRE Shield Heather Hooded
11161 MEMPHIS MAY FIRE Opportunity Black
11162 MEMPHIS MAY FIRE Crest Black Hooded
11215 LIKE MOTHS TO FLAMES Demon Black Hoodie
11219 OF MICE & MEN Wave Faithfulness Black Hooded
11296 THE DEVIL WEARS PRADA Trooper Slate Gray
11303 MEMPHIS MAY FIRE Richer Black Tank Top
11424 OF MICE & MEN Restoring Force Album Heather GRY
11429 LIKE MOTHS TO FLAMES Fuck This Life Black
11431 CROWN THE EMPIRE End Of The World Black
11438 LIKE MOTHS TO FLAMES Snakes & Heart Black T-Shirt
11443 CROWN THE EMPIRE Skull Book Green Black
11458 LIKE MOTHS TO FLAMES Demon Black Tank Top
11459 LIKE MOTHS TO FLAMES Middle Finger Black Tank Top
12065 OF MICE & MEN GRADIENT LOGO T-Shirt
12066 OF MICE & MEN SNAKE Raglan T-Shirt
14433 THE DEVIL WEARS PRADA Custom BlackGrey Pants(B)
15401 MEMPHIS MAY FIRE Logo Heather Gray
15402 MEMPHIS MAY FIRE Ordinary Love Red Tank Top
15403 MEMPHIS MAY FIRE Ordinary Love Black Zip-Up Sweats
15404 MEMPHIS MAY FIRE Hourglass Black T-Shirt
15405 MEMPHIS MAY FIRE Light House Navy T-Shirt
15406 MEMPHIS MAY FIRE Unconditional Black
15407 MEMPHIS MAY FIRE On Our Own Black Tank Top
15408 MEMPHIS MAY FIRE Red Logo Black
15409 MEMPHIS MAY FIRE Texas Torch Black
15410 MEMPHIS MAY FIRE Skulls & Arrows Black Crewneck
15411 MEMPHIS MAY FIRE Shield Prove Me Right White
15424 ISSUES Logo Heather Hooded
15425 ISSUES Logo White Tank Top
15432 ISSUES Logo Dark Heather Hooded
15433 ISSUES Monster Heather Hoodie
15434 ISSUES Monster Heather Grey
15471 CROWN THE EMPIRE Axe Navy
15472 CROWN THE EMPIRE Crest Black
15473 CROWN THE EMPIRE Oh Catastrophe Heather Tank Top
15477 CHELSEA GRIN Wolf Lady Black T-Shirt
15483 CHELSEA GRIN My Damnation Black TankTop
15484 CHELSEA GRIN Playing With Fire Black Tank Top
15571 OF MICE & MEN Faithfulness Heather Grey
15589 LIKE MOTHS TO FLAMES What Makes You Better Cursive
15592 OF MICE & MEN Text White Tank Top
15593 SLEEPING WITH SIRENS Red Carpet Black
15599 SLEEPING WITH SIRENS Light & Death Black
18969 MEMPHIS MAY FIRE Anchor Aqua
18972 MEMPHIS MAY FIRE Blue Fun Crest Heather
18973 MEMPHIS MAY FIRE BLUE LOGO HEATHER GREY
18979 MEMPHIS MAY FIRE Nautical Black
18980 MEMPHIS MAY FIRE Eagle Dagger Red
18981 MEMPHIS MAY FIRE Cartoon Matty Black
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19013 CHELSEA GRIN Skull Bind Black T-Shirt
19131 SLEEPING WITH SIRENS Radio Black Tank Top
19132 SLEEPING WITH SIRENS Radio Black
19133 SLEEPING WITH SIRENS Feather Charcoal Grey T-Shirt
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
19838 LIKE MOTHS TO FLAMES FLAMES CAMO SNAPBACK
19839 THE DEVIL WEARS PRADA Splatter BLACK
19855 OF MICE & MEN Text Heather Athletic Grey Hooded S.
19870 CROWN THE EMPIRE Oh, Catastrophe Heather Grey Tee
19872 EMAROSA Versus Black
19875 DANCE GAVIN DANCE Eye Black
19876 DANCE GAVIN DANCE Zoo White
20550 PALISADES Pyramid Black
20551 PALISADES NXTLVL Black Basketball
20552 PALISADES Future Music Black Tank Top
20553 PALISADES Wolves...TS Black
20554 PALISADES Kanji White Glow-in-the-Dark Wristband
20555 PALISADES Kanji Black Lanyard
20556 PALISADES Mind Games Black Sticker
20557 PALISADES Two Fingers Lime Tank Top
20558 PALISADES Logo White Tank Top
20559 PALISADES Mind Games Black Jersey
20560 PALISADES Kanji Black T-Shirt
21114 ISSUES Diamond Eyes Black
21115 ISSUES Too Many Moons Heather Tank Top
21116 ISSUES Many Moons Ago Heather Athletic Gray T-Shir
21117 ISSUES Black Diamonds Black
21127 DANCE GAVIN DANCE Deathstar Black
24660 ISSUES Triangle - Sticker Pack
24661 ISSUES S/T Album Art Black - T-Shirt
24662 ISSUES I Have Issues Black - T-Shirt
24663 ISSUES The Road Black - T-Shirt
24664 ISSUES Black Diamonds Heather Grey - T-Shirt
24665 ISSUES Hooligans White - T-Shirt
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
24669 SLEEPING WITH SIRENS Light & Death White
24670 SLEEPING WITH SIRENS Floral White - T-Shirt
24674 SLEEPING WITH SIRENS Tough As Nails Heather Grey - Crewneck
24676 SLEEPING WITH SIRENS Radio Black - Pullover
24677 SLEEPING WITH SIRENS If You Were A Movie.. Sublimation
24679 SLEEPING WITH SIRENS Sealed Lips Black - T-Shirt
24680 SLEEPING WITH SIRENS Punk Patch Black - Girls/JRS t-shirt
24681 SLEEPING WITH SIRENS Guns White - T-Shirt
24697 MEMPHIS MAY FIRE Unconditional Tour Black - T-Shirt
24698 MEMPHIS MAY FIRE Love Truth Long Sleeve White - T-Shirt
24699 MEMPHIS MAY FIRE Battleground Black