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 =598
)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-30 21:14:02')
AND FIND_IN_SET(1, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 95)
AND pc.del_flg = 0
GROUP BY p.product_id
LIMIT 0, 120
14件見つかりました
1ページ中1ページ目
1
完売
¥275
RUDIE'S
Pin Badge
完売
¥275
RUDIE'S
Pin Badge
完売
¥275
RUDIE'S
Pin Badge
完売
¥385
RUDIE'S
Pin Badge
完売
¥385
RUDIE'S
Pin Badge
完売
¥385
RUDIE'S
Pin Badge
完売
¥385
RUDIE'S
Pin Badge
完売
¥385
RUDIE'S
Pin Badge
完売
¥495
RUDIE'S
Pin Badge
完売
¥330
RUDIE'S
Badge
¥330
RUDIE'S
Badge
フリー 残り1点
¥330
RUDIE'S
Badge
完売
¥330
RUDIE'S
Badge
完売
¥330
RUDIE'S
Badge
14件見つかりました
1ページ中1ページ目
1
10356 RUDIE'S SPARK BADGE BLACK/WHITE
10362 RUDIE'S MGM BADGE BLACK/WHITE
10363 RUDIE'S MGM BADGE BLACK/PINK
10365 RUDIE'S ONE THIRD BADGE BLACK/WHITE
10366 RUDIE'S ONE THIRD BADGE BLACK/RED
10367 RUDIE'S ONE THIRD BADGE BLACK/BLUE
10368 RUDIE'S GLIDE BADGE BLACK
10371 RUDIE'S GRENADES BADGE BLACK/WHITE
10374 RUDIE'S ThorRat BADGE BLACK/WHITE
36563 RUDIE'S (ルーディーズ) CAN BADGE DRAWING BLACK
36566 RUDIE'S (ルーディーズ) CAN BADGE SOLID PHAT BLACK
36570 RUDIE'S (ルーディーズ) CAN BADGE BRILLIANT GALAXY BLACK
36571 RUDIE'S CAN BADGE BRILLIANT GALAXY WHITE
36572 RUDIE'S CAN BADGE RIP SPARK BLACK