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-04-29 00:23:50')
AND pc.classcategory_id1 IN( 13,35,44)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 238)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
4745 DROP DEAD CLOTHING MOMMY'S VERY ANGRY
15952 DROP DEAD CLOTHING The Mark Gloves
23650 DROP DEAD CLOTHING (ドロップデッド・クロージング) Glacier Boxer Shorts
13603 DROP DEAD CLOTHING DEEZEL BOXER SHORTS
15951 DROP DEAD CLOTHING Happy Hands Mittens
16646 DROP DEAD CLOTHING Hot Dogs Boxer Shorts
10720 DROP DEAD CLOTHING DROP OUT T-SHIRT
10721 DROP DEAD CLOTHING YOU SUCK T-SHIRT
20378 DROP DEAD CLOTHING Lazy Bones T-shirt
20379 DROP DEAD CLOTHING Lazy Bones Tank
20380 DROP DEAD CLOTHING Perspective T-shirt
20381 DROP DEAD CLOTHING Perspective Tank
20382 DROP DEAD CLOTHING Holiday T-shirt
20384 DROP DEAD CLOTHING Holiday Tank
20385 DROP DEAD CLOTHING Smudge T-shirt
20386 DROP DEAD CLOTHING Smudge Tank
20388 DROP DEAD CLOTHING Your Funeral Tank
20390 DROP DEAD CLOTHING Psyched Out T-shirt
20391 DROP DEAD CLOTHING Hunted T-shirt
20392 DROP DEAD CLOTHING Madonna T-shirt
20393 DROP DEAD CLOTHING Snooze T-shirt
20395 DROP DEAD CLOTHING Stay Dead T-shirt
20396 DROP DEAD CLOTHING Stay Dead Tank
20397 DROP DEAD CLOTHING Stackbabber T-shirt
20398 DROP DEAD CLOTHING Buzzing T-shirt
20399 DROP DEAD CLOTHING Give Up T-shirt
20400 DROP DEAD CLOTHING Be Gentle T-shirt
21889 DROP DEAD CLOTHING Madonna Tank
21890 DROP DEAD CLOTHING Snooze Tank
21891 DROP DEAD CLOTHING Goodbye T-shirt
21892 DROP DEAD CLOTHING Stackbabber Tank
21893 DROP DEAD CLOTHING Be Gentle Tank
22454 DROP DEAD CLOTHING (ドロップデッド・クロージング) Lounging T-shirt
22458 DROP DEAD CLOTHING (ドロップデッド・クロージング) Sleet T-shirt
22460 DROP DEAD CLOTHING (ドロップデッド・クロージング) Newcifix T-shirt
22463 DROP DEAD CLOTHING (ドロップデッド・クロージング) Concrete T-shirt Navy
15956 DROP DEAD CLOTHING Graft T-shirt
16550 DROP DEAD CLOTHING Deadheads T-shirt Cream
16551 DROP DEAD CLOTHING Smile T-shirt Cream
16552 DROP DEAD CLOTHING Smile T-shirt Black
17502 DROP DEAD CLOTHING Dayzee Tank
17513 DROP DEAD CLOTHING Pallbearers T-shirt
17516 DROP DEAD CLOTHING The Circle T-shirt
17580 DROP DEAD CLOTHING Cod-eyed T-shirt
13597 DROP DEAD CLOTHING SPENGBAB T-SHIRT
13598 DROP DEAD CLOTHING STOP FUCKING TALKING TO ME
13601 DROP DEAD CLOTHING WE CUM IN PEACE T-SHIRT
13602 DROP DEAD CLOTHING CRAZY LIFE T-SHIRT
13608 DROP DEAD CLOTHING DFD SLEEVELESS CREAM
13609 DROP DEAD CLOTHING DFD SLEEVELESS BLACK
13610 DROP DEAD CLOTHING I WANT TO DIE T-SHIRT
13612 DROP DEAD CLOTHING F.O T-SHIRT
13614 DROP DEAD CLOTHING NOTHING IS GOING TO BE OK
13615 DROP DEAD CLOTHING MOTHER TONGUE SLEEVELESS
13616 DROP DEAD CLOTHING DEEZEL VEST
13617 DROP DEAD CLOTHING FEATHERS SLEEVELESS T-SHIRT
13618 DROP DEAD CLOTHING HEARTS ALL-OVER SLEEVELESS
15036 DROP DEAD CLOTHING Blood Pact Sleeveless Cream
15058 DROP DEAD CLOTHING Marble Tank Top BLACK
15059 DROP DEAD CLOTHING Marble Tank Top WHITE
15066 DROP DEAD CLOTHING Back Stabber Tank Top Black
15143 DROP DEAD CLOTHING Victimless Crime Sleeveless T-s
16548 DROP DEAD CLOTHING 20/20 T-Shirt
16553 DROP DEAD CLOTHING Sign Language T-shirt
16556 DROP DEAD CLOTHING Warhammer T-shirt
16557 DROP DEAD CLOTHING Photocopy T-shirt
16636 DROP DEAD CLOTHING Smile Tank Black
16649 DROP DEAD CLOTHING Sign Language Tank
6173 DROP DEAD CLOTHING Battered Laptop Case
20402 DROP DEAD CLOTHING Smudge Jersey
22457 DROP DEAD CLOTHING (ドロップデッド・クロージング) Peaks 3/4 Sleeve
22461 DROP DEAD CLOTHING (ドロップデッド・クロージング) Federation T-shirt
22467 DROP DEAD CLOTHING (ドロップデッド・クロージング) Glacier T-shirt
20389 DROP DEAD CLOTHING Outer Circle Longsleeve
4792 DROP DEAD CLOTHING LET'S FUCK
16558 DROP DEAD CLOTHING Days-Eye T-shirt
17598 DROP DEAD CLOTHING Stripped T-shirt Navy
8615 DROP DEAD CLOTHING WOAH VAL CROP T-SHIRT
22465 DROP DEAD CLOTHING (ドロップデッド・クロージング) Offroad Longsleeve
23645 DROP DEAD CLOTHING (ドロップデッド・クロージング) Sastrugi T-shirt
16554 DROP DEAD CLOTHING Granma T-shirt
10738 DROP DEAD CLOTHING HAVARD SHIRT
10740 DROP DEAD CLOTHING PLAGUE SHIRT
10748 DROP DEAD CLOTHING CLIQUE SWEATER
10749 DROP DEAD CLOTHING OWENS SWEATER
4794 DROP DEAD CLOTHING EYE HEART DROP DEAD
20405 DROP DEAD CLOTHING Bleach Longsleeve
22471 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Knit Joggers
10755 DROP DEAD CLOTHING RUPERT SWEATER
10762 DROP DEAD CLOTHING YARD SALE KNITTED SWEATER
22475 DROP DEAD CLOTHING (ドロップデッド・クロージング) Shameless Knit Jumper
22480 DROP DEAD CLOTHING (ドロップデッド・クロージング) Barbed Wire Jumper
22483 DROP DEAD CLOTHING (ドロップデッド・クロージング) Avalanche Waffle Knit Jumper
15026 DROP DEAD CLOTHING CBA Crewneck
16544 DROP DEAD CLOTHING Throw On Hoodie Black
16545 DROP DEAD CLOTHING Throw On Hoodie Gray
17500 DROP DEAD CLOTHING Cod-eyed Hoodie
17510 DROP DEAD CLOTHING Lowtuss Shirt
20404 DROP DEAD CLOTHING Cry Blood Hoodie
20407 DROP DEAD CLOTHING Buzzing Jumper
20408 DROP DEAD CLOTHING Stay Dead Jumper
20417 DROP DEAD CLOTHING Peace Off! Shirt
21870 DROP DEAD CLOTHING TYTC Jumper
22470 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Knit Hoodie
22479 DROP DEAD CLOTHING (ドロップデッド・クロージング) Tracker Hoodie
22484 DROP DEAD CLOTHING (ドロップデッド・クロージング) Lit Up Hoodie
13896 DROP DEAD CLOTHING GOLDEN AXE
23646 DROP DEAD CLOTHING (ドロップデッド・クロージング) Sastrugi Longsleeve
15953 DROP DEAD CLOTHING Pallbearers Hoodie
16647 DROP DEAD CLOTHING For Your Pleasure Crewneck
20414 DROP DEAD CLOTHING It's Your Funeral Jacket
20415 DROP DEAD CLOTHING Concrete Jacket
21873 DROP DEAD CLOTHING Buzzing Jacket
13620 DROP DEAD CLOTHING LIGHT AS CREWNECK
15025 DROP DEAD CLOTHING Deezel Arches Baseball Jersey
15057 DROP DEAD CLOTHING Black Stabbath Crewneck
15028 DROP DEAD CLOTHING Anti-Social Hoodie
16541 DROP DEAD CLOTHING Upper Hobo Blazer
20416 DROP DEAD CLOTHING Psyched Out Jacket
17509 DROP DEAD CLOTHING Join Us Harrington