SELECT SQL_CALC_FOUND_ROWS 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-03-29 16:49:08')
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) DESC
LIMIT 0, 120
15948 DROP DEAD CLOTHING Snow Parka Red
15949 DROP DEAD CLOTHING Snow Parka Green Ladies
15950 DROP DEAD CLOTHING Snow Parka Green
23647 DROP DEAD CLOTHING (ドロップデッド・クロージング) Guys Wilderness
17515 DROP DEAD CLOTHING Stealth Jacket
22468 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Bomber Jacket
22469 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Bomber Jacket Ladies
10161 DROP DEAD CLOTHING Death Bed Jacket Girls
10800 DROP DEAD CLOTHING CLOAQ JACKET
13621 DROP DEAD CLOTHING TRENCH DROP HOODIE
23651 DROP DEAD CLOTHING (ドロップデッド・クロージング) Locator Quilted Jacket
17509 DROP DEAD CLOTHING Join Us Harrington
20412 DROP DEAD CLOTHING Stay Dead Bomber
20413 DROP DEAD CLOTHING LADIE'S Stay Dead Bomber
16541 DROP DEAD CLOTHING Upper Hobo Blazer
20416 DROP DEAD CLOTHING Psyched Out Jacket
4795 DROP DEAD CLOTHING MONROE
15028 DROP DEAD CLOTHING Anti-Social Hoodie
21875 DROP DEAD CLOTHING Stackbabber Jacket
15025 DROP DEAD CLOTHING Deezel Arches Baseball Jersey
15057 DROP DEAD CLOTHING Black Stabbath Crewneck
13620 DROP DEAD CLOTHING LIGHT AS CREWNECK
8875 DROP DEAD CLOTHING DOOM CARDIGAN
10788 DROP DEAD CLOTHING AK'S PULLOVER HOODY
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
15140 DROP DEAD CLOTHING Dark Hand Kimono Short
13633 DROP DEAD CLOTHING CRAZY LIFE KNIT TOP
23646 DROP DEAD CLOTHING (ドロップデッド・クロージング) Sastrugi Longsleeve
13896 DROP DEAD CLOTHING GOLDEN AXE
2851 DROP DEAD CLOTHING Girls Chillin
6896 DROP DEAD CLOTHING PATCHWORK TROUSERS
15139 DROP DEAD CLOTHING Dark Hand Kimono Long
16544 DROP DEAD CLOTHING Throw On Hoodie Black
16545 DROP DEAD CLOTHING Throw On Hoodie Gray
17500 DROP DEAD CLOTHING Cod-eyed Hoodie
17504 DROP DEAD CLOTHING For Your Pleasure Crewneck
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
21874 DROP DEAD CLOTHING Peace Off! Shirt LADIES
21881 DROP DEAD CLOTHING Crazy Plaid Trousers
22470 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Knit Hoodie
22479 DROP DEAD CLOTHING (ドロップデッド・クロージング) Tracker Hoodie
22484 DROP DEAD CLOTHING (ドロップデッド・クロージング) Lit Up Hoodie
13631 DROP DEAD CLOTHING DEAD SHORTS
15026 DROP DEAD CLOTHING CBA Crewneck
3291 DROP DEAD CLOTHING WORN N TORN
10755 DROP DEAD CLOTHING RUPERT SWEATER
10762 DROP DEAD CLOTHING YARD SALE KNITTED SWEATER
16643 DROP DEAD CLOTHING Gerald Jumper
16645 DROP DEAD CLOTHING Bad Luck Jumper
17501 DROP DEAD CLOTHING Cut Up Jumper
22475 DROP DEAD CLOTHING (ドロップデッド・クロージング) Shameless Knit Jumper
22480 DROP DEAD CLOTHING (ドロップデッド・クロージング) Barbed Wire Jumper
22483 DROP DEAD CLOTHING (ドロップデッド・クロージング) Avalanche Waffle Knit Jumper
22485 DROP DEAD CLOTHING (ドロップデッド・クロージング) Roughneck Jeans
23652 DROP DEAD CLOTHING (ドロップデッド・クロージング) Roughneck Dungarees
3943 DROP DEAD CLOTHING WORN N TORN Girls Pants
4794 DROP DEAD CLOTHING EYE HEART DROP DEAD
20405 DROP DEAD CLOTHING Bleach Longsleeve
21876 DROP DEAD CLOTHING Hermit Track Jacket
22471 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Knit Joggers
22473 DROP DEAD CLOTHING (ドロップデッド・クロージング) Backcountry Shirt
22474 DROP DEAD CLOTHING (ドロップデッド・クロージング) Backcountry Shirt Ladies
22490 DROP DEAD CLOTHING (ドロップデッド・クロージング) Dark Night Bedding Set (Single)
22493 DROP DEAD CLOTHING (ドロップデッド・クロージング) Shadow Hunt Backpack
22503 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Divers Bag
7511 DROP DEAD CLOTHING LEOVEPARD TOP
10738 DROP DEAD CLOTHING HAVARD SHIRT
10740 DROP DEAD CLOTHING PLAGUE SHIRT
10748 DROP DEAD CLOTHING CLIQUE SWEATER
10749 DROP DEAD CLOTHING OWENS SWEATER
15144 DROP DEAD CLOTHING Majic Dress
16554 DROP DEAD CLOTHING Granma T-shirt
17508 DROP DEAD CLOTHING Join Us Crop Top
22472 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Cardigan
22494 DROP DEAD CLOTHING (ドロップデッド・クロージング) Litter Holdall Bag
5191 DROP DEAD CLOTHING SWANKY CATZ
23645 DROP DEAD CLOTHING (ドロップデッド・クロージング) Sastrugi T-shirt
8615 DROP DEAD CLOTHING WOAH VAL CROP T-SHIRT
20418 DROP DEAD CLOTHING Blasphemy Shorts
20419 DROP DEAD CLOTHING Buzzing Chino Shorts
21872 DROP DEAD CLOTHING Blasphemy Dress
21878 DROP DEAD CLOTHING Blasphemy Shorts LADIE'S
22465 DROP DEAD CLOTHING (ドロップデッド・クロージング) Offroad Longsleeve
22466 DROP DEAD CLOTHING (ドロップデッド・クロージング) Offroad Longsleeve Ladies
22482 DROP DEAD CLOTHING (ドロップデッド・クロージング) Morticia Long Top
22499 DROP DEAD CLOTHING (ドロップデッド・クロージング) Peace Time Watch
4792 DROP DEAD CLOTHING LET'S FUCK
16558 DROP DEAD CLOTHING Days-Eye T-shirt
17598 DROP DEAD CLOTHING Stripped T-shirt Navy
21880 DROP DEAD CLOTHING Imagination Clutch Bag
20389 DROP DEAD CLOTHING Outer Circle Longsleeve
20032 DROP DEAD CLOTHING Monster Topper Imosex Tee
6173 DROP DEAD CLOTHING Battered Laptop Case
7393 DROP DEAD CLOTHING CROSSING THE LINES FITTED HAT
20401 DROP DEAD CLOTHING Psyched Out Dress
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
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
13605 DROP DEAD CLOTHING MOTHER TONGUE CROP 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