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-04-28 09:48:56')
AND FIND_IN_SET(2, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 333)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 100
10件見つかりました
1ページ中1ページ目
1
完売
¥4,620
SANTA CRUZ
T-Shirt
¥4,620
SANTA CRUZ
T-Shirt
完売
¥2,090
SANTA CRUZ
Socks
完売
¥3,080
SANTA CRUZ
Belt
完売
¥12,100
SANTA CRUZ
Zip Hoodie
完売
¥2,090
SANTA CRUZ
Socks
完売
¥4,620
SANTA CRUZ
Beanie
完売
¥10,230
SANTA CRUZ
Sweatshirt
完売
¥5,390
SANTA CRUZ
L/S T-Shirt
完売
¥12,650
MAGICAL MOSH MISFITS
Pullover
10件見つかりました
1ページ中1ページ目
1
39907 SANTA CRUZ Classic Dot S/S T-Shirt Charcoal
39908 SANTA CRUZ Classic Dot S/S T-Shirt Silver
39914 SANTA CRUZ Hand Socks Gray
39929 SANTA CRUZ Classic Dot Belt Charchoal
44028 SANTA CRUZ EDGE DPT LS HODED GRAY
44036 SANTA CRUZ SPANGLE SOCKS GRAY
44050 SANTA CRUZ SCREAMING HAND BEANIE GRAY
49469 SANTA CRUZ DOT EMBROIDERY CREW NECK MIDWEIGHT SWEATSHIRT GREY HEATHER
49472 SANTA CRUZ CLASSIC DOT L/S REGULAR T-SHIRT CHARCOAL HEATHER
52298 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL DRIP DOT” HOODIE GRAY