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-01 15:24:36')
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 MAX(price02) DESC
LIMIT 0, 120
11219 OF MICE & MEN Wave Faithfulness Black Hooded
24676 SLEEPING WITH SIRENS Radio Black - Pullover
11215 LIKE MOTHS TO FLAMES Demon Black Hoodie
25473 PALISADES Eye Black - Crewneck Sweatshirt
11161 MEMPHIS MAY FIRE Opportunity Black
11162 MEMPHIS MAY FIRE Crest Black Hooded
15403 MEMPHIS MAY FIRE Ordinary Love Black Zip-Up Sweats
15424 ISSUES Logo Heather Hooded
15432 ISSUES Logo Dark Heather Hooded
15433 ISSUES Monster Heather Hoodie
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19855 OF MICE & MEN Text Heather Athletic Grey Hooded S.
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
24674 SLEEPING WITH SIRENS Tough As Nails Heather Grey - Crewneck
24736 MEMPHIS MAY FIRE Logo Maroon - Zip Up
15410 MEMPHIS MAY FIRE Skulls & Arrows Black Crewneck
20551 PALISADES NXTLVL Black Basketball
20559 PALISADES Mind Games Black Jersey
25311 THE DEVIL WEARS PRADA All Over Print Blue
24677 SLEEPING WITH SIRENS If You Were A Movie.. Sublimation
24701 MEMPHIS MAY FIRE Logo Black - White Brim Snapback
25228 LIKE MOTHS TO FLAMES TDTWLF Torch Black - Long Sleeve
25313 EMAROSA Side Fox Tr-Blend Heather Grey - TankTop
19838 LIKE MOTHS TO FLAMES FLAMES CAMO SNAPBACK
24700 MEMPHIS MAY FIRE Logo Two Tone - TankTop
20550 PALISADES Pyramid Black
25304 CROWN THE EMPIRE The Fallout Tie Dye - T-Shirt
15470 CROWN THE EMPIRE Beak White T-Shirt
20557 PALISADES Two Fingers Lime Tank Top
24698 MEMPHIS MAY FIRE Love Truth Long Sleeve White - T-Shirt
25460 OF MICE & MEN Shell White - Pocket T-Shirt
26457 SLEEPING WITH SIRENS Chain Logo Raglan
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
12066 OF MICE & MEN SNAKE Raglan T-Shirt
25231 LIKE MOTHS TO FLAMES Devil Tie Dye
15425 ISSUES Logo White Tank Top
10265 FIVE FINGER DEATH PUNCH THE CREW T-Shirt
24740 MEMPHIS MAY FIRE Shield Royal Blue - T-Shirt
24741 MEMPHIS MAY FIRE Challenger Red - T-Shirt
25470 OF MICE & MEN Ampersand Gold Foil Black - T-Shirt
5638 OF MICE & MEN EAGLE T-Shirt
10266 FIVE FINGER DEATH PUNCH THE WAY T-Shirt
24661 ISSUES S/T Album Art Black - T-Shirt
20558 PALISADES Logo White Tank Top
24706 MEMPHIS MAY FIRE Shark White - T-Shirt
6021 OF MICE & MEN Faithfulness Black T-Shirt
7467 MEMPHIS MAY FIRE Crest Black Tank Top
7495 OF MICE & MEN Wave Black Tank Top
9313 MEMPHIS MAY FIRE Identity Navy Blue
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
9317 MEMPHIS MAY FIRE Challenger Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
11303 MEMPHIS MAY FIRE Richer Black Tank Top
11429 LIKE MOTHS TO FLAMES Fuck This Life Black
11431 CROWN THE EMPIRE End Of The World Black
15401 MEMPHIS MAY FIRE Logo Heather Gray
15402 MEMPHIS MAY FIRE Ordinary Love Red Tank Top
15404 MEMPHIS MAY FIRE Hourglass Black T-Shirt
15405 MEMPHIS MAY FIRE Light House Navy T-Shirt
15407 MEMPHIS MAY FIRE On Our Own Black Tank Top
15408 MEMPHIS MAY FIRE Red Logo Black
15409 MEMPHIS MAY FIRE Texas Torch Black
15411 MEMPHIS MAY FIRE Shield Prove Me Right White
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
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
19013 CHELSEA GRIN Skull Bind Black T-Shirt
19839 THE DEVIL WEARS PRADA Splatter BLACK
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
20552 PALISADES Future Music Black Tank Top
20553 PALISADES Wolves...TS Black
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
25261 DANCE GAVIN DANCE X Black - T-Shirt
919 The Devil Wears Prada Virus Allover Print T-Shirt
6022 OF MICE & MEN Ice Age Black
7448 ISSUES I Have - Heather Grey
7466 MEMPHIS MAY FIRE Richer Black
7477 ISSUES These Colors Don't Bleed Black
9022 ISSUES Effing Tri-Heather Gray T-SHIRT
9023 ISSUES Effing Black T-SHIRT
9386 CHELSEA GRIN Evolve Black T-Shirt
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
11296 THE DEVIL WEARS PRADA Trooper Slate Gray
11424 OF MICE & MEN Restoring Force Album Heather GRY
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
15434 ISSUES Monster Heather Grey
15593 SLEEPING WITH SIRENS Red Carpet Black
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
21117 ISSUES Black Diamonds Black
21127 DANCE GAVIN DANCE Deathstar Black
24662 ISSUES I Have Issues Black - T-Shirt
24663 ISSUES The Road Black - T-Shirt