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-04-19 11:16:49')
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 p.update_date DESC
LIMIT 0, 75
2851 DROP DEAD CLOTHING Girls Chillin
3291 DROP DEAD CLOTHING WORN N TORN
3943 DROP DEAD CLOTHING WORN N TORN Girls Pants
4745 DROP DEAD CLOTHING MOMMY'S VERY ANGRY
4792 DROP DEAD CLOTHING LET'S FUCK
4794 DROP DEAD CLOTHING EYE HEART DROP DEAD
4795 DROP DEAD CLOTHING MONROE
5185 DROP DEAD CLOTHING TROPICANA EARRINGS
5191 DROP DEAD CLOTHING SWANKY CATZ
5293 DROP DEAD CLOTHING FLORAL LEGGINGS
6173 DROP DEAD CLOTHING Battered Laptop Case
6896 DROP DEAD CLOTHING PATCHWORK TROUSERS
7393 DROP DEAD CLOTHING CROSSING THE LINES FITTED HAT
7511 DROP DEAD CLOTHING LEOVEPARD TOP
7579 DROP DEAD CLOTHING KNEE VISION TIGHTS
8610 DROP DEAD CLOTHING YUM LEGGINGS
8615 DROP DEAD CLOTHING WOAH VAL CROP T-SHIRT
8875 DROP DEAD CLOTHING DOOM CARDIGAN
10161 DROP DEAD CLOTHING Death Bed Jacket Girls
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
10730 DROP DEAD CLOTHING KILLER DRESS GIRLS
10738 DROP DEAD CLOTHING HAVARD SHIRT
10740 DROP DEAD CLOTHING PLAGUE SHIRT
10748 DROP DEAD CLOTHING CLIQUE SWEATER
10749 DROP DEAD CLOTHING OWENS SWEATER
10755 DROP DEAD CLOTHING RUPERT SWEATER
10762 DROP DEAD CLOTHING YARD SALE KNITTED SWEATER
10788 DROP DEAD CLOTHING AK'S PULLOVER HOODY
10800 DROP DEAD CLOTHING CLOAQ JACKET
10806 DROP DEAD CLOTHING ROSY LEGGINGS GIRLS
10810 DROP DEAD CLOTHING KILLER LEGGINGS GIRLS
10821 DROP DEAD CLOTHING DEAD BEANIE WHITE
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
13603 DROP DEAD CLOTHING DEEZEL BOXER SHORTS
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
13620 DROP DEAD CLOTHING LIGHT AS CREWNECK
13621 DROP DEAD CLOTHING TRENCH DROP HOODIE
13624 DROP DEAD CLOTHING CRAZY LIFE BEANIE
13629 DROP DEAD CLOTHING CRAZY LIFE TOWEL
13631 DROP DEAD CLOTHING DEAD SHORTS
13633 DROP DEAD CLOTHING CRAZY LIFE KNIT TOP
13635 DROP DEAD CLOTHING DOUBLE RAINBOW WRISTBAND
13896 DROP DEAD CLOTHING GOLDEN AXE
13897 DROP DEAD CLOTHING NEKO HAT
15025 DROP DEAD CLOTHING Deezel Arches Baseball Jersey
15026 DROP DEAD CLOTHING CBA Crewneck
15028 DROP DEAD CLOTHING Anti-Social Hoodie
15032 DROP DEAD CLOTHING CBA Beanie
15036 DROP DEAD CLOTHING Blood Pact Sleeveless Cream
15057 DROP DEAD CLOTHING Black Stabbath Crewneck
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
15139 DROP DEAD CLOTHING Dark Hand Kimono Long
15140 DROP DEAD CLOTHING Dark Hand Kimono Short
15143 DROP DEAD CLOTHING Victimless Crime Sleeveless T-s
15144 DROP DEAD CLOTHING Majic Dress
15158 DROP DEAD CLOTHING BLACK STABBATH LEGGINS
15948 DROP DEAD CLOTHING Snow Parka Red
15949 DROP DEAD CLOTHING Snow Parka Green Ladies
15950 DROP DEAD CLOTHING Snow Parka Green