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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =571
)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-05-22 03:20:24')
AND pc.price02 > 9090
AND price02 <= 13636
AND FIND_IN_SET(14, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
12件見つかりました
1ページ中1ページ目
1
完売
¥14,740
PUNK DRUNKERS
S/S Shirt
完売
¥14,080
PUNK DRUNKERS
S/S Shirt
完売
¥11,880
SLIGHTLY NUMB
S/S Shirt
完売
¥13,200
MISHKA
S/S Shirt
完売
¥10,780
TRAVAS TOKYO
S/S Shirt
完売
¥10,780
TRAVAS TOKYO
S/S Shirts
完売
¥11,880
GALFY
S/S Shirts
完売
¥11,880
GALFY
S/S Shirts
¥14,300
RIPNDIP
S/S Shirts
¥14,300
SABBAT13
S/S Shirt
¥13,200
TOY MACHINE
S/S Shirt
¥13,200
SABBAT13
S/S Shirt
12件見つかりました
1ページ中1ページ目
1
54712 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 総柄ベアシャツ BLUE
54717 PUNK DRUNKERS 2FACE開衿シャツ BLUE
57072 SLIGHTLY NUMB SAPPY ALOHA SHIRT
58580 MISHKA(ミシカ) M21000208 S/S Shirt
64250 TRAVAS TOKYO【トラバストーキョー】Sailor collar H/S Shirts Sax Blue
65006 TRAVAS TOKYO【トラバストーキョー】 配色ニットポロシャツ/Blue(ブルー)
67573 GALFY (ガルフィー) デニムわんちゃんボロボロシャツ BLUE
67575 GALFY (ガルフィー) デニムわんちゃんボロボロシャツ SAX
68532 RIPNDIP (リップンディップ) Pablo Button Up MISTY BLUE
68593 SABBAT13(サバトサーティーン) SPOOK CUBA SHIRTS GREEN
69278 TOY MACHINE (トイマシーン) FIST WAPPEN STRIPE LOOSE FIT SS SHIRTS BLUE
71747 SABBAT13(サバトサーティーン)13HANDS MARIA S/S SHIRTS (BL)