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-20 09:18:17')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 412)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 240
11件見つかりました
1ページ中1ページ目
1
完売
¥2,037
NEW BREED
T-Shirt
完売
¥3,056
NEW BREED
T-Shirt
完売
¥713
NEW BREED
Key Holder
完売
¥713
NEW BREED
Key Holder
完売
¥713
NEW BREED
Key Holder
¥2,548
NEW BREED
T-Shirt
完売
¥4,584
NEW BREED
Hoodie
¥2,548
NEW BREED
T-Shirt
完売
¥2,548
NEW BREED
T-Shirt
完売
¥509
NEW BREED
Rubber Bracelet
完売
¥510
NEW BREED
Rubber Bracelet
11件見つかりました
1ページ中1ページ目
1
11335 NEW BREED BREAK ON THROUGH T-Shirt
12725 NEW BREED BACK PRINT T-Shirt BLACK
12742 NEW BREED ORIGINAL KEY HOLDER BLUE
12743 NEW BREED ORIGINAL KEY HOLDER GRAY
12745 NEW BREED ORIGINAL KEY HOLDER GREEN
13900 NEW BREED The DIVIDE TEE
15548 NEW BREED SKULL HOODIE
15549 NEW BREED SKULL TEE
15550 NEW BREED OWL TEE
15551 NEW BREED Rubber band BLK
15552 NEW BREED Rubber band WHT