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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =62
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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 08:01:15')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.price02 > 4545
AND price02 <= 9090
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 77)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
10件見つかりました
1ページ中1ページ目
1
¥5,940
Subciety
Bracelet
¥5,940
Subciety
Bracelet
¥5,940
Subciety
Bracelet
¥5,940
Subciety
Bracelet
¥5,940
Subciety
Bracelet
完売
¥7,700
Subciety
Accessory
完売
¥5,500
Subciety
Accessory
完売
¥5,500
Subciety
Accessory
完売
¥5,500
Subciety
Accessory
完売
¥8,800
Subciety
Accessory
10件見つかりました
1ページ中1ページ目
1
69972 Subciety (サブサエティ) ANCHOR CHAIN BRACELET SILVER
69971 Subciety (サブサエティ) ANCHOR CHAIN BRACELET GOLD
69974 Subciety (サブサエティ) LINK CHAIN BRACELET SILVER
69973 Subciety (サブサエティ) LINK CHAIN BRACELET GOLD
69764 Subciety (サブサエティ) TWIST COMBI CHAIN BRACELET SILVER/GOLD
56514 Subciety (サブサエティ) DOWN MUFFLER BLACK
25923 Subciety (サブサエティ) ROVING SNOOD BLACK
25924 Subciety (サブサエティ) ROVING SNOOD GRAY
25925 Subciety (サブサエティ) ROVING SNOOD NAVY
39697 Subciety KEY CASE BLACK