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-28 08:41:44')
AND FIND_IN_SET(4, 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, 120
13件見つかりました
1ページ中1ページ目
1
完売
¥25,300 → 7,590
Anti Social Social Club
L/S Shirt
完売
¥16,500 → 4,950
FOG ESSENTIALS
L/S T-Shirt
完売
¥20,680
SALUTE
Pullover
完売
¥24,200
SALUTE
Bottoms
完売
¥43,780
FOG ESSENTIALS
Jacket
完売
¥4,950
REBEL8
Beanie
完売
¥2,750
REBEL8
Keychain
完売
¥13,200
REBEL8
Shirt
完売
¥6,050
REBEL8
Cap
完売
¥6,050
REBEL8
Cap
完売
¥13,200
REBEL8
L/S Shirt
完売
¥14,300
REBEL8
Pullover
完売
¥16,500
REBEL8
Hoodie
13件見つかりました
1ページ中1ページ目
1
60155 Anti Social Social Club BORED GAMES BROWN FLANNEL
57290 FOG ESSENTIALS FRONT LOGO LS TEE TAN
56895 SALUTE CACTUS PRINTER HOODIE
57069 SALUTE CACTUS PRINTER JEANS
56775 FOG ESSENTIALS PUFFER JACKET BROWN
9054 REBEL8 ALPINE RUST BEANIE
25133 REBEL8 ARROWHEAD LEATHER KEYCHAIN
29918 REBEL8 HARSH REALM FLANNEL
32364 REBEL8 TOAST TO THE WORST SNAPBACK
35074 REBEL8 Lakeview Snapback
37730 REBEL8 CHAPTER FLANNEL SHIRT
42892 REBEL8 EIGHTH PULLOVER HOODIE SAND
52583 REBEL8 Your Enemies Are Mine Pullover Hoodie