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-25 05:16:43')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(2, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 543)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
13件見つかりました
1ページ中1ページ目
1
完売
¥6,600
AA=
Zip Hoodie
完売
¥5,602
PassCode
Sweatshirt
完売
¥5,602
Xmas Eileen
Zip Hoodie
完売
¥4,840
Survive Said The Prophet
T-Shirt
完売
¥4,585
ENTH
Hoodie
完売
¥3,056
ANGRY FROG REBIRTH
Long T-Shirt
完売
¥3,056
a crowd of rebellion
Accessory
¥2,852
Crossfaith
Cap
完売
¥2,547
Xmas Eileen
T-Shirt
完売
¥2,547
a crowd of rebellion
T-Shirt
完売
¥1,650
AA=
Towel
完売
¥1,019
Xmas Eileen
Keyholder
完売
¥509
バックドロップシンデレラ
Badge
13件見つかりました
1ページ中1ページ目
1
34425 AA= #5 JACKET PARKA
29036 PassCode CREW NECK SWEAT (GRAY)『CHAIN』
37842 Xmas Eileen DIS IS LOVEパーカー(グレー)
52943 Survive Said The Prophet RIDE THE FIRE TEE
23821 ENTH LOGO HOODIE GRAY
11333 ANGRY FROG REBIRTH logo Raglan T-Shirt GRAY
34352 a crowd of rebellion 10th Anniversary Tour 2017 Mobile Battery
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL
34155 Xmas Eileen Xmas Eileen カレッジTシャツ GRAY
34344 a crowd of rebellion 10th Anniversary Tour 2017 T-Shirts Charcoal Gray
34428 AA= #5 TOWEL (GY)
37826 Xmas Eileen パフォーマーキーホルダー
16742 バックドロップシンデレラ ペリー缶バッヂ(大)