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-04-25 13:26:27')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 581)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
8件見つかりました
1ページ中1ページ目
1
¥4,620
Crossfaith
T-Shirt
完売
¥3,565
Crossfaith
LP
完売
¥3,056
Crossfaith
Long T-Shirt
完売
¥3,056
Crossfaith
Cap
完売
¥3,056
Crossfaith
Long T-Shirt
完売
¥2,547
Crossfaith
T-Shirt
完売
¥1,019
Crossfaith
Accessory
¥2,852
Crossfaith
Cap
8件見つかりました
1ページ中1ページ目
1
45953 Crossfaith ORNAMENT TEE BLACK
27810 Crossfaith XENO レコード(MARBLE)
27811 Crossfaith GLITCH ON BLACK LONGSLEEVE SHIRT
27814 Crossfaith Snapback(2016Spring)
27816 Crossfaith Longsleeve Shirt(2016Spring)
27819 Crossfaith 限定デザイン Tシャツ
27820 Crossfaith 限定デザイン バンダナ
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL