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 =62
)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-26 14:41:39')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
15件見つかりました
1ページ中1ページ目
1
¥8,800
Artemis Kings
Accessory
¥7,700
Anti Social Social Club
Accessory
フリー 残り1点
¥7,700
Anti Social Social Club
mask
¥7,480
HYPER CORE
Accessory
¥6,490
GALFY
Accessory
¥6,490
GALFY
Accessory
フリー 残り1点
¥6,490
GALFY
Accessory
¥6,380
ANIMALIA
Accessory
¥6,050
ANIMALIA
Accessory
¥5,940
Subciety
Bracelet
¥5,940
Subciety
Bracelet
¥5,940
Subciety
Bracelet
¥5,940
Subciety
Bracelet
¥5,940
Subciety
Bracelet
フリー 残り1点
¥5,280
SABBAT13
Accessory
15件見つかりました
1ページ中1ページ目
1
65966 Artemis Kings(アルテミスキングス) クラウンセーフティーピン AKEX0003
56219 Anti Social Social Club 7734
56220 Anti Social Social Club Sadness Is Happiness
61603 HYPER CORE ロゴxボーダーフリンジマフラー
69538 GALFY (ガルフィー) チームマフラー BLACK
69540 GALFY (ガルフィー) チームマフラー BLUE
69544 GALFY (ガルフィー) チームマフラー RED
69745 ANIMALIA (アニマリア) CORDURA® SHORT MUFFLER BLACK
36879 ANIMALIA IQOSR Case (humboldt×ANIMALIA) (ORTEGA)
69764 Subciety (サブサエティ) TWIST COMBI CHAIN BRACELET SILVER/GOLD
69971 Subciety (サブサエティ) ANCHOR CHAIN BRACELET GOLD
69972 Subciety (サブサエティ) ANCHOR CHAIN BRACELET SILVER
69973 Subciety (サブサエティ) LINK CHAIN BRACELET GOLD
69974 Subciety (サブサエティ) LINK CHAIN BRACELET SILVER
65912 SABBAT13(サバトサーティーン) SPOOK BOA NECK WARMER (BK)