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-20 07:14:38')
AND FIND_IN_SET(21, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 349)
AND pc.del_flg = 0
GROUP BY p.product_id
LIMIT 0, 60
7件見つかりました
1ページ中1ページ目
1
完売
¥6,490
TOY MACHINE
T-Shirt
完売
¥6,490 → 1,947
TOY MACHINE
T-Shirt
完売
¥6,490 → 3,245
TOY MACHINE
T-Shirt
完売
¥6,490 → 1,947
TOY MACHINE
T-shirts
完売
¥6,490 → 1,947
TOY MACHINE
T-shirts
完売
¥6,490 → 1,947
TOY MACHINE
T-shirts
完売
¥6,490 → 3,245
TOY MACHINE
T-shirts
7件見つかりました
1ページ中1ページ目
1
54208 TOY MACHINE SKATE SECT TIE-DYE SST - BLAST
54209 TOY MACHINE SKATE SECT TIE-DYE SST - PINK
54210 TOY MACHINE SKATE SECT TIE-DYE SST - SATURN
58781 TOY MACHINE (トイマシーン) DESIGN PRINT TEE LEMON
58782 TOY MACHINE (トイマシーン) DESIGN PRINT TEE PINK
58784 TOY MACHINE (トイマシーン) DESIGN PRINT TEE FUNNEL CAKE
58785 TOY MACHINE (トイマシーン) DESIGN PRINT TEE COTTON CANDY