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 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-04-18 13:50:20')
AND pc.stock > 0
AND FIND_IN_SET(13, p.color)
AND pc.classcategory_id1 IN( 159)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
11件見つかりました
1ページ中1ページ目
1
2XL 残り1点
¥6,600
SCENE TOKYO
T-Shirt
¥6,600
SCENE TOKYO
T-Shirt
2XL 残り1点
¥5,500
Subciety
T-Shirt
¥14,300
Subciety
Sweatshirt
¥6,600
over print
T-Shirt
2XL 残り1点
¥11,000
RUDIE'S
Coach Jacket
¥6,050
SCENE TOKYO
T-Shirt
¥6,050
SCENE TOKYO
T-Shirt
2XL 残り1点
¥7,150
NIRVANA
L/S T-Shirt
¥4,180
THRASHER
T-Shirts
2XL 残り1点
¥17,600
Subciety
Jacket
11件見つかりました
1ページ中1ページ目
1
71266 SCENE TOKYO (シーントウキョウ) soft cream Tee (sulate)
71260 SCENE TOKYO (シーントウキョウ) game girl Tee (indigo)
64193 Subciety (サブサエティ) THE BASE S/S NAVY
70477 Subciety(サブサエティ) DAMAGED SWEAT NAVY
71043 over print (オーバープリント) PIZZA PRICE Tee navy
22867 RUDIE'S (ルーディーズ) DRAWING COACH JKT NAVY
69093 SCENE TOKYO (シーントウキョウ) Retro girl Tee NAVY
69091 SCENE TOKYO (シーントウキョウ) Skate girl Tee NAVY
69351 NIRVANA UNISEX LONG SLEEVE T-SHIRT: ANGELIC GRADIENT (BACK & SLEEVE PRINT)
28396 THRASHER (スラッシャー) TH8101 MAG LOGO TEE NAV/WHT
65188 Subciety (サブサエティ) NYLON JKT-NAVY