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 =328
)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-26 13:09:42')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 60, 60
61604 HYPER CORE VACCINATEDニーハイ
61605 HYPER CORE BOOSTニーハイ
61606 HYPER CORE GRUDGEニーハイ
61607 HYPER CORE MUMMYディザイアニーハイ
61608 HYPER CORE ピザイアニーハイ
61609 HYPER CORE ディザイアソックス RED
61611 HYPER CORE ディザイアソックス WHITE
60628 THRASHER TH-SX215 3Pack BLACK
60436 THRASHER TH-SX203 3Pack BLACK
60438 THRASHER TH-SX206 3Pack BLACK
61031 THRASHER TH-SX203 3Pack WHITE
60437 THRASHER (スラッシャー) TH-SX206 3Pack WHITE
60440 THRASHER (スラッシャー) TH-SX211 3Pack BLACK
60204 Anti Social Social Club No Drama Black Socks
60205 Anti Social Social Club No Drama Pink Socks
58151 RIP DESIGN WORXX Rest in Punk ニーハイソックス
54532 SAMURAI CORE SR-AC-031C 風車靴下 RED