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-20 04:38:01')
AND FIND_IN_SET(13, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 349)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 100
10件見つかりました
1ページ中1ページ目
1
XL 残り1点
¥20,900
TOY MACHINE
Jacket
¥18,700
TOY MACHINE
Jacket
¥16,500
TOY MACHINE
Bottoms
¥11,000
TOY MACHINE
Pullover
完売
¥18,000 → 9,000
TOY MACHINE
Jacket
¥6,600
TOY MACHINE
Hat
¥6,050
TOY MACHINE
Cap
完売
¥5,500
TOY MACHINE
Cap
完売
¥5,390
TOY MACHINE
Cap
完売
¥5,390
TOY MACHINE
Cap
10件見つかりました
1ページ中1ページ目
1
70893 TOY MACHINE (トイマシーン) VACCINE GET INJECTED DENIM JACKET ONE WASH
69719 TOY MACHINE (トイマシーン) DESTROYS WIND TRACK JACKET NAVY
70895 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM PANTS ONE WASH
69722 TOY MACHINE (トイマシーン) BLOOD HAND SWEAT PARKA NAVY
61695 TOY MACHINE (トイマシーン) TM & EYE STADIUM JACKET NAVY
69219 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY TWILL HAT NAVY
66781 TOY MACHINE (トイマシーン) MARKED MONSTER SIX PANEL CAP(NAVY)
61693 TOY MACHINE (トイマシーン) FLAME FIST BB CAP RED
52935 TOY MACHINE TMP20HW26 CAP NAVY
53165 TOY MACHINE TMS20HW12 BB CAP NAVY