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 03:47:58')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 652)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
38118 Civil Regime 17CV-AW006H OUR FLAG HOODIE BLK
38119 Civil Regime 17CV-AW006H OUR FLAG HOODIE NTURAL
38120 Civil Regime 17CV-AW001T JUNX SLOUCH TEE
38121 Civil Regime 17CV-AW002T COS OVSZ BOXY L/S TEE WHT
38122 Civil Regime 17CV-AW002T COS OVSZ BOXY L/S TEE BLK
38123 Civil Regime 17CV-AW003T BOX L/S TEE BLK
38124 Civil Regime 17CV-AW003T BOX L/S TEE CAMO
38125 Civil Regime 17CV-AW011J DIVISION BOMBER
38555 Civil Regime CHAOS DENIM JACKET IN BLACK
38566 Civil Regime CRASH DENIM JACKET IN INDIGO
38567 Civil Regime ALL POWER DENIM SHERPA JACKET IN INDIGO
38568 Civil Regime ALL POWER DENIM SHERPA JACKET IN BLACK
39869 Civil Regime (シビル・レジーム) Sound Wave LS Tee in Gold
39870 Civil Regime (シビル・レジーム) Sound Wave LS Tee in Black
39871 Civil Regime (シビル・レジーム) Rebel Tiger Tee in White
39872 Civil Regime (シビル・レジーム) Inside View TEE Black
39873 Civil Regime (シビル・レジーム) Cousins Tee Cream
39874 Civil Regime (シビル・レジーム) Cousins Tee Black
39875 Civil Regime (シビル・レジーム) Poison Embroy Tee
43322 Civil Regime 18CV-AW728T META AFFECT L/S TEE BLACK
43323 Civil Regime 18CV-AW728T META AFFECT L/S TEE WHITE
43324 Civil Regime 18CV-AW730T GALLERY L/S TEE BLACK
43325 Civil Regime 18CV-AW730T GALLERY L/S TEE WHITE
43326 Civil Regime 18CV-AW724H META AFFECT HOODIE BLACK
43327 Civil Regime 18CV-AW735H BLOOM BOX HOODIE WHITE