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 18:32:38')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 497)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
21104 Stay Sick Clothing Diamond Anchor Black Wallet
21106 Stay Sick Clothing Thorns Black
21107 Stay Sick Clothing Carl All-Over
21108 Stay Sick Clothing Music Black
21109 Stay Sick Clothing Divide Black
21110 Stay Sick Clothing Hands Black Tank Top
21111 Stay Sick Clothing Suck My Fuck White On Black
21112 Stay Sick Clothing Thou Shall Stay Sick Black
21113 Stay Sick Clothing Don't Be A Fucking Bitch On Bla
21198 Stay Sick Clothing Laurel Black - Snapback
21199 Stay Sick Clothing Finger All-Over - TankTop
21200 Stay Sick Clothing 666 Black - Hockey Jersey
21201 Stay Sick Clothing MMXV Black - TankTop
21202 Stay Sick Clothing Lion Black - T-Shirt
21203 Stay Sick Clothing Suck My Fuck Black on Black
21204 Stay Sick Clothing I'm Not Deaf Black - Tank Top
21205 Stay Sick Clothing Anchor Script Custom Baseball
21206 Stay Sick Clothing Cloud 9 Custom T-Shirt
21207 Stay Sick Clothing Suck My Fuck Floral White
21208 Stay Sick Clothing Stay Sick White
21209 Stay Sick Clothing Anchor Black - Ladies Leggings
21210 Stay Sick Clothing Right In The Pussy Black
21211 Stay Sick Clothing Hands Black
21212 Stay Sick Clothing IDGAF Black Snapback
21213 Stay Sick Clothing Sick White - Beanie