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-03-28 18:07:46')
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
7047 RUDIE'S (ルーディーズ) AGAINST-Tee BLACK/WHITE
7609 RUDIE'S DYED BORDER BEAS-Tee YELLOW/NAVY
8103 RUDIE'S SPARK Tee WHITE/BLACK
8105 RUDIE'S (ルーディーズ) SPARK Tee BLACK/WHITE
11076 RUDIE'S (ルーディーズ) FULL EFFECT Tee WHITE
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
13215 RUDIE'S (ルーディーズ) FIGHT THE FAKE-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
24171 RUDIE'S (ルーディーズ) VICE-T BLACK
24172 RUDIE'S VICE-T WHITE
24329 RUDIE'S DRAWING-T BLACK
24330 RUDIE'S DRAWING-T WHITE
24376 RUDIE'S DISCHARGE-T
24377 RUDIE'S HUMMING-T
24429 RUDIE'S (ルーディーズ) MARIONETTE-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
25455 RUDIE'S (ルーディーズ) VULTURE-T BLACK
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
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
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
35489 RUDIE'S (ルーディーズ) SPARK-Tee BLK/WHT
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK