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-21 23:45:58')
AND pc.price02 > 909
AND price02 <= 2727
AND FIND_IN_SET(5, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
9件見つかりました
1ページ中1ページ目
1
完売
¥4,950 → 1,485
PSYCHOLOGICAL METAMORPHOSIS
T-Shirt
完売
¥4,950 → 2,475
SABBAT13
T-Shirt
完売
¥2,200 → 1,100
RIPNDIP
Sticker
完売
¥4,180 → 1,254
AFFECTER
Hat
完売
¥6,490 → 1,947
THRASHER
Sweatshirt
完売
¥4,400 → 2,200
PSYCHOLOGICAL METAMORPHOSIS
T-Shirt
完売
¥2,547
BAND-MAID
Belt
完売
¥2,547
BAND-MAID
Belt
完売
¥2,200
RIP DESIGN WORXX
Belt
9件見つかりました
1ページ中1ページ目
1
62850 PSYCHOLOGICAL METAMORPHOSIS COLLEGE WIDE TEE - KHAKI
64149 SABBAT13(サバトサーティーン) STORY TELLING T (KH)
64304 RIPNDIP (リップンディップ) Summer Break Sticker Pack
61160 AFFECTER (アフェクター) TM BUCKET HAT OLIVE
61640 THRASHER (スラッシャー) TH94166VPL GONZ STROLEING CREW SWEAT SAND
59309 PSYCHOLOGICAL METAMORPHOSIS INVERSION LOGO TEE OLIVE
31667 BAND-MAID ガチャベルト カーキxホワイト
31668 BAND-MAID ガチャベルト カーキxブラック
53176 RIP DESIGN WORXX ブラサードベルト GREEN