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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =593
)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-28 20:48:57')
AND pc.price02 > 4545
AND price02 <= 9090
AND FIND_IN_SET(14, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
10件見つかりました
1ページ中1ページ目
1
完売
¥5,280
ROLLING CRADLE
Bag
完売
¥5,280
ROLLING CRADLE
Bag
完売
¥6,050
Civil Regime
Bag
完売
¥6,600
PUNK DRUNKERS
bag
完売
¥6,930
TOY MACHINE
Bag
完売
¥7,150
SLEEPING TABLET
bag
完売
¥7,500
XrossOver
Bag
完売
¥7,700
RUDIE'S
Bag
完売
¥9,350
MISHKA
Bag
¥9,680
glamb
Bag
10件見つかりました
1ページ中1ページ目
1
39417 ROLLING CRADLE RC CHEMICAL TOTE BAG GREEN
39418 ROLLING CRADLE RC CHEMICAL TOTE BAG RED
43404 Civil Regime Cross Body Bag In Blue
22846 PUNK DRUNKERS トートリュック BLUE
56746 TOY MACHINE BOA FLEECE TOTE BAG - WHITE
51166 SLEEPING TABLET PATIENT [ VELOUR TOTE BAG ] NAVY
58055 XrossOver XOver logoBug
47064 RUDIE'S SPARK WAISTBAG BLUE
57375 MISHKA M21003106 BAG
65695 glamb (グラム) GB0422/AC03 : Denim Sacoche Bag / デニムサコッシュバッグ - Light indigo