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 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-03-28 22:08:14')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 250)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 480, 120
29450 NineMicrophones (ナインマイクロフォンズ) TANK TOP-how high- WHITE
29451 NineMicrophones (ナインマイクロフォンズ) TANK TOP-how high- BLACK
29453 NineMicrophones (ナインマイクロフォンズ) WORK PANTS-RADICAL ROUTINE- BEIGE
29467 NineMicrophones (ナインマイクロフォンズ) CHAMBLEY SNAP BACK CAP-Lightning- BLACK
29469 NineMicrophones (ナインマイクロフォンズ) BANDANNA BRIM HAT BLACK
29470 NineMicrophones (ナインマイクロフォンズ) BANDANNA BRIM HAT CAMEL
29481 NineMicrophones (ナインマイクロフォンズ) iphone6,7 case-Back stage- BLACK
32095 NineMicrophones SNAP BACK CAP -Comrade- BLACK/YELLOW
32096 NineMicrophones SNAP BACK CAP -Comrade- WHITE/BLACK
32097 NineMicrophones SNAP BACK CAP -Comrade- BLACK/WHITE
32928 NineMicrophones ALOHA SHIRT-Pizzalia- WHITE
32929 NineMicrophones ALOHA SHIRT-Pizzalia- BLACK
32930 NineMicrophones Bowling SHIRT S/S-Studio- WHITE
32931 NineMicrophones Bowling SHIRT S/S-Studio- BLACK
32932 NineMicrophones BIG TEE S/S-Comrade- WHITE
32933 NineMicrophones BIG TEE S/S-Comrade- BLACK
32939 NineMicrophones Pass the mic S/S GRAY
32940 NineMicrophones Pass the mic S/S BURGUNDY
32956 NineMicrophones V-NECK TEE S/S -INK- WHITE
32957 NineMicrophones V-NECK TEE S/S -INK- BLACK
32976 NineMicrophones ALOHA SHORTS-Pizzalia- WHITE
32977 NineMicrophones ALOHA SHORTS-Pizzalia- BLACK
32978 NineMicrophones WORK SHORTS-how high- BLACK
32979 NineMicrophones WORK SHORTS-how high- KHAKI
32981 NineMicrophones SNAPBACKCAP-how high- BLACK-WHITE
32982 NineMicrophones SNAPBACKCAP-how high- BLACK-RED
32983 NineMicrophones SNAPBACKCAP-how high- WHITE-BLACK
32990 NineMicrophones SNAP BACK CAP-Comrade- BLACK-BURGUNDY
32992 NineMicrophones KEY TAG BLACK
32993 NineMicrophones KEY TAG RED
32994 NineMicrophones KEY TAG BLUE
32997 NineMicrophones Signet ring-9MC Crew- A.SILVER
32998 NineMicrophones Signet ring-9MC Crew- SILVER
33014 NineMicrophones 69LOGO TEE S/S WHITE-BLACK
33015 NineMicrophones 69LOGO TEE S/S BLACK-WHITE
33016 NineMicrophones 69LOGO TEE S/S BLACK-BURGUNDY
33017 NineMicrophones K PHOTO TEE L/S WHITE-RED
33018 NineMicrophones K PHOTO TEE L/S BLACK-WHITE
33019 NineMicrophones K PHOTO TEE L/S BLACK-BURGUNDY
33020 NineMicrophones 69YIN-YANG TANK TOP WHITE-BLACK
33021 NineMicrophones 69YIN-YANG TANK TOP BLACK-WHITE
33022 NineMicrophones 69YIN-YANG TANK TOP BLACK-BURGUNDY
33023 NineMicrophones ROLL SKIRT WHITE
33024 NineMicrophones ROLL SKIRT BLACK
33025 NineMicrophones 69MESH CAP WHITE-BLACK
33026 NineMicrophones 69MESH CAP WHITE-BURGUNDY
33027 NineMicrophones 69MESH CAP BLACK
33028 NineMicrophones 69SNAP BACK CAP WHITE-BURGUNDY
33029 NineMicrophones 69SNAP BACK CAP BLACK-WHITE
33030 NineMicrophones 69SNAP BACK CAP BLACK-BURGUNDY
33031 NineMicrophones SAND CLOCK BANDANNA WHITE
34826 NineMicrophones COACH JACKET-Rebel label- BLACK
34827 NineMicrophones COACH JACKET-Rebel label- GREEN
34828 NineMicrophones COACH JACKET-how high- BLACK-WHITE
34829 NineMicrophones COACH JACKET-how high- BLACK-YELLOW
34830 NineMicrophones COACH JACKET-how high- BURGUNDY
34831 NineMicrophones STADIUM JACKET BLACK
34832 NineMicrophones MA-1-9MC Crew- BLACK
34833 NineMicrophones MA-1-9MC Crew- OD
34834 NineMicrophones NATIVE MELTON JACKET BLUE
34835 NineMicrophones NATIVE MELTON JACKET RED
34837 NineMicrophones CRAZY COACH JACKET B
34839 NineMicrophones PARKA-DELTA- GRAY
34840 NineMicrophones PARKA-DELTA- ORANGE
34844 NineMicrophones PARKA-9MC CREW- BLACK-WHITE
34845 NineMicrophones PARKA-9MC CREW- GRAY-NAVY
34846 NineMicrophones PARKA-9MC CREW- BURGUNDY-MUSTARD
34853 NineMicrophones INDIGO CHECK SHIRT L/S RED
34854 NineMicrophones INDIGO CHECK SHIRT L/S YELLOW
34855 NineMicrophones INDIGO CHECK SHIRT L/S KHAKI
34856 NineMicrophones TWIST CHECK SHIRT L/S BLACK
34857 NineMicrophones TWIST CHECK SHIRT L/S NAVY
34861 NineMicrophones WORK SHIRT L/S-ANTI- WHITE
34862 NineMicrophones WORK SHIRT L/S-ANTI- BLACK
34863 NineMicrophones WORK SHIRT L/S-ANTI- BLUE
34866 NineMicrophones Comrade L/S WHITE
34867 NineMicrophones Comrade L/S BLACK
34870 NineMicrophones howhigh L/S WHITE
34871 NineMicrophones howhigh L/S BLACK
34872 NineMicrophones LOCAL S/S WHITE
34873 NineMicrophones LOCAL S/S BLACK
34874 NineMicrophones COMPANY S/S WHITE
34875 NineMicrophones COMPANY S/S BLACK
34876 NineMicrophones Crown S/S WHITE
34877 NineMicrophones Crown S/S BLACK
34878 NineMicrophones Crown S/S YELLOW
34887 NineMicrophones BEANIE-Comrade- BLACK
34888 NineMicrophones BEANIE-Comrade- MUSTARD
34889 NineMicrophones BEANIE-Comrade- BURGUNDY
34890 NineMicrophones WATCHCAP-howhigh- BLACK-WHITE
34891 NineMicrophones WATCHCAP-howhigh- BLACK-YELLOW
34895 NineMicrophones SNAP BACK CAP-how high- BLK-YELLOW
34898 NineMicrophones SNAPBACKCAP-Comrade- BLACK-GOLD
34899 NineMicrophones POW MIA BRACELET BLACK
34900 NineMicrophones POW MIA BRACELET RED
37852 NineMicrophones-COACH JACKET-9MC Crew-WHITE/BLACK
37853 NineMicrophones COACH JACKET-9MC Crew- BLACK/WHITE
37855 NineMicrophones DENIM MODS COAT INDIGO
37861 NineMicrophones PARKA-Pray with the microphones- GRAY/BLACK
37864 NineMicrophones DOLMAN SLEEVE SHIRT WHITE
37875 NineMicrophones 9MC Crew L/S WHITE/PINK
37881 NineMicrophones Fellow S/S WHITE
37882 NineMicrophones Fellow S/S BLACK
37891 NineMicrophones BEANIE BLACK/BURGUNDY
37892 NineMicrophones low cap 9mc crew BLACK/WHITE
37893 NineMicrophones low cap 9mc crew WHITE/BLACK
37903 NineMicrophones NYLON WEB BELT BLACK
39049 NineMicrophones DROP SHOULDER SWEATSHIRTS GRAY
39050 NineMicrophones DROP SHOULDER SWEATSHIRTS BLACK
39051 NineMicrophones DROP SHOULDER SWEATSHIRTS WHITE
39710 NineMicrophones JERSEY SHIRT IVORY
39711 NineMicrophones JERSEY SHIRT NAVY
39712 NineMicrophones CHECK GATHERD SHIRT RED
39713 NineMicrophones CHECK GATHERD SHIRT NAVY
39721 NineMicrophones PROMOTION WHITE
39722 NineMicrophones PROMOTION BLACK
39725 NineMicrophones FAINT WHITE
39726 NineMicrophones FAINT BLACK
39727 NineMicrophones STRONGER WHITE
39728 NineMicrophones STRONGER GRAY