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 =1
)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-25 09:52:38')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND FIND_IN_SET(13, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
12件見つかりました
1ページ中1ページ目
1
¥7,700
Subciety
T-Shirt
¥6,600
SCENE TOKYO
T-Shirt
¥6,600
SCENE TOKYO
T-Shirt
¥5,500
Subciety
T-Shirt
L 残り1点
¥5,500
Subciety
T-Shirt
¥6,600
over print
T-Shirt
¥6,050
SCENE TOKYO
T-Shirt
¥6,050
SCENE TOKYO
T-Shirt
¥5,940
HEDWiNG
T-Shirt
¥6,600
Subciety
T-Shirt
S 残り1点
¥5,500
Subciety
T-Shirt
S 残り1点
¥6,380
Subciety
T-Shirt
12件見つかりました
1ページ中1ページ目
1
71513 Subciety(サブサエティ) SCRATCHED PIGMENT TEE NAVY
71266 SCENE TOKYO (シーントウキョウ) soft cream Tee (sulate)
71260 SCENE TOKYO (シーントウキョウ) game girl Tee (indigo)
64193 Subciety (サブサエティ) THE BASE S/S NAVY
64196 Subciety (サブサエティ) GLORIOUS S/S NAVY
71043 over print (オーバープリント) PIZZA PRICE Tee navy
69093 SCENE TOKYO (シーントウキョウ) Retro girl Tee NAVY
69091 SCENE TOKYO (シーントウキョウ) Skate girl Tee NAVY
68469 HEDWiNG (ヘドウィグ) Shark Eat World T-Shirt SLATE BLUE
64311 Subciety (サブサエティ) LEAGUE TEE NAVY
23111 Subciety SALOON S/S NAVY/YELLOW
23125 Subciety COLLEGE S/S NAVY/WHITE