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-24 19:35:02')
AND FIND_IN_SET(1, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 368)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
17件見つかりました
1ページ中1ページ目
1
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
17件見つかりました
1ページ中1ページ目
1
21323 ZOX STRAPS MAKE BELIEVE
21424 ZOX STRAPS TURBINE
27572 ZOX STRAPS THE FLORIST
27576 ZOX STRAPS TECH
27578 ZOX STRAPS VIGILANT
27579 ZOX STRAPS THE BIG APPLE
29030 ZOX STRAPS GEOMETRY
29749 ZOX STRAPS OUTSIDER
29768 ZOX STRAPS HARMONY
29769 ZOX STRAPS TAP TAP TAP
29775 ZOX STRAPS SPECTRUM
29778 ZOX STRAPS SAY I WON’T
29780 ZOX STRAPS WANDER
29824 ZOX STRAPS DEAD MEN TELL NO TALES
31802 ZOX STRAPS Mythical Creatures Pack FURY
31804 ZOX STRAPS Mythical Creatures Pack POWER
31805 ZOX STRAPS Mythical Creatures Pack MAJESTY