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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =17
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-25 13:53:16')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 120, 120
61632 PSYCHOLOGICAL METAMORPHOSIS OLD FUTERE CAP GREEN
59198 VIRGO CROSS V WOOL CAP GRAY
60303 TOY MACHINE (トイマシーン) TOYMONSTER CAT BB CAP - BEIGE
60304 TOY MACHINE (トイマシーン) TOYMONSTER CAT BB CAP - BLACK
60333 LONELY論理 COTTON DAMAGED CLASSIC LOGO CAP BIEGE
60334 LONELY論理 COTTON DAMAGED CLASSIC LOGO CAP M.BLUE
55640 【予約商品】Anti Social Social Club WEIRD CAP BLACK
57319 TOY MACHINE NEW BLOOD LOGO SIX PANEL CAP(SMOKE PINK)
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Black
55885 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Baige
27389 THRASHER 16TH-C26 WASH CAP WHITE
27390 THRASHER 16TH-C26 WASH CAP BLACK
49100 FILA FLH-P01 RED
52898 ANIMALIA AN20SP-CP01 '49Cap-LOGO WHITE x EMERALD
54513 FILA TOKYO LABEL LOW CAP WHITE
54514 FILA TOKYO LABEL LOW CAP BLACK
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL