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 >= '2023-02-09 12:28:21')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 685)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
7件見つかりました
1ページ中1ページ目
1
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
23cm 残り1点
¥16,280
SLIGHTLY NUMB×Kappa
Shoes
フリー 残り1点
¥13,037
SLIGHTLY NUMB
Sweater
¥6,926
SLIGHTLY NUMB
T-Shirt
M 残り1点
¥7,480
SLIGHTLY NUMB
T-Shirt
S 残り1点
¥8,580
SLIGHTLY NUMB
L/S T-Shirt
¥17,380
SLIGHTLY NUMB
Skirt
7件見つかりました
1ページ中1ページ目
1
57074 SLIGHTLY NUMB×Kappa shoes BLACK
57073 SLIGHTLY NUMB×Kappa shoes WHITE
44003 SLIGHTLY NUMB HYPNOTIZ KNIT SWEATER BLACK
44006 SLIGHTLY NUMB UGLYBOY TEE WHITE
51699 SLIGHTLY NUMB HELEN FORDSDALE TEE WHITE
51703 SLIGHTLY NUMB HONG KONG GARDEN TEE
51704 SLIGHTLY NUMB DOUBLE LIFE SKIRT