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 =1
)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-19 13:14:03')
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, 240
68006 【BanG Dream! ×ゲキクロ 2023 ver.】チュチュ×RUDIE'S コラボ Tシャツ
68459 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T WHITE
68458 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T BLACK
68293 RUDIE'S (ルーディーズ) EXTRA DRAWING-T WHITE
68294 RUDIE'S (ルーディーズ) EXTRA DRAWING-T BLACK
65284 渡月 麗×RUDIE'S コラボ 限定 Tシャツ
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
35489 RUDIE'S (ルーディーズ) SPARK-Tee BLK/WHT
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK
66247 RUDIE'S (ルーディーズ) 2023 福袋 NEWYEAR PACK
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
65604 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (BK)
65606 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (GR)
65605 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (WH)
62809 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN TRICYCLE TEE WHITE
62810 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN TRICYCLE TEE BLACK
62805 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN DREADROCK TEE WHITE
62806 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN DREADROCK TEE BLACK
62803 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN BENISASORITAI TEE WHITE
62804 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN BENISASORITAI TEE BLACK
62807 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN LOCALFEST TEE WHITE
62808 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN LOCALFEST TEE BLACK
63182 RUDIE'S (ルーディーズ) HELLO-T WHITE
63183 RUDIE'S (ルーディーズ) HELLO-T NAVY
63184 RUDIE'S (ルーディーズ) HELLO-T BLACK
8105 RUDIE'S (ルーディーズ) SPARK Tee BLACK/WHITE
63136 RUDIE'S (ルーディーズ) DONUTS PHAT-T WHITE
63137 RUDIE'S (ルーディーズ) DONUTS PHAT-T BLACK
63138 RUDIE'S (ルーディーズ) MICROPHONE SLICK-T WHITE
63139 RUDIE'S (ルーディーズ) MICROPHONE SLICK-T BLACK
60342 RUDIE'S (ルーディーズ) VITAMIN PHAT-T BLACK
60343 RUDIE'S (ルーディーズ) VITAMIN PHAT-T WHITE
60344 RUDIE'S (ルーディーズ) SAFARI PHAT-T BLACK
60345 RUDIE'S (ルーディーズ) SAFARI PHAT-T WHITE
60346 RUDIE'S (ルーディーズ) MUSHROOM PHAT-T BLACK
60347 RUDIE'S (ルーディーズ) MUSHROOM PHAT-T WHITE
60260 RUDIE'S (ルーディーズ) SLICK BIGSILHOUETTE-T BLACK
60261 RUDIE'S (ルーディーズ) SLICK BIGSILHOUETTE PKT-T WHITE
58072 RUDIE'S x CRAYON SHINCHAN PEACE PKT-T BLACK
58073 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN PEACE PKT-T WHITE
58077 RUDIE'S x CRAYON SHINCHAN MICROPHONE-T BLACK
58078 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN MICROPHONE-T ORANGE
58079 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN ACTIONKAMEN-T BLACK
58080 RUDIE'S x CRAYON SHINCHAN ACTIONKAMEN-T LAVENDER
58081 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN FAMILY-T BLACK
58082 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN FAMILY-T NATURAL
58406 RUDIE'S GUESTPASS-T WHITE
58407 RUDIE'S GUESTPASS-T CORALBEIGE
58409 RUDIE'S GOOD VIBRATION BIGSILHOUETTE PKT-T WHITE
58408 RUDIE'S (ルーディーズ) GUESTPASS-T BLACK
58410 RUDIE'S (ルーディーズ) GOOD VIBRATION BIGSILHOUETTE PKT-T BLACK
58411 RUDIE'S (ルーディーズ) PHAT BIGSILHOUETTE-T WHITE
58412 RUDIE'S (ルーディーズ) PHAT BIGSILHOUETTE-T BLACK
57089 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T BLACK
57090 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T WHITE
55743 【バンドリ!×ゲキクロ 第2弾復刻】RUDIE'S×チュチュ コラボ 限定 Tシャツ
11076 RUDIE'S (ルーディーズ) FULL EFFECT Tee WHITE
13215 RUDIE'S (ルーディーズ) FIGHT THE FAKE-Tee BLACK
24171 RUDIE'S (ルーディーズ) VICE-T BLACK
24429 RUDIE'S (ルーディーズ) MARIONETTE-T
25455 RUDIE'S (ルーディーズ) VULTURE-T BLACK
35571 RUDIE'S (ルーディーズ) PHAT DYED-T RAINBOW
36554 RUDIE'S (ルーディーズ) REAPER TEE WHITE
36556 RUDIE'S (ルーディーズ) COBRA TEE WHITE
36559 RUDIE'S (ルーディーズ) CLOWN TEE BLACK
47369 RUDIE'S (ルーディーズ) MONSTER-T BURGUNDY
49891 RUDIE'S (ルーディーズ) GRAVE-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
24330 RUDIE'S DRAWING-T WHITE
55839 RUDIE'S SOLID PHAT BIGSILHOUETTE PKT-T WHITE
55840 RUDIE'S SOLID PHAT BIGSILHOUETTE PKT-T NAVY
54475 【バンドリ!×ゲキクロ第1弾復刻】RUDIE'S×牛込りみコラボ 限定 Tシャツ
54602 RUDIE'S BOTANICAL PHAT-T WHITE
54599 RUDIE'S BOTANICAL PHAT-T BLACK
54647 RUDIE'S SOLID PHAT GRADATION-T WHITE
54645 RUDIE'S OMOTEURA-T WHITE
54646 RUDIE'S OMOTEURA-T BLACK
54601 RUDIE'S MUDDY SKULL-T WHITE
54600 RUDIE'S MUDDY SKULL-T BLACK
7609 RUDIE'S DYED BORDER BEAS-Tee YELLOW/NAVY
8103 RUDIE'S SPARK Tee WHITE/BLACK
11495 RUDIE'S DIG Tee BLACK
11708 RUDIE'S BIG-R Tee WHITE
11709 RUDIE'S BIG-R Tee TURQUOISE
12197 RUDIE'S × 梅村妃奈子 COLLABORATION-Tee BLACK/WHITE
12198 RUDIE'S × 梅村妃奈子 COLLABORATION-Tee WHITE/BLACK
12402 RUDIE'S TRUTH Tee BLACK
13150 RUDIE'S SEEK NO FAME-Tee BLACK
14098 ANGRY FROG REBIRTH RUDIE'S×AFR BLACK
14099 ANGRY FROG REBIRTH RUDIE'S×AFR WHITE
15925 RUDIE'S BRILLIANT Tee BLACK/PURPLE
15927 RUDIE'S BRILLIANT Tee BLACK/PINK
16795 RUDIE'S TUSK Tee BLACK
17390 RUDIE'S MELT SPARK-Tee WHITE
17735 RUDIE'S TUSK ALLOVER PKT-Tee BLACK
17879 RUDIE'S TRILL V-NECK Tee WHITE
17903 RUDIE'S FULL10 FRIDAY-T BLACK
17904 RUDIE'S FULL10 FRIDAY-T LIGHT BLUE
18222 RUDIE'S PASTE-T GRAY
18225 RUDIE'S SABOTAGE-TBLACK/WHITE
18226 RUDIE'S SABOTAGE-T BLACK/PURPLE
18227 RUDIE'S SABOTAGE-T BLACK/ORANGE
18242 RUDIE'S BLAST-T WHITE
18885 RUDIE'S FLW SLIT Tee GRAY/WHITE
18936 RUDIE'S BUST A MOVE-T GREEN
18937 RUDIE'S BUST A MOVE-T WHITE
18941 RUDIE'S MELT SPARK DRYMESH-T LIGHT BLUE
19135 RUDIE'S FREELY HENLEY-NECK Tee BLACK
19141 RUDIE'S TRILL Tee BLACK
20142 RUDIE'S ROCK IT RUDIES-T BLACK
22873 RUDIE'S JU-KENxRUDIE'S PASTE-T
23803 RUDIE'S BIT SPARK-T WHITE
24172 RUDIE'S VICE-T WHITE
24329 RUDIE'S DRAWING-T BLACK
24376 RUDIE'S DISCHARGE-T
24377 RUDIE'S HUMMING-T
24542 RUDIE'S BIG SILHOUETTE PKT-T BLACK
24543 RUDIE'S BIG SILHOUETTE PKT-T WHITE
24544 RUDIE'S LONG LENGTH-T BLACK
24545 RUDIE'S LONG LENGTH-T WHITE
24811 RUDIE'S DECAY TIGER STRIPE DYED-T BLACK
24812 RUDIE'S DECAY TIGER STRIPE DYED-T BLUE
24855 RUDIE'S KHAOS-T BLACK
24856 RUDIE'S KHAOS-T WHITE
25183 RUDIE'S RUDIE'SxMOGA PHOTOGRAPH-T WHITE
25184 RUDIE'S RUDIE'SxMOGA PURPLE GEEK-T
25456 RUDIE'S VULTURE-T WHITE
25457 RUDIE'S OWL-T BLACK
25458 RUDIE'S OWL-T WHITE
25459 RUDIE'S BRUSH-T BLACK
25461 RUDIE'S BRUSH-T WHITE
25463 RUDIE'S 瑠泥頭-T BLACK
25464 RUDIE'S 瑠泥頭-T WHITE
26214 RUDIE'S DISCHARGE SCREW DYED-T BLACK
26215 RUDIE'S DISCHARGE SCREW DYED-T BLUE
26216 RUDIE'S DISCHARGE SCREW DYED-T ORANGE
26623 RUDIE'S BRUTE-T
26624 RUDIE'S PENGUIN-T
26625 RUDIE'S SHARK-T
26626 RUDIE'S NINEONE COLLEGE-T BLUE
26627 RUDIE'S NINEONE COLLEGE-T WHITE
26628 RUDIE'S NINEONE COLLEGE-T BLACK
26629 RUDIE'S EIGHTEEN COLLEGE LONG LENGTH-T WHITE
26630 RUDIE'S EIGHTEEN COLLEGE LONG LENGTH-T GREY
26631 RUDIE'S EIGHTEEN COLLEGE LONG LENGTH-T BLACK
28080 RUDIE'S PASTE SPARK-T BLACK
28081 RUDIE'S PASTE SPARK-T WHITE
28082 RUDIE'S SMASH SPARK-T BLACK
28083 RUDIE'S SMASH SPARK-T WHITE
28084 RUDIE'S AGAINST SPARK-T BLACK
28085 RUDIE'S AGAINST SPARK-T BLUE
28086 RUDIE'S HEADPHONE-T BLACK
28087 RUDIE'S HEADPHONE-T WHITE
28088 RUDIE'S MICROPHONE-T BLACK
28089 RUDIE'S MICROPHONE-T WHITE
28236 RUDIE'S FELT SPARK LOGO TEE WHT
28681 RUDIE'S NEO GENERATION-T CHARCOAL
28682 RUDIE'S NEO GENERATION-T WHITE
28683 RUDIE'S NEO GENERATION-T BLACK
28814 RUDIE'S PHAT-T BLU
28815 RUDIE'S PHAT-T RED
33623 RUDIE'S Nothing's Carved In Stone x RUDIE'S DRAWING-T BLACK
33624 RUDIE'S Nothing's Carved In Stone x RUDIE'S DRAWING-T WHITE
33918 RUDIE'S BIT BIG SPARK-T BLACK
33919 RUDIE'S BIT BIG SPARK-T WHITE
33920 RUDIE'S GALAXY BIG SPARK-T
34134 RUDIE'S SKULL-T BLACK
34137 RUDIE'S SKULL-T WHITE
34140 RUDIE'S MARIA-T BLACK
34143 RUDIE'S MARIA-T WHITE
34339 RUDIE'S SOLID PHAT-T WHITE
34340 RUDIE'S SOLID PHAT-T GRAY
34341 RUDIE'S SOLID PHAT-T TURQUOISE BLUE
34342 RUDIE'S SOLID PHAT-T PURPLE
34343 RUDIE'S SOLID PHAT-T BLACK
34373 RUDIE'S RAT-T
34374 RUDIE'S LADYBUG-T
34375 RUDIE'S FROG-T
35033 RUDIE'S DRAWING PKT TEE BLK
35034 RUDIE'S DRAWING PKT TEE WHT
35035 RUDIE'S DRAWING DYED TEE VRS
35037 RUDIE'S DRAWING DYED TEE T.STR
35041 RUDIE'S DRAWING DYED TEE SRW
35303 RUDIE'S HEXAGRAM VICE-T BLACK/EMISSION
35304 RUDIE'S HEXAGRAM VICE-T BLACK/GRADATION
35305 RUDIE'S CONFUSE-T BLACK
35306 RUDIE'S CONFUSE-T WHITE
35491 RUDIE'S GALAXY BIG SPARK-T WHT
35565 RUDIE'S COLLEGE-T PURPLE
35568 RUDIE'S PHAT DYED-T AERIAL
35572 RUDIE'S DRAWING NINEONE-T BLACK
35577 RUDIE'S DRAWING NINEONE-T WHITE
35579 RUDIE'S DRAWING NINEONE-T GRAY
35582 RUDIE'S COLLEGE-T WHITE
36555 RUDIE'S REAPER TEE BLACK
36557 RUDIE'S COBRA TEE BLACK
36558 RUDIE'S CLOWN TEE WHITE
36560 RUDIE'S TIGER TEE
36561 RUDIE'S BAT TEE
36562 RUDIE'S CHAMELEON TEE
36917 RUDIE'S SLICK-T BLACK
36918 RUDIE'S SLICK-T WHITE
36919 RUDIE'S PHAT-T GRY
37109 RUDIE'S RIP SPARK-T BLACK
37110 RUDIE'S RIP SPARK-T WHITE
37112 RUDIE'S HEAD GEAR BRILLIANT SNAPBACKCAP BL/BLK
39885 RUDIE'S GRADATION SPARK-T WHITE
39886 RUDIE'S GRADATION SPARK-T BLACK
40492 RUDIE'S BRILLIANT SPLASH GALAXY-T BLACK
40493 RUDIE'S BRILLIANT SPLASH GALAXY-T WHITE
40494 RUDIE'S PHAT-T NAVY
40495 RUDIE'S PHAT-T BURGUNDY
40496 RUDIE'S PHAT-T YELLOW
40817 RUDIE'S DRIP SPARK-T BLACK
40818 RUDIE'S DRIP SPARK-T WHITE
40819 RUDIE'S CRASH SPARK-T BLACK
40820 RUDIE'S CRASH SPARK-T WHITE
40875 RUDIE'S COLLEGE BORDER CUTSEW BLACK/WHITE
40876 RUDIE'S COLLEGE BORDER CUTSEW BLUE/WHITE
40877 RUDIE'S COLLEGE BORDER CUTSEW RED/WHITE
40891 RUDIE'S PHAT LONG LENGTH-T BLACK
40892 RUDIE'S PHAT LONG LENGTH-T WHITE
40893 RUDIE'S PHAT COLLEGE-T BLACK
40894 RUDIE'S PHAT COLLEGE-T RED
40895 RUDIE'S PHAT COLLEGE-T WHITE
40896 RUDIE'S DRAWING BALL-T BLACK
40897 RUDIE'S DRAWING BALL-T BLUE
40898 RUDIE'S DRAWING BALL-T WHITE
40899 RUDIE'S SPOIL-T BLACK/BLUE
40900 RUDIE'S SPOIL-T BLACK/GREEN
40901 RUDIE'S SPOIL-T BLACK/PINK
40902 RUDIE'S GUITARBONES-T BLACK
40903 RUDIE'S MASTER-T BLACK
40904 RUDIE'S FRANKEN-T BLACK
40905 RUDIE'S DEVIL-T BLACK
40906 RUDIE'S MUMMY-T BLACK