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-20 06:36:55')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 770)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
8件見つかりました
1ページ中1ページ目
1
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
¥14,080
SALUTE
Necklace
フリー 残り1点
¥14,850
Anti Social Social Club
Cap
XS 残り1点
¥11,900
acOlaSia
Shoes
L 残り1点
¥24,200
MUSIC SAVED MY LIFE
Knit
L 残り1点
¥14,300
N.B.O.
Bottoms
¥5,280
CHORD NUMBER EIGHT
Necklace
23cm 残り1点
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
8件見つかりました
1ページ中1ページ目
1
57074 SLIGHTLY NUMB×Kappa shoes BLACK
57795 SALUTE EVAE* X BLACKLUX NECKLACE
55640 【予約商品】Anti Social Social Club WEIRD CAP BLACK
54736 acOlaSia “LOT””SKULL”ハイカットスニーカー BLACK
56849 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT PINK
56122 N.B.O. BLUE FLARED DENIM PANTS
50649 CHORD NUMBER EIGHT CHA1-01K5-AC09 CROSS NECKLACE
57073 SLIGHTLY NUMB×Kappa shoes WHITE