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 (
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-05-22 02:34:37')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 437)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 180
14件見つかりました
1ページ中1ページ目
1
完売
¥7,480
SABBAT13
Bag
完売
¥4,400
SABBAT13
Bag
フリー 残り1点
¥4,400
SABBAT13
Bag
完売
¥4,180
SABBAT13
Bag
完売
¥4,180
SABBAT13
Bag
完売
¥3,300
SABBAT13
Bag
完売
¥3,300
SABBAT13
Bag
完売
¥3,300
SABBAT13
Bag
完売
¥3,300
SABBAT13
Bag
完売
¥3,300
SABBAT13
Bag
完売
¥3,300
SABBAT13
Bag
完売
¥3,300
SABBAT13
Bag
¥2,750
SABBAT13
Bag
完売
¥2,750
SABBAT13
Bag
14件見つかりました
1ページ中1ページ目
1
56107 SABBAT13 SCARER BODY BAG
60617 SABBAT13 PARADISE LOST TOTE BAG BLACK
60618 SABBAT13 PARADISE LOST TOTE BAG BEIGE
54115 SABBAT13 SCARE WAIST POUCH BLACK
54116 SABBAT13 SCARE WAIST POUCH GREEN
54080 SABBAT13 YOKAI TRUMP POUCH (ブラック)
58531 SABBAT13 GHOST PURCE ブラック
58532 SABBAT13 GHOST PURCE ベージュ
58533 SABBAT13 GHOST PURCE オリーブ
64150 SABBAT13(サバトサーティーン) OUT GRAVE PURCE(BK)
64151 SABBAT13(サバトサーティーン) OUT GRAVE PURCE(BG)
64506 SABBAT13(サバトサーティーン) OUT GRAVE PURCE (OL)
68393 SABBAT13(サバトサーティーン) POSTHUMOUS LUNCH BAG (BLACK)
68394 SABBAT13(サバトサーティーン) POSTHUMOUS LUNCH BAG (CAMO)