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 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-30 20:00:00')
AND FIND_IN_SET(11, p.color)
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
ORDER BY p.update_date DESC
LIMIT 0, 75
12件見つかりました
1ページ中1ページ目
1
完売
¥5,500
Anti Social Social Club
Socks
完売
¥25,300 → 12,650
Anti Social Social Club
L/S Shirt
完売
¥11,000
Anti Social Social Club
Cap
完売
¥8,580
SALUTE
Bracelet
完売
¥9,680 → 4,840
SALUTE
T-Shirt
¥25,000
Anti Social Social Club
Pullover
完売
¥25,000 → 12,500
Anti Social Social Club
Pullover
¥13,500
Anti Social Social Club
T-Shirt
完売
¥8,250
PARADOX
T-Shirt
完売
¥9,900
PARADOX
T-Shirt
完売
¥275
DOGTOWN
STICKER
完売
¥16,500
SALUTE
Pullover
12件見つかりました
1ページ中1ページ目
1
63301 Anti Social Social Club Collapse Black Socks
60153 Anti Social Social Club BORED GAMES PURPLE FLANNEL
56215 Anti Social Social Club Headrush Cap
55893 SALUTE FLOWER ANARCHY BRACELET
55894 SALUTE WASHED FLOWER VINTAGE TEE PURPLE
56202 Anti Social Social Club True Colors Purple Camo
56204 Anti Social Social Club Headrush All Over White Hoodie
56213 Anti Social Social Club Headrush All Over White Tee
55531 PARADOX PX17-BT01 GRAPHIC BIG T-SHIRTS(NEVER SATISFIED) LIGHT PURPLE
54596 PARADOX PX17-CS03 BIG WIDE TEE PURPLE
38183 DOGTOWN DOGTOWN STICKER 4
52495 SALUTE REMADE HOODIE