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-23 11:37:10')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.classcategory_id1 IN( 159)
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
LIMIT 0, 60
52937 RUDIE'S DRAWING HOOD SWEAT WHITE
52938 RUDIE'S DRAWING HOOD SWEAT BLACK
54021 RUDIE'S DRAWING LS-T BLACK
54022 RUDIE'S DRAWING LS-T WHITE
55321 RUDIE'S x CRAYON SHINCHAN GUITAR-T WHITE
55322 RUDIE'S x CRAYON SHINCHAN GUITAR-T BLACK
55323 RUDIE'S x CRAYON SHINCHAN MOSH-T WHITE
55324 RUDIE'S x CRAYON SHINCHAN MOSH-T BLACK
56092 RUDIE'S GOOD VIBRATION LS-T BLACK
56093 RUDIE'S GOOD VIBRATION LS-T WHITE
56094 RUDIE'S GUESTPASS LS-T WHITE
56095 RUDIE'S GUESTPASS LS-T BLACK
56275 RUDIE'S SLICK HOOD SWEAT BLACK
56276 RUDIE'S SLICK HOOD SWEAT BURGUNDY
56277 RUDIE'S BOTANICAL PHAT HOOD SWEAT BLACK
56853 RUDIE'S GOOD VIBRATION HOOD SWEAT BLACK
56854 RUDIE'S GOOD VIBRATION HOOD SWEAT WHITE
55743 【バンドリ!×ゲキクロ 第2弾復刻】RUDIE'S×チュチュ コラボ 限定 Tシャツ
57089 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T BLACK
57090 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T WHITE
58003 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT PINK
58335 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T WHITE
58336 RUDIE'S GOOD VIBRATION LS-T LAVENDER
56278 RUDIE'S BOTANICAL PHAT HOOD SWEAT WHITE
58071 RUDIE'S x CRAYON SHINCHAN HEADPHONE LS-T WHITE
58070 RUDIE'S x CRAYON SHINCHAN HEADPHONE LS-T BLACK
55319 RUDIE'S x CRAYON SHINCHAN SKATE LS-T WHITE
55320 RUDIE'S x CRAYON SHINCHAN SKATE LS-T BLACK
60355 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T GRADATION LOGO NAVY
60358 RUDIE'S (ルーディーズ) PHAT LS-T WHITE
60339 RUDIE'S (ルーディーズ) PHAT EMBROIDERY HOOD SWEAT WHITE
60341 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT GRAY
52873 【バンドリ!×ゲキクロ 第5弾復刻】RUDIE’S×弦巻 こころコラボ 限定 L/S Tシャツ
60828 A’×RUDIE'S×GEKIROCK CLOTHING コラボ・ロンT
61821 RUDIE'S (ルーディーズ) BRINK PHAT HOOD SWEAT RED
62939 RUDIE'S (ルーディーズ) HELLO LS-T WHITE
62800 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN KASUKABE VIBRATION LS-T BLACK
62799 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN KASUKABE VIBRATION LS-T WHITE
62802 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN SNACK LS-T BLACK
62801 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN SNACK LS-T WHITE
62803 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN BENISASORITAI TEE WHITE
62806 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN DREADROCK TEE BLACK
62805 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN DREADROCK TEE WHITE
62810 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN TRICYCLE TEE BLACK
62809 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN TRICYCLE TEE WHITE
63830 B.O.L.T×RUDIE'S×GEKIROCK CLOTHING コラボ・ロングTシャツ PINK×BLACK
63832 B.O.L.T×RUDIE'S×GEKIROCK CLOTHING コラボ・ロングTシャツ YELLOW×BLACK
63833 B.O.L.T×RUDIE'S×GEKIROCK CLOTHING コラボ・プルオーバーパーカー BLACK
63835 B.O.L.T×RUDIE'S×GEKIROCK CLOTHING コラボ・プルオーバーパーカー CHARCOAL GRAY
65796 RUDIE'S (ルーディーズ) BRINK PHAT LS-T-ブラック
65799 RUDIE'S (ルーディーズ) COLLEGE LS-T-BLACK
65800 RUDIE'S (ルーディーズ) COLLEGE LS-T-WHITE
65858 RUDIE'S (ルーディーズ) BANDGIRL HOOD SWEAT
66709 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN RABBIT CREW SWEAT BLACK
67467 RUDIE'S(ルーディーズ) SHADOW LOGO LS TEE DGY
67466 RUDIE'S(ルーディーズ) SHADOW LOGO LS TEE BLACK
65284 渡月 麗×RUDIE'S コラボ 限定 Tシャツ
67406 愛本りんく × RUDIE'S コラボ限定ロンT
68006 【BanG Dream! ×ゲキクロ 2023 ver.】チュチュ×RUDIE'S コラボ Tシャツ
69488 RUDIE'S (ルーディーズ) THICK PHAT LSTEE BLACK