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-22 06:52:28')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND FIND_IN_SET(13, p.color)
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
14件見つかりました
1ページ中1ページ目
1
XL 残り1点
¥9,900
DEFTONES
Pullover
¥7,700
Subciety
T-Shirt
XL 残り1点
¥7,590
GALFY
L/S T-Shirt
¥7,150
NIRVANA
L/S T-Shirt
XL 残り1点
¥6,600
Subciety
T-Shirt
¥6,600
over print
T-Shirt
¥6,600
over print
L/S T-Shirt
¥6,600
SCENE TOKYO
T-Shirt
XL 残り1点
¥6,600
SCENE TOKYO
T-Shirt
XL 残り1点
¥6,050
RUDIE'S×SABBAT13
7/S T-Shirt
¥6,050
SCENE TOKYO
T-Shirt
¥6,050
over print
L/S T-Shirt
¥5,940
HEDWiNG
T-Shirt
XL 残り1点
¥5,390
FILA
L/S T-Shirt
14件見つかりました
1ページ中1ページ目
1
69359 DEFTONES UNISEX PULLOVER HOODIE: AROUND THE FUR NAVY BLUE
71513 Subciety(サブサエティ) SCRATCHED PIGMENT TEE NAVY
68972 GALFY (ガルフィー) 直球系ラグランロンTee NAVY×GRAY
69351 NIRVANA UNISEX LONG SLEEVE T-SHIRT: ANGELIC GRADIENT (BACK & SLEEVE PRINT)
64311 Subciety (サブサエティ) LEAGUE TEE NAVY
71043 over print (オーバープリント) PIZZA PRICE Tee navy
71051 over print (オーバープリント) rock, paper, scissors Paperboy LS Tee navy
71260 SCENE TOKYO (シーントウキョウ) game girl Tee (indigo)
71266 SCENE TOKYO (シーントウキョウ) soft cream Tee (sulate)
65603 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S RAGLAN T" (NV/WH)
69093 SCENE TOKYO (シーントウキョウ) Retro girl Tee NAVY
71065 over print (オーバープリント) blue LS Tee ash black
68469 HEDWiNG (ヘドウィグ) Shark Eat World T-Shirt SLATE BLUE
57389 FILA FS3027 L/S T-Shirt NAVY