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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =593
)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-04-20 13:55:49')
AND FIND_IN_SET(8, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
¥22,000
Subciety
Happy bag
完売
¥17,600
RIP DESIGN WORXX
Happy bag
完売
¥17,600
RIP DESIGN WORXX
Happy bag
完売
¥13,200 → 6,600
Anti Social Social Club
Bag
¥11,501
Anti Social Social Club
Bag
完売
¥14,000
Anti Social Social Club
Bag
完売
¥7,700 → 3,850
Anti Social Social Club
Bag
完売
¥13,200
IRON FIST CLOTHING
Bag
完売
¥3,080
フクザワ
Bag
完売
¥5,280
ROLLING CRADLE
Bag
完売
¥6,050 → 3,025
Civil Regime
Bag
11件見つかりました
1ページ中1ページ目
1
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
60145 Anti Social Social Club FRACTURE PINK
56898 Anti Social Social Club ICRIGHTHRUYOU
56216 Anti Social Social Club Belong 2 You Black Sidebag
56221 Anti Social Social Club My Bad Side Pink
7123 IRON FIST CLOTHING Sweets For My Sweets Purse
15167 フクザワ サブカル男子 ショルダーバッグ トロピカルピンク
28544 ROLLING CRADLE CYCLOPS SHOUT SACOCHE / Charcoal-Purple
43406 Civil Regime Cross Body Bag In Pink