SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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 =588
)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-05-22 11:33:55')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 12,44)
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 10
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
70444 笹子・ジェニファー・由香×RIPDW コラボ限定プルオーバーパーカー
71428 gibous(ギボス) button gothic logo hoodie BLACK
71085 月に足跡を残した6人の少女達は一体何を見たのか...×アマツカミ×GEKIROCK CLOTHING スペシャル・コラボ・パーカー
70233 One Drop(ワンドロップ) ふくだ レモンサワー®PK BLACK
70227 NOTBADCAT (ノットバッドキャット) cats hoodie
69428 アマツカミ 蓮/bloom Hoodie BLACK
70085 洋服倶楽部シェイプス 快楽東京 Big silhouette hoodie(BLACK)
69483 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM HOODIE BLACK
66948 TOY MACHINE (トイマシーン) PEPPER SECT SWEAT PARKA BLACK
66915 ハッピーハンバーグ ロックバンドロゴスウェットパーカー BLACK
65873 GoneR(ゴナー) 3D One Point Parka Black
66199 PeaceBeam(ピースビーム) 「P」logo hoodie Black
61155 AFFECTER (アフェクター) AFF TM HOODIE BLACK
61149 AFFECTER (アフェクター) NESS HOODIE BLACK
61151 AFFECTER (アフェクター) TAG HOODIE BLACK
28428 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT BLACK
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT