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 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-05-07 14:09:42')
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 MAX(price02)
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
完売
¥509
NEW BREED
Rubber Bracelet
完売
¥510
NEW BREED
Rubber Bracelet
完売
¥713
NEW BREED
Key Holder
完売
¥713
NEW BREED
Key Holder
完売
¥713
NEW BREED
Key Holder
完売
¥2,037
NEW BREED
T-Shirt
¥2,548
NEW BREED
T-Shirt
¥2,548
NEW BREED
T-Shirt
完売
¥2,548
NEW BREED
T-Shirt
完売
¥3,056
NEW BREED
T-Shirt
完売
¥4,584
NEW BREED
Hoodie
11件見つかりました
1ページ中1ページ目
1
15551 NEW BREED Rubber band BLK
15552 NEW BREED Rubber band WHT
12742 NEW BREED ORIGINAL KEY HOLDER BLUE
12743 NEW BREED ORIGINAL KEY HOLDER GRAY
12745 NEW BREED ORIGINAL KEY HOLDER GREEN
11335 NEW BREED BREAK ON THROUGH T-Shirt
13900 NEW BREED The DIVIDE TEE
15549 NEW BREED SKULL TEE
15550 NEW BREED OWL TEE
12725 NEW BREED BACK PRINT T-Shirt BLACK
15548 NEW BREED SKULL HOODIE