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 17:05:19')
AND FIND_IN_SET(12, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 635)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
6件見つかりました
1ページ中1ページ目
1
完売
¥17,600 → 5,280
MUSIC SAVED MY LIFE
Pullover
完売
¥9,900
MSML
Long T-Shirt
完売
¥4,400
MUSIC SAVED MY LIFE
Cap
完売
¥16,500
MUSIC SAVED MY LIFE
Pullover
完売
¥23,100
MUSIC SAVED MY LIFE
S/S Shirt
完売
¥19,800
MUSIC SAVED MY LIFE
S/S Shirt
6件見つかりました
1ページ中1ページ目
1
60414 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE GREEN
37647 MUSIC SAVED MY LIFE (MSML) FLAMINGO EMBROIDERY LONG SLEEVE TEE LEAF GREEN
45083 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP GREEN
45094 MUSIC SAVED MY LIFE (MSML) M1H5T-CS02 BIG HOODIE 18 GREEN
51604 【予約商品】MUSIC SAVED MY LIFE CROSSES OPEN COLLAR SHORT SLEEVE SHIRT WHITE
51660 MUSIC SAVED MY LIFE M201-02L1-SS02 MILITARY GRUNGE SHIRT KHAKI