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 =393
)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-18 20:24:45')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.classcategory_id1 IN( 11)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 240)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
11件見つかりました
1ページ中1ページ目
1
完売
¥7,150
MISHKA
Hoodie
完売
¥6,050
MISHKA
Hoodie
完売
¥6,600
MISHKA
Hoodie
完売
¥6,050
MISHKA
Hoodie
完売
¥6,050
MISHKA
Hoodie
完売
¥6,050
MISHKA
Hoodie
完売
¥6,600
MISHKA
zip hoodie
完売
¥7,150
MISHKA
Hoodie
完売
¥6,050
MISHKA
Hoodie
完売
¥6,050
MISHKA
Hoodie
完売
¥7,150
MISHKA
Zip Hoodie
11件見つかりました
1ページ中1ページ目
1
14773 MISHKA (ミシカ) ELEVATED REALM ZIP UP HOODIE
14911 MISHKA (ミシカ) CYRILLIC CANNABIS HOCKEY LACED PULLOVER
20316 MISHKA (ミシカ) KEEP WATCH PULLOVER HOODIE CAMO
20318 MISHKA (ミシカ) KEEP WATCH PULLOVER HOODIE RED
20319 MISHKA (ミシカ) KEEP WATCH PULLOVER HOODIE BLK/GRN
20320 MISHKA (ミシカ) KEEP WATCH PULLOVER HOODIE BLK/GID
20606 MISHKA (ミシカ) KEEP WATCH CREST ZIP UP HOODIE
21914 MISHKA (ミシカ) CYCO SPLIT KEEP WATCH PULLOVER
22066 MISHKA (ミシカ) GALAXY KEEP WATCH HOODIE BLACK
22067 MISHKA (ミシカ) GALAXY KEEP WATCH HOODIE WHITE
30002 MISHKA (ミシカ) LAMOUR SUPREME: SPLIT ICONS ZIP UP HOODIE BLACK