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-26 20:11:06')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.classcategory_id1 IN( 159)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 804)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 240
12件見つかりました
1ページ中1ページ目
1
完売
¥4,180 → 2,090
AFFECTER
L/S T-Shirt
完売
¥4,180
AFFECTER
L/S T-Shirt
完売
¥4,180
AFFECTER
L/S T-Shirt
完売
¥4,180 → 2,090
AFFECTER
L/S T-Shirt
完売
¥7,480
AFFECTER
Pullover
完売
¥7,480 → 2,244
AFFECTER
Pullover
2XL 残り1点
¥7,480
AFFECTER
Pullover
完売
¥7,480 → 2,244
AFFECTER
Pullover
完売
¥7,700
AFFECTER
Sweatshirt
完売
¥8,030
AFFECTER
Pullover
完売
¥7,480
AFFECTER
Pullover
完売
¥7,480 → 3,740
AFFECTER
Pullover
12件見つかりました
1ページ中1ページ目
1
63698 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Gray
63699 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Black
63700 AFFECTER (アフェクター) CHAOS L/S Tee Orange
63701 AFFECTER (アフェクター) CHAOS L/S Tee Black
61153 AFFECTER (アフェクター) LIGHTNING HOODIE BLACK
61154 AFFECTER (アフェクター) LIGHTNING HOODIE GREEN
61155 AFFECTER (アフェクター) AFF TM HOODIE BLACK
61156 AFFECTER (アフェクター) AFF TM HOODIE NAVY
61157 AFFECTER (アフェクター) OIL CREWNECK BLACK
61149 AFFECTER (アフェクター) NESS HOODIE BLACK
61151 AFFECTER (アフェクター) TAG HOODIE BLACK
61152 AFFECTER (アフェクター) TAG HOODIE GRAY