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-04 17:34:13')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 83)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 50
14件見つかりました
1ページ中1ページ目
1
¥3,960
METALLICA
T-Shirt
¥4,620
METALLICA
T-Shirt
¥4,620
METALLICA
T-Shirt
¥4,620
METALLICA
T-Shirt
¥4,620
METALLICA
T-Shirt
¥4,620
METALLICA
T-Shirt
¥4,620
METALLICA
T-Shirt
¥4,620
METALLICA
T-Shirt
¥4,899
METALLICA
Wallet
¥6,500
METALLICA
Bag
フリー 残り1点
¥9,800
METALLICA
Backpack
¥10,780
brokker×METALLICA
Block Toys
¥13,200
METALLICA
Pullover
¥13,200
METALLICA
14件見つかりました
1ページ中1ページ目
1
10236 METALLICA JUSTICE FOR ALL T-Shirt
700 METALLICA-KILL EM ALL
10233 METALLICA DORIS T-Shirt
10235 METALLICA VINTAGE METAL UP T-Shirt
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
62578 METALLICA FADE TO BLACK WALLET
62580 METALLICA KILL EM ALL CROSS BODY BAG
62576 METALLICA FADE TO BLACK DAYPACK BACKPACK
51173 brokker “METALLICA” フィギュア
69361 METALLICA UNISEX PULLOVER HOODIE: SKULL SCREAMING RED BLACK
70282 METALLICA UNISEX PULLOVER HOODIE: 72 SEASONS CHARRED LOGO (BACK PRINT)