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 =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-19 04:49:58')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 666)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
17件見つかりました
1ページ中1ページ目
1
完売
¥6,800
FILA×EVANGELION
Bag
完売
¥6,800 → 2,041
FILA×EVANGELION
Bag
完売
¥6,490
FILA
Bag
完売
¥5,390
FILA
Bag
完売
¥4,290
FILA
Bag
完売
¥4,290
FILA
Bag
完売
¥4,290
FILA
Bag
完売
¥4,290
FILA
Bag
完売
¥4,290
FILA
Bag
完売
¥4,290
FILA
Bag
完売
¥4,290
FILA
Bag
完売
¥4,290
FILA
Bag
完売
¥4,950
FILA
Bag
完売
¥4,950
FILA
Bag
完売
¥4,290
FILA
Bag
完売
¥5,390
FILA
Bag
完売
¥6,490
FILA
Bag
17件見つかりました
1ページ中1ページ目
1
61033 FILA MINI SHOULDER BAG EVANGELION LIMITED RED
61032 FILA MINI SHOULDER BAG EVANGELION LIMITED PURPLE
57398 FILA BM1140 TOTE BAG
57399 FILA BM1141 BAG
49085 FILA FHD001 BAG BLACK
49086 FILA FHD001 BAG GREEN
49087 FILA FHD001 BAG NAVY
49088 FILA FHD001 BAG YELLOW
49089 FILA FHD002 BAG BLACK
49090 FILA FHD002 BAG GREEN
49091 FILA FHD002 BAG NAVY
49092 FILA FHD002 BAG YELLOW
49093 FILA FHD003 BAG BLACK
49094 FILA FHD003 BAG YELLOW
49095 FILA FHD004 BAG
49096 FILA FHD005 BAG
49097 FILA FHD006 BAG