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 =16
)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-03-29 07:28:47')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
9件見つかりました
1ページ中1ページ目
1
¥9,350
FILA
Shoes
¥9,350
FILA
Shoes
26cm 残り1点
¥9,900
SLAYERxDC SHOES
Shoes
¥8,800
SLAYERxDC SHOES
Shoes
¥9,130
RIPNDIP
Shoes
¥8,140
FILA
Shoes
¥9,900
FILA
Shoes
24cm 残り1点
¥7,920
KILL STAR CLOTHING
Shoes
25cm 残り1点
¥7,700
KILL STAR CLOTHING
Shoes
9件見つかりました
1ページ中1ページ目
1
71093 FILA (フィラ) Distorter Premium BLACK
71092 FILA (フィラ) Distorter Premium WHITE
69776 SLAYERxDC SHOES(ディーシーシューズ) MANUAL HI
69777 SLAYERxDC SHOES(ディーシーシューズ) MANUAL SLIP
60645 RIPNDIP Marker Slip On Shoes
54071 FILA DISRUPTOR SD WHITE
53888 FILA F0494-1092 DISRUPTOR2 ICE ORANGE
44814 KILL STAR CLOTHING Ceremony Flat [B]
44832 KILL STAR CLOTHING Keiko Kitty Flats [B]