SELECT SQL_CALC_FOUND_ROWS 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-26 22:40:51')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 662)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
6件見つかりました
1ページ中1ページ目
1
完売
¥9,900
RUDIE'S x NCIS
Pullover
完売
¥9,900
RUDIE'S x NCIS
Pullover
完売
¥9,900
RUDIE'S x NCIS
Pullover
完売
¥4,950
RUDIE'S x NCIS
Pullover
完売
¥4,400
RUDIE'S x NCIS
Cap
完売
¥4,400
RUDIE'S x NCIS
Cap
6件見つかりました
1ページ中1ページ目
1
39355 RUDIE'S Nothing's Carved In StonexRUDIE'S PROGRESSIVE HOOD SWEAT BLACK
39356 RUDIE'S Nothing's Carved In StonexRUDIE'S PROGRESSIVE HOOD SWEAT GRAY
45699 RUDIE'S "Nothing's Carved In StonexRUDIE'S COLLEGE HOOD SWEAT" BLACK
45700 RUDIE'S "Nothing's Carved In StonexRUDIE'S COLLEGE HOOD SWEAT" GRAY
45701 RUDIE'S "Nothing's Carved In StonexRUDIE'S COLLEGE PANELCAP" BLACK
45702 RUDIE'S "Nothing's Carved In StonexRUDIE'S COLLEGE PANELCAP" DENIM