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-23 01:34:53')
AND pc.price02 > 9090
AND price02 <= 13636
AND FIND_IN_SET(3, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 365)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
10件見つかりました
1ページ中1ページ目
1
完売
¥27,500 → 13,750
FOG ESSENTIALS
Sweatshirt
¥13,500
Anti Social Social Club
T-Shirt
完売
¥25,000 → 12,500
Anti Social Social Club
Pullover
¥12,100
PARADOX
L/S T-Shirt
完売
¥12,100
PARADOX
L/S T-Shirt
¥11,550
Anti Social Social Club
T-Shirt
完売
¥11,000
N.B.O.
L/S T-Shirt
¥11,000
Anti Social Social Club
T-Shirt
完売
¥11,000
Anti Social Social Club
T-Shirt
完売
¥11,000
Anti Social Social Club
Cap
10件見つかりました
1ページ中1ページ目
1
56768 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts WHITE
56213 Anti Social Social Club Headrush All Over White Tee
56204 Anti Social Social Club Headrush All Over White Hoodie
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
57812 PARADOX SELECTABLE LAYERED T-SHIRTS BLACK×WHITE
60165 Anti Social Social Club THE REAL ME WHITE TEE
56124 N.B.O. FLOWER PRINT T
56210 Anti Social Social Club Enrique White Vneck Tee
56212 Anti Social Social Club Arkansas White Tee
56215 Anti Social Social Club Headrush Cap