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 =97
)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-28 13:40:09')
AND FIND_IN_SET(8, 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, 120
11件見つかりました
1ページ中1ページ目
1
完売
¥22,000
RUDIE'S
Happy bag
完売
¥6,600
RUDIE'S
L/S T-Shirt
完売
¥5,940
PUNK DRUNKERS
L/S T-Shirt
完売
¥6,050
DI:VISION
L/S T-Shirt
完売
¥6,490
OBEY
L/S T-Shirt
完売
¥7,150
SLEEPING TABLET
L/S T-Shirt
完売
¥2,805
RIP DESIGN WORXX
Happy Bag
完売
¥2,970
PUNK DRUNKERS
L/S T-Shirt
完売
¥3,575
REBEL8
L/S T-Shirt
完売
¥5,280
GoneR
L/S T-Shirt
完売
¥5,280
GoneR × LESSTRESS
L/S T-Shirt
11件見つかりました
1ページ中1ページ目
1
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
58336 RUDIE'S GOOD VIBRATION LS-T LAVENDER
54866 PUNK DRUNKERS 唐揚げおじさんロンTEE - LT.PINK
55668 ゲキクロ限定 DI:VISION UMBRELLA LS TEE PINK
41057 OBEY x Misfits 7'' Cover Basic Tee PINK
42825 SLEEPING TABLET ESCAPE LONG SLEEVE PINK
43117 RIP DESIGN WORXX 謎袋2018夏
43436 PUNK DRUNKERS 【PDSxタツノコプロ】ハクション大魔王トリックロンTEE LT.PINK
43813 REBEL8 LOVING MEMORY LONGSLEEVE TEE PINK
52625 GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts Light Pink
52642 GoneR × LESSTRESS GR24LSW00 GoneR × LESSTRESS L/S T-Shirts Light Pink