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-25 15:49:47')
AND pc.stock > 0
AND FIND_IN_SET(9, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 77)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
¥9,900
Subciety
S/S Shirt
¥9,900
Subciety
S/S Shirt
¥15,400
Subciety
S/S Shirt
¥7,700
Subciety
Bag
XL 残り1点
¥18,700
Subciety
Jacket
¥18,700
Subciety
Knit
¥22,000
Subciety
Happy bag
¥15,400
Subciety
Pullover
¥7,150
NARUTO-ナルト- 疾風伝 × Subciety
T-Shirt
¥9,350
Subciety
Hat
S 残り1点
¥5,500
Subciety
T-Shirt
11件見つかりました
1ページ中1ページ目
1
71510 Subciety(サブサエティ) JACQUARD PAISLEY SHIRT ORANGE
71507 Subciety(サブサエティ) OPEN COLLAR STRIPE SHIRT CAMEL
71245 Subciety(サブサエティ) FLOWER PAISLEY SHIRT ORANGE
70775 Subciety (サブサエティ) FLOWER PAISLEY BODY BAG ORANGE
69381 Subciety (サブサエティ) BUFFALO CHECK SHIRT JKT ORANGE
69385 Subciety (サブサエティ) BANDANNA KNIT BROWN
60561 Subciety 2022 福袋 -NEW YEAR BAG-
65491 Subciety (サブサエティ) CHENILLE COLLEGE PARKA-ORANGE
58460 NARUTO-ナルト- 疾風伝 ×Subciety NARUTO S/S ORANGE
56293 Subciety (サブサエティ) TROOPER HAT ORANGE
42882 Subciety THE BASE S/S - ORANGE/WHITE