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