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 =6
)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-05-18 07:29:18')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 365)
AND pc.del_flg = 0
GROUP BY p.product_id
LIMIT 0, 60
9件見つかりました
1ページ中1ページ目
1
完売
¥31,680 → 9,504
Anti Social Social Club
L/S Shirt
完売
¥31,680 → 9,504
Anti Social Social Club
L/S Shirt
完売
¥18,700
PARADOX
L/S Shirt
完売
¥18,700
PARADOX
L/S Shirt
完売
¥15,730 → 7,865
SALUTE
L/S Shirt
完売
¥15,730 → 7,865
SALUTE
L/S Shirt
完売
¥25,300 → 12,650
Anti Social Social Club
L/S Shirt
2XL 残り1点
¥25,300
Anti Social Social Club
L/S Shirt
完売
¥25,300 → 7,590
Anti Social Social Club
L/S Shirt
9件見つかりました
1ページ中1ページ目
1
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
56032 PARADOX PRINTED CHECK SHIRTS (GREY)
56033 PARADOX PRINTED CHECK SHIRTS (BLUE)
56892 SALUTE DESERT SHIRT
56894 SALUTE RACING PRINTER SHIRT
60153 Anti Social Social Club BORED GAMES PURPLE FLANNEL
60154 Anti Social Social Club BORED GAMES YELLOW FLANNEL
60155 Anti Social Social Club BORED GAMES BROWN FLANNEL