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 00:24:00')
AND pc.price02 > 0
AND price02 <= 909
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
9件見つかりました
1ページ中1ページ目
1
完売
¥3,300 → 990
Subciety
Necklace
完売
¥990
Subciety
Coin Case
完売
¥990
Subciety
Coin Case
完売
¥990
Subciety
Coin Case
完売
¥990
Subciety
Coin Case
完売
¥990
Subciety
Coin Case
完売
¥990
Subciety
Coin Case
完売
¥440
Subciety
Lighter
完売
¥550
Subciety
Pen
9件見つかりました
1ページ中1ページ目
1
18605 Subciety (サブサエティ) METAL NECKLACE-JESUS- ANTIQUE GOLD
7979 Subciety COIN CASE GREEN
7980 Subciety COIN CASE RED
7981 Subciety COIN CASE PURPLE
7982 Subciety COIN CASE BLACK
9020 Subciety COIN CASE YELLOW
17787 Subciety COIN CASE PPL
18681 Subciety LIGHTER-THE BASE- - BLACK
20935 Subciety PEN-THE BASE- BLACK