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 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-05-23 16:37:12')
AND pc.stock > 0
AND FIND_IN_SET(5, p.color)
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 60
9件見つかりました
1ページ中1ページ目
1
フリー 残り1点
¥29,700
HEDWiNG
Jacket
フリー 残り1点
¥14,080
VIRGOwearworks
Bag
¥9,350
HYPER CORE
Sweatshirt
フリー 残り1点
¥6,600
TOY MACHINE
Beanie
¥6,200
NieR
Pullover
¥5,940
VIRGOwearworks
Belt
フリー 残り1点
¥3,190
over print
Accessory
¥650
GYROAXIA×GEKIROCK CLOTHING
acrylic card
¥550
GYROAXIA×GEKIROCK CLOTHING
Badge
9件見つかりました
1ページ中1ページ目
1
68978 HEDWiNG (ヘドウィグ) Big Mods Coat KHAKI
64044 VIRGO(ヴァルゴ)PUFF DOWN SHOULDER BAG KHAKI
61601 HYPER CORE BOOSTスウェット KHAKI
69714 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY BEANIE OLIVE
70755 NieR (ニーア) TWO-TONE DOLMAN PULLOVER PARKA
70881 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt OD
67988 over print(オーバープリント) knit tie (green)
69117 GYROAXIA×GEKIROCK CLOTHINGコラボ限定トレーディングアクリル・カード
69116 GYROAXIA×GEKIROCK CLOTHINGコラボ限定トレーディング缶バッジ