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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =209
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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 20:21:49')
AND pc.price02 > 909
AND price02 <= 2727
AND FIND_IN_SET(12, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
完売
¥1,650
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,320
ZOX STRAPS
List band
完売
¥1,650
ZOX STRAPS
List band
完売
¥1,320
MISS FORTUNE
Rubber Bracelet
完売
¥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
完売
¥2,640
ROLLING CRADLE
Accessory
11件見つかりました
1ページ中1ページ目
1
21196 ZOX STRAPS FRESH HEADBAND
21248 ZOX STRAPS LABYRINTH
21429 ZOX STRAPS MONA
21433 ZOX STRAPS CANARY
25226 MISS FORTUNE Logo Green (Glow In The Dark) - Wristband
27574 ZOX STRAPS UNKNOWN
27577 ZOX STRAPS ADVENTURE AWAITS
29751 ZOX STRAPS HAPPY TO BE HERE
29759 ZOX STRAPS SAME TEAM
29761 ZOX STRAPS GROWTH
37075 ROLLING CRADLE RC LEATHER WRIST BAND / Olive