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-20 08:25:06')
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 120, 120
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