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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =328
)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-25 15:29:18')
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
ORDER BY p.update_date DESC
LIMIT 0, 120
13件見つかりました
1ページ中1ページ目
1
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650 → 1,155
RUDIE'S
Socks
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650
RUDIE'S x CRAYON SHINCHAN
Socks
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650
RUDIE'S
Socks
完売
¥1,650
RUDIE'S
Socks
13件見つかりました
1ページ中1ページ目
1
68291 RUDIE'S(ルーディーズ)CURVY SOCKS WHITE / BLACK
68290 RUDIE'S(ルーディーズ)CURVY SOCKS WHITE / NAVY
63749 RUDIE'S (ルーディーズ) PHAT SOCKS WHITE
63750 RUDIE'S (ルーディーズ) PHAT SOCKS BLACK
58089 RUDIE'S x CRAYON SHINCHAN PEACE SOCKS LAVENDER
43162 RUDIE'S PHAT SOCKS BLACK
43163 RUDIE'S PHAT SOCKS WHITE
46238 RUDIE'S DRAWING SOCKS BLACK
46239 RUDIE'S DRAWING SOCKS WHITE
49892 RUDIE'S MIGHTY SOCKS BLACK
49893 RUDIE'S MIGHTY SOCKS WHITE
54023 RUDIE'S MIGHTY SOCKS BLACK
54024 RUDIE'S MIGHTY SOCKS WHITE