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-27 09:51:53')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 495)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
15件見つかりました
1ページ中1ページ目
1
完売
¥3,666
LiST
T-Shirt
完売
¥3,769
LiST
T-Shirt
完売
¥3,769
LiST
T-Shirt
完売
¥3,666
LiST
T-Shirt
完売
¥3,666
LiST
T-Shirt
完売
¥3,666
LiST
T-Shirts
完売
¥3,666
LiST
T-Shirts
完売
¥3,666
LiST
T-Shirts
完売
¥4,888
LiST
Bag
完売
¥4,888
LiST
Bag
完売
¥3,769
LiST
T-Shirt
完売
¥3,769
LiST
T-Shirt
完売
¥3,769
LiST
T-Shirt
完売
¥3,769
LiST
T-Shirt
完売
¥3,769
LiST
T-Shirt
15件見つかりました
1ページ中1ページ目
1
21054 LiST Wピース T-shirt WHT/BLK
21055 LiST ビックシルエットT-shirt WHT/SIL
21056 LiST ビックシルエットT-shirt PNK/SIL
21057 LiST 羽クロスT-shirt BLK/WHT
21058 LiST 羽クロス T-shirt WHT/WHT
24481 LiST 羽クロス T-shirt WHT/BLK
24482 LiST Wピース T-shirt BLK/BLK
24483 LiST Wピース T-shirt BLK/WHT
24484 LiST BACK PACK BLACK
24485 LiST BACK PACK RED
28330 LiST Trash Can WHITE
28331 LiST Trash Can BLACK
28332 LiST Trash can GRAY
28333 LiST KOIYUBI BLACK
28334 LiST KOIYUBI WHITE