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 01:13:31')
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
20423 DROP DEAD CLOTHING Fenced-in Wristband
20424 DROP DEAD CLOTHING Iconic Wristband
20425 DROP DEAD CLOTHING Linked Wristband
21883 DROP DEAD CLOTHING Steel City Enamel Pin Badge
21884 DROP DEAD CLOTHING Coffin Enamel Pin Badge
22504 DROP DEAD CLOTHING (ドロップデッド・クロージング) Barbed Wire Wristband
22505 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Pin Badge
22506 DROP DEAD CLOTHING (ドロップデッド・クロージング) Buzzing Pin Badge
22507 DROP DEAD CLOTHING (ドロップデッド・クロージング) Federation Pin Badge
23653 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Comb
15984 DROP DEAD CLOTHING Crosses Wristband
15986 DROP DEAD CLOTHING Box Cutter Wristband
13635 DROP DEAD CLOTHING DOUBLE RAINBOW WRISTBAND
23654 DROP DEAD CLOTHING (ドロップデッド・クロージング) Strike Off Incense Burner
23655 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Incense Burner
15985 DROP DEAD CLOTHING Cross Keyring
15988 DROP DEAD CLOTHING Bad Luck Keyring
22488 DROP DEAD CLOTHING (ドロップデッド・クロージング) Traveller Wallet for iPhone6
22489 DROP DEAD CLOTHING (ドロップデッド・クロージング) Traveller Wallet for iPhone6Plus
22491 DROP DEAD CLOTHING (ドロップデッド・クロージング) Burn It Purse
22492 DROP DEAD CLOTHING (ドロップデッド・クロージング) Wildlife Makeup Bag
22502 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Necklace
4745 DROP DEAD CLOTHING MOMMY'S VERY ANGRY
22501 DROP DEAD CLOTHING (ドロップデッド・クロージング) Up-Top Hipflask
23648 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Bra Top
23649 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Pants
15952 DROP DEAD CLOTHING The Mark Gloves
17477 DROP DEAD CLOTHING Chubracbra T-Shirt(B)
10821 DROP DEAD CLOTHING DEAD BEANIE WHITE
20421 DROP DEAD CLOTHING Buzzing Beanie
20422 DROP DEAD CLOTHING Stay Dead Beanie
22486 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy iPhone Case iPhone6case
22487 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy iPhone Case iPhone6Plus case
22497 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Beanie
22498 DROP DEAD CLOTHING (ドロップデッド・クロージング) Connected Beanie
23650 DROP DEAD CLOTHING (ドロップデッド・クロージング) Glacier Boxer Shorts
13603 DROP DEAD CLOTHING DEEZEL BOXER SHORTS
16518 DROP DEAD CLOTHING Not Okay Beanie
13897 DROP DEAD CLOTHING NEKO HAT
5185 DROP DEAD CLOTHING TROPICANA EARRINGS
10806 DROP DEAD CLOTHING ROSY LEGGINGS GIRLS
10810 DROP DEAD CLOTHING KILLER LEGGINGS GIRLS
15951 DROP DEAD CLOTHING Happy Hands Mittens
16516 DROP DEAD CLOTHING Punjab Beanie
16517 DROP DEAD CLOTHING Baysik Beanie
16646 DROP DEAD CLOTHING Hot Dogs Boxer Shorts
22477 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy PJ Top
22478 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy PJ Bottoms
22496 DROP DEAD CLOTHING (ドロップデッド・クロージング) Litter Tote Bag
22500 DROP DEAD CLOTHING (ドロップデッド・クロージング) Connected Snapback
13624 DROP DEAD CLOTHING CRAZY LIFE BEANIE
15032 DROP DEAD CLOTHING CBA Beanie
20409 DROP DEAD CLOTHING Buzzing Skirt
20410 DROP DEAD CLOTHING Buzzing Crop Top
10719 DROP DEAD CLOTHING HOME TOWN T-SHIRT GIRLS
10720 DROP DEAD CLOTHING DROP OUT T-SHIRT
10721 DROP DEAD CLOTHING YOU SUCK T-SHIRT
15158 DROP DEAD CLOTHING BLACK STABBATH LEGGINS
7579 DROP DEAD CLOTHING KNEE VISION TIGHTS
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
20420 DROP DEAD CLOTHING Wiatch, Biatch! Top
21871 DROP DEAD CLOTHING Holiday Crop Top
21879 DROP DEAD CLOTHING Checkmate Skirt
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
22481 DROP DEAD CLOTHING (ドロップデッド・クロージング) Wednesday Top
13629 DROP DEAD CLOTHING CRAZY LIFE TOWEL
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
16639 DROP DEAD CLOTHING Cancel My Life T-shirt
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
20034 DROP DEAD CLOTHING (ドロップデッド・クロージング) Deadheads tank BLACK
5293 DROP DEAD CLOTHING FLORAL LEGGINGS
8610 DROP DEAD CLOTHING YUM LEGGINGS
10730 DROP DEAD CLOTHING KILLER DRESS GIRLS
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
13617 DROP DEAD CLOTHING FEATHERS SLEEVELESS T-SHIRT
13618 DROP DEAD CLOTHING HEARTS ALL-OVER SLEEVELESS
15036 DROP DEAD CLOTHING Blood Pact Sleeveless Cream