SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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-04-28 11:07:15')
AND pc.classcategory_id1 IN( 159)
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, 120
68057 MISHKA (ミシカ) INFINITE PAIN TEE (WHITE/MIDT-01WHT)
68056 MISHKA (ミシカ) INFINITE PAIN TEE (BLACK/MIDT-01BLK)
67839 MISHKA (ミシカ) END IT NOW HOODIE MIGHO-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
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
58745 MISHKA NEW WORLD ORDER TEE BLACK
58628 MISHKA SPOOKY CREW TEE PINK
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
60170 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE WHITE
60168 MISHKA X DENNIS THE MENACE DENNIS & FRIENDS HOODIE YELLOW
58626 MISHKA OPTIC KEEP WATCH TEE BLACK
58629 MISHKA SPOOKY CREW TEE BLACK
56882 MISHKA(ミシカ) MAW200770 JACKET BLACK
56877 MISHKA(ミシカ) MAW200470 HOODIE ORANGE
56879 MISHKA(ミシカ) MAW200470 HOODIE BLACK
56889 MISHKA(ミシカ) FRKO x Mishka "Pop! Pop! Pop!" Hoodie BLACK
56890 MISHKA(ミシカ) FRKO x Mishka "Pop! Pop! Pop!" Hoodie ASHGRAY
56178 MISHKA(ミシカ) MAW200406 HOODIE BLACK
56179 MISHKA(ミシカ) MAW200406 HOODIE WHITE
55900 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS BLACK
55901 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS WHITE
55902 MISHKA x Johnny Ryan WILLY WASHUMS S/S T-SHIRTS
55903 MISHKA x Johnny Ryan DON'T LET THEM S/S T-SHIRTS
55904 MISHKA x Johnny Ryan DON'T LET THEM L/S T-SHIRTS BLUE
54463 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 パーカー
54464 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 Tシャツ
54198 MISHKA MSS200029M80 T-SHIRTS WHITE
54199 MISHKA MSS200029M80 T-SHIRTS BLACK
18850 MISHKA (ミシカ) CHILD OF THE SYSTEM T-SHIRT
20324 MISHKA (ミシカ) KEEP WATCH T-SHIRT BLK/GRN
21835 MISHKA (ミシカ) MIGHTY HEALTHY: WARHEAD PULLOVER HOODIE
21836 MISHKA (ミシカ) MIGHTY HEALTHY: SCAVENGERS T-SHIRT
21838 MISHKA (ミシカ) MIGHTY HEALTHY: KEEP WATCH T-SHIRT
21839 MISHKA (ミシカ) MIGHTY HEALTHY: COVER T-SHIRT
21840 MISHKA (ミシカ) MIGHTY HEALTHY: WARHEAD RAGLAN
21911 MISHKA (ミシカ) MIGHTY HEALTHY: WARHEAD T-SHIRT
22066 MISHKA (ミシカ) GALAXY KEEP WATCH HOODIE BLACK
22067 MISHKA (ミシカ) GALAXY KEEP WATCH HOODIE WHITE
27834 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE BLK
27835 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE WHT
30004 MISHKA (ミシカ) MUSE KEEP WATCH PULLOVER HOODIE TURQUOISE
32257 MISHKA (ミシカ) MSS170406 THUNDER KEEP WATCH SWEATSHIRT BLACK
33651 MISHKA (ミシカ) LAMOUR K.W TEE WHT
33972 MISHKA(ミシカ) MSS170003 TEE BLACK
33973 MISHKA(ミシカ) MSS170003 TEE WHITE
33977 MISHKA(ミシカ) MSS170020 TEE BLACK
34114 MISHKA (ミシカ) MSS170543 JACKET DENIM
35071 MISHKA (ミシカ) EXSP1725 WHITE
35072 MISHKA (ミシカ) EXSP1725 BLACK
36259 MISHKA (ミシカ) SM171107TD TEE
37079 MISHKA(ミシカ) MAW170420 BLACK
37143 MISHKA(ミシカ) EXWD1005C MISHKA VS LAMOUR SWEAT BLACK
37144 MISHKA(ミシカ) EXWD1005C MISHKA VS LAMOUR SWEAT WHITE
37146 MISHKA(ミシカ) EXWD1005H MISHKA VS LAMOUR PULLOVER WHITE
37148 MISHKA(ミシカ) EXWD1004C TOTEM POLE SWEATSHIRT WHITE
37149 MISHKA(ミシカ) EXWD1004C TOTEM POLE SWEATSHIRT BLACK
37151 MISHKA(ミシカ) EXWD1004H TOTEM POLE PULLOVER WHITE
37154 MISHKA(ミシカ) EXWD1004H TOTEM POLE PULLOVER BLACK
37155 MISHKA (ミシカ) EXWD1003C WITH BEAR SWEATSHIRT WHITE
37156 MISHKA (ミシカ) EXWD1003C WITH BEAR SWEATSHIRT BLACK
37159 MISHKA (ミシカ) EXWD1003H WITH BEAR PULLOVER WHITE
37160 MISHKA (ミシカ) EXWD1003H WITH BEAR PULLOVER BLACK
37365 Hi-STANDARD×MISHKA EXWDHS01C BEAR GUY SWEAT WHT
37366 Hi-STANDARD×MISHKA EXWDHS01C BEAR GUY SWEAT BLK
37367 Hi-STANDARD×MISHKA EXWDHS02C SPHINX SWEAT BLK
37368 Hi-STANDARD×MISHKA EXWDHS02C SPHINX SWEAT WHT
37369 Hi-STANDARD×MISHKA EXWDHS02C SPHINX SWEAT PUR
37370 Hi-STANDARD×MISHKA EXWDHS03C MONSTER SWEAT PUR
37371 Hi-STANDARD×MISHKA EXWDHS03C MONSTER SWEAT BLK
37372 Hi-STANDARD×MISHKA EXWDHS03C MONSTER SWEAT WHT
37373 Hi-STANDARD×MISHKA EXWDHS01H BEAR GUY PULLOVER WHT
37374 Hi-STANDARD×MISHKA EXWDHS01H BEAR GUY PULLOVER BLK
37375 Hi-STANDARD×MISHKA EXWDHS02H SPHINX PULLOVER WHT
37376 Hi-STANDARD×MISHKA EXWDHS02H SPHINX PULLOVER BLK
37377 Hi-STANDARD×MISHKA EXWDHS02H SPHINX PULLOVER PUR
37378 Hi-STANDARD×MISHKA EXWDHS03H MONSTER PULLOVER WHT
37379 Hi-STANDARD×MISHKA EXWDHS03H MONSTER PULLOVER BLK
37380 Hi-STANDARD×MISHKA EXWDHS03H MONSTER PULLOVER PUR
37449 MISHKA(ミシカ) MAW170437
37503 MISHKA(ミシカ) EXSP1726B WHITE
37504 MISHKA(ミシカ) EXSP1726B BLACK
37818 MISHKA(ミシカ) MAW170436 CAMO SWEAT
37832 MISHKA(ミシカ) MAW170405F PO BLK
38609 MISHKA(ミシカ) MAW170428 BLACK
38758 MISHKA (ミシカ) MAW160420 Sweatshit
38791 MISHKA(ミシカ) FRAGRANT PULLOVER HOODIE (BLACK/FL171129POBLK)
38793 MISHKA(ミシカ) KEEP WATCH PULLOVER HOODIE (BLACK/FL171121POBLK)
38794 MISHKA(ミシカ) LAMOUR VENOMOUS KEEP WATCH PULLOVER HOODIE (PINK/FL171131POPNK)
38796 MISHKA(ミシカ) NEIGHBORHOOD KEEP WATCH L/S TEE (WHITE/FL171105LSWHT)
38797 MISHKA(ミシカ) MISHKA TV L/S TEE (BLACK/FL171106LSBLK)
38798 MISHKA(ミシカ) MISHKA TV L/S TEE (WHITE/FL171106LSWHT)
38799 MISHKA(ミシカ) ENTANGLED KEEP WATCH L/S TEE (BLACK/FL171104LSBLK)
38800 MISHKA(ミシカ) ENTANGLED KEEP WATCH L/S TEE (WHITE/FL171104LSWHT)
38801 MISHKA(ミシカ) ENTANGLED KEEP WATCH L/S TEE (BLACK/FL171104LSWHT)
38802 MISHKA(ミシカ) LAMOUR ON SIGHT L/S TEE (CHARCOAL/FL171120LSCHR)
38803 MISHKA(ミシカ) LAMOUR ON SIGHT L/S TEE (WHITE/FL171120LSWHT)
38805 LAMOUR VENOMOUS KEEP WATCH PULLOVER HOODIE (BLACK/FL171131POBLK)
38806 MISHKA(ミシカ) KEEP WATCH PULLOVER HOODIE (GREY/FL171121POGRY)
38807 MISHKA(ミシカ) ENTANGLED KEEP WATCH PULLOVER HOODIE (BLACK/FL171126POBLK)
38808 MISHKA(ミシカ) ENTANGLED KEEP WATCH PULLOVER HOODIE (WHITE/FL171126POWHT)
38809 MISHKA(ミシカ) LAMOUR LADY KEEP WATCH PULLOVER HOODIE (BLACK/FL171137PO)
38810 MISHKA(ミシカ) LAMOUR ARACHNID KEEP WATCH PULLOVER HOODIE (BLACK/FL171136PO)
38811 MISHKA(ミシカ) LAMOUR CYCO COLLAGE PULLOVER HOODIE (BLACK/FL171134POBLK)
38812 MISHKA(ミシカ) LAMOUR CYCO COLLAGE PULLOVER HOODIE (WHITE/FL171134POWHT)
38813 MISHKA(ミシカ) CYCO KEEP WATCH PULLOVER HOODIE (BLACK/FL171128POBLK)
38814 MISHKA(ミシカ) LAMOUR CYCO COLLAGE CREWNECK (BLACK/FL171135CN)
38815 MISHKA(ミシカ) CYRILLIC VARSITY CREWNECK (BLACK/FL171125)
38818 MISHKA(ミシカ) CYCO KEEP WATCH T-SHIRT FL 171113 BLK
38819 MISHKA(ミシカ) CYCO KEEP WATCH T-SHIRT FL 171113 PNK
38820 MISHKA(ミシカ) LAMOUR HAND OF HELL T-SHIRT BLK
38821 MISHKA(ミシカ) LAMOUR HAND OF HELL T-SHIRT WHT
38822 MISHKA(ミシカ) CYRILLIC VARSITY T-SHIRT FL 171103 COFFEE
38826 MISHKA(ミシカ) LAMOUR CYCO COLLAGE TEE FL171133 BLK