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-23 21:56:48')
AND FIND_IN_SET(8, 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
ORDER BY p.update_date
LIMIT 0, 120
9件見つかりました
1ページ中1ページ目
1
完売
¥6,490 → 1,947
TOY MACHINE
T-Shirt
¥5,390
TOY MACHINE
Cap
完売
¥10,780
TOY MACHINE
Pullover
完売
¥6,380
TOY MACHINE × HELLO KITTY
Cap
完売
¥8,580
TOY MACHINE
Shorts
完売
¥4,950
TOY MACHINE
T-Shirt
完売
¥6,490 → 1,947
TOY MACHINE
T-shirts
完売
¥6,490 → 1,947
TOY MACHINE
T-shirts
完売
¥6,490 → 3,245
TOY MACHINE
T-shirts
9件見つかりました
1ページ中1ページ目
1
54209 TOY MACHINE SKATE SECT TIE-DYE SST - PINK
57319 TOY MACHINE NEW BLOOD LOGO SIX PANEL CAP(SMOKE PINK)
58029 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - L. PINK
58039 TOY MACHINE TOYMONSTER HELLO KITTY EMB SIX PANEL CAP - PINK
58584 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS PINK
58591 TOY MACHINE CHARACTERS SS TEE PINK
58782 TOY MACHINE (トイマシーン) DESIGN PRINT TEE PINK
58784 TOY MACHINE (トイマシーン) DESIGN PRINT TEE FUNNEL CAKE
58785 TOY MACHINE (トイマシーン) DESIGN PRINT TEE COTTON CANDY