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-25 15:28:51')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 240)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 75
69290 MISHKA (ミシカ) M61200052 Embroidery Tee Ivory
69291 MISHKA (ミシカ) M61200052 Embroidery Black
69295 MISHKA (ミシカ) Printed Tee Black
68406 MISHKA (ミシカ) WASHED BEAR MOP TEE (BLACK/M21200006BLK)
68404 MISHKA (ミシカ) COLLAGE ARTWORK TEE (BLACK/M21200051BLK)
68219 MISHKA (ミシカ) K.W DAMAGED TEE M21200001 WHITE
68218 MISHKA (ミシカ) K.W DAMAGED TEE M21200001 BLACK
68408 MISHKA (ミシカ) WASHED BEAR MOP TEE (O.WHITE/M21200006WHT)
68407 MISHKA (ミシカ) WASHED BEAR MOP TEE (BLUE/M21200006BLU)
68405 MISHKA (ミシカ) COLLAGE ARTWORK TEE (O.WHITE/M21200051WHT)
68220 MISHKA (ミシカ) CROWN TEDDY BEAR TEE M21200014 WHITE
65665 MISHKA (ミシカ) M61100053 MONOGRAM“MOP”Tee
65670 MISHKA (ミシカ) M61100008 "KEEP WATCH"Tee WHITE
65672 MISHKA (ミシカ) M61100008 "KEEP WATCH"Tee BLACK
65673 MISHKA (ミシカ) M61100001 “MOP”GRAPHIC Tee WHITE
65674 MISHKA (ミシカ) M61100001 “MOP”GRAPHIC Tee BLACK
65675 MISHKA (ミシカ) M61100003 WHITE“MOP”Tee
64925 MISHKA (ミシカ) M21100062 T-SHIRT OFF WHITE
64927 MISHKA (ミシカ) M21100061 T-SHIRT WHITE
64930 MISHKA (ミシカ) M21100064 T-SHIRT BLACK
63098 MISHKA (ミシカ) M21100009 T-SHIRT YELLOW
63078 MISHKA (ミシカ) M21100025 T-SHIRT WHITE
61816 MISHKA (ミシカ) M21100053 T-SHIRT BLACK
68059 MISHKA (ミシカ) CREAMY TEE (A.BLUE/MIJT-01BLU)
68062 MISHKA (ミシカ) CREAMY TEE (T.PINK/MIJT-01PNK)
68058 MISHKA (ミシカ) CREAMY TEE (BLACK/MIJT-01BLK)
68057 MISHKA (ミシカ) INFINITE PAIN TEE (WHITE/MIDT-01WHT)
68056 MISHKA (ミシカ) INFINITE PAIN TEE (BLACK/MIDT-01BLK)
68412 MISHKA (ミシカ) WASHEDKEEP WATCH TEE (O.WHITE/M21200007WHT)
68414 MISHKA (ミシカ) WASHEDKEEP WATCH TEE (PINK/M21200007PK)
68413 MISHKA (ミシカ) WASHEDKEEP WATCH TEE (KHAKI/M21200007KHAKI)
64926 MISHKA (ミシカ) M21100062 T-SHIRT BLACK
63076 MISHKA (ミシカ) M21100039 T-SHIRT WHITE
61784 MISHKA (ミシカ) M21100032 T-SHIRT L.GREEN
61766 MISHKA (ミシカ) M21100001 T-SHIRT L.GREEN
60292 MISHKA M61000007 T-SHIRT BLACK
60171 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE BLACK
60173 MISHKA X DENNIS THE MENACE DENNIS TEE BLACK
60172 MISHKA X DENNIS THE MENACE DENNIS TEE WHITE
58745 MISHKA NEW WORLD ORDER TEE BLACK
58573 MISHKA(ミシカ) M21000005 T-Shirt
58628 MISHKA SPOOKY CREW TEE PINK
58819 MISHKA(ミシカ) M21000012 T-SHIRTS BLACK
58824 MISHKA(ミシカ) M21000021 T-SHIRTS
58574 MISHKA(ミシカ) M21000029 T-Shirt
58131 MISHKA M21000007 T-Shirt Yellow
58132 MISHKA M21000066 T-Shirt White
58133 MISHKA M21000066 T-Shirt Yellow
58127 MISHKA M21000011 T-Shirt Black
57360 MISHKA M21000013 T-Shirt GREEN
58126 MISHKA M21000006 T-Shirt Beige
58125 MISHKA M21000006 T-Shirt Black
58744 MISHKA NEW WORLD ORDER TEE WHITE
58746 MISHKA NEW WORLD ORDER TEE BLUE
58624 MISHKA OPTIC KEEP WATCH TEE WHITE
58625 MISHKA OPTIC KEEP WATCH TEE GREEN
58627 MISHKA SPOOKY CREW TEE WHITE
57363 MISHKA M21000059 T-Shirt ORANGE
61764 MISHKA (ミシカ) M21100011 T-SHIRT
63077 MISHKA (ミシカ) M21100039 T-SHIRT BLACK
64928 MISHKA (ミシカ) M21100061 T-SHIRT BLACK
64929 MISHKA (ミシカ) M21100064 T-SHIRT WHITE
63099 MISHKA (ミシカ) M21100009 T-SHIRT PURPLE
63100 MISHKA (ミシカ) M21100009 T-SHIRT BLACK
63079 MISHKA (ミシカ) M21100013 T-Shirt BLACK
61783 MISHKA (ミシカ) M21100032 T-SHIRT WHITE
61765 MISHKA (ミシカ) M21100001 T-SHIRT WHITE
61817 MISHKA (ミシカ) M21100032 T-SHIRT BLACK
61815 MISHKA (ミシカ) M21100053 T-SHIRT WHITE
61767 MISHKA (ミシカ) M21100001 T-SHIRT BLACK
60293 MISHKA M61000007 T-SHIRT PURPLE
60294 MISHKA M61000007 T-SHIRT WHITE
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60271 MISHKA M61000053 T-SHIRT BLACK
60272 MISHKA M61000053 T-SHIRT BLUE