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-26 02:21:59')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 23)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
888 IRON FIST CLOTHING-Daniel Son S/S Tee
2731 IRON FIST Squealer Boyfriend Tee
3888 IRON FIST Mr Wong's Sequined Tank
5339 IRON FIST CLOTHING Annie's Lament Skinny Jeans BLK
5375 IRON FIST CLOTHING Beware Raglan SS Tee
5436 IRON FIST CLOTHING Lovelace Platform
5676 IRON FIST CLOTHING Stop Being Useless A-Line Tank
5680 IRON FIST CLOTHING Siesta Skull Sequined Dress
6801 IRON FIST CLOTHING Digi Skull Flat LAVENDER
6828 IRON FIST CLOTHING Pony Tail Short
7123 IRON FIST CLOTHING Sweets For My Sweets Purse
7144 IRON FIST CLOTHING SUPER BITCHES DRESS
7149 IRON FIST CLOTHING Black Ring Cut Off Shorts
10123 IRON FIST CLOTHING MAKE UP MY MIND PLATFORM
10126 IRON FIST CLOTHING ROAMING HEART FLAT
10128 IRON FIST CLOTHING BONE BREAKER FLAT
10130 IRON FIST CLOTHING TIMMY CHEW HEEL
10131 IRON FIST CLOTHING PARTY MONSTER HEEL
10149 IRON FIST CLOTHING DUANE PETERS BROADWAY HIGH BLK
13331 IRON FIST CLOTHING MISFITS LEGGING BLACK
13333 IRON FIST CLOTHING SORCERY LEAGUE CROP MUSCLE TANK
13338 IRON FIST CLOTHING MISFITS SEQUIN TANK DRESS
13339 IRON FIST CLOTHING SKULL A DOT LEGGING
13340 IRON FIST CLOTHING SKIN CRAWLER DRESS
13343 IRON FIST CLOTHING LET'S MAKE MAGIC DRAPE TEE WT