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-05-03 12:21:38')
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 MAX(price02)
LIMIT 0, 180
54657 MISHKA(ミシカ) MSS203305 SOCKS WHITE
54658 MISHKA(ミシカ) MSS203305 SOCKS BLACK
54659 MISHKA(ミシカ) MSS203304 SOCKS WHITE
54660 MISHKA(ミシカ) MSS203304 SOCKS YELLOW
54661 MISHKA(ミシカ) MSS203301 SOCKS YELLOW
54662 MISHKA(ミシカ) MSS203301 SOCKS GREEN
55930 MISHKA MAW203353 SOCKS SAFTY GREEN
55931 MISHKA MAW203353 SOCKS BLACK
55932 MISHKA MAW203354 SOCKS BLACK
55933 MISHKA MAW203355 SOCKS BLACK
57369 MISHKA M21003354 SOCKS BLACK
57370 MISHKA M21003354 SOCKS GREEN
57371 MISHKA M21003354 SOCKS PURPLE
57372 MISHKA M21003353 SOCKS BLUE
57373 MISHKA M21003353 SOCKS RED
58624 MISHKA OPTIC KEEP WATCH TEE WHITE
58627 MISHKA SPOOKY CREW TEE WHITE
58628 MISHKA SPOOKY CREW TEE PINK
53870 MISHKA(ミシカ) MSS200085 T-SHIRTS WHITE
54452 MISHKA(ミシカ) MSS200031 T-SHIRTS Safety Green
60292 MISHKA M61000007 T-SHIRT BLACK
55901 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS WHITE
55904 MISHKA x Johnny Ryan DON'T LET THEM L/S T-SHIRTS BLUE
58572 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE PURPLE
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
58573 MISHKA(ミシカ) M21000005 T-Shirt
60171 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE BLACK
60172 MISHKA X DENNIS THE MENACE DENNIS TEE WHITE
61816 MISHKA (ミシカ) M21100053 T-SHIRT BLACK
56891 MISHKA(ミシカ) TAPE SET
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
55983 MISHKA(ミシカ) 89534 LANYARD
58629 MISHKA SPOOKY CREW TEE BLACK
60268 MISHKA M61000056 T-SHIRT BLACK
55908 MISHKA MAW200002 L/S T-SHIRTS SAFTY GREEN
57364 MISHKA M21000001 L/S T-Shirt BLACK
54198 MISHKA MSS200029M80 T-SHIRTS WHITE
57359 MISHKA M21000013 T-Shirt WHITE
60293 MISHKA M61000007 T-SHIRT PURPLE
63078 MISHKA (ミシカ) M21100025 T-SHIRT WHITE
54450 MISHKA(ミシカ) MSS200839 SHORTS
54455 MISHKA(ミシカ) MSS200076 T-SHIRTS Purple
55900 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS BLACK
55902 MISHKA x Johnny Ryan WILLY WASHUMS S/S T-SHIRTS
55912 MISHKA MAW200004 T-SHIRTS BEIGE
58132 MISHKA M21000066 T-Shirt White
60271 MISHKA M61000053 T-SHIRT BLACK
60272 MISHKA M61000053 T-SHIRT BLUE
64930 MISHKA (ミシカ) M21100064 T-SHIRT BLACK
54196 MISHKA MSS200033F80 T-SHIRTS WHITE
63076 MISHKA (ミシカ) M21100039 T-SHIRT WHITE
64928 MISHKA (ミシカ) M21100061 T-SHIRT BLACK
65670 MISHKA (ミシカ) M61100008 "KEEP WATCH"Tee WHITE
58126 MISHKA M21000006 T-Shirt Beige
58626 MISHKA OPTIC KEEP WATCH TEE BLACK
58820 MISHKA(ミシカ) M21000012 T-SHIRTS WHITE
60269 MISHKA M61000056 T-SHIRT PURPLE
60270 MISHKA M61000056 T-SHIRT WHITE
56877 MISHKA(ミシカ) MAW200470 HOODIE ORANGE
60166 MISHKA X DENNIS THE MENACE TROUBLE MAKER SHORTS
57358 MISHKA M21000013 T-Shirt BLACK
58130 MISHKA M21000007 T-Shirt Green
60291 MISHKA M61000907W PANT
61759 MISHKA (ミシカ) M21100407 HOODIE
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
54699 MISHKA(ミシカ) MSS200030 T-SHIRTS ORANGE/PURPLE
55790 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 キャップ
55929 MISHKA MAW203224 BEANIE
57365 MISHKA M21000001 L/S T-Shirt WHITE
58575 MISHKA(ミシカ) M21000067 T-Shirt GREEN
58576 MISHKA(ミシカ) M21000067 T-Shirt PURPLE
60664 MISHKAM M61000413 CREW
60726 MISHKA M61000452 HOODIE
60729 MISHKA M61000841 PANTS
61778 MISHKA (ミシカ) M21100352 KNIT
68288 MISHKA (ミシカ) RAINBOW KEEP WATCH TRUCKER CAP
68289 MISHKA (ミシカ) PINK LEOPARD KEEP WATCH TRUCKER CAP
68402 MISHKA (ミシカ) BLUE & RED KEEP WATCH TRUCKER CAP
68403 MISHKA (ミシカ) DEEP DRIP KEEP WATCH TRUCKER CAP
58113 MISHKA M21000414M WHITE
60274 MISHKA M61000301 KNIT PINK
60275 MISHKA M61000301 KNIT BLUE
60560 MISHKA M61000251 CHECK SHIRT
60660 MISHKA M61000253 SHIRT L.BLUE
60721 MISHKA M61000417 HOODIE BLACK
54449 MISHKA(ミシカ) MSS200873 SHORTS
54464 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 Tシャツ
54465 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 キャップ
55981 MISHKA(ミシカ) 88318 CHARGER
55982 MISHKA(ミシカ) 91344 LED LAMP
58625 MISHKA OPTIC KEEP WATCH TEE GREEN
58744 MISHKA NEW WORLD ORDER TEE WHITE
58745 MISHKA NEW WORLD ORDER TEE BLACK
58746 MISHKA NEW WORLD ORDER TEE BLUE
68056 MISHKA (ミシカ) INFINITE PAIN TEE (BLACK/MIDT-01BLK)
68057 MISHKA (ミシカ) INFINITE PAIN TEE (WHITE/MIDT-01WHT)
68058 MISHKA (ミシカ) CREAMY TEE (BLACK/MIJT-01BLK)
68059 MISHKA (ミシカ) CREAMY TEE (A.BLUE/MIJT-01BLU)
68062 MISHKA (ミシカ) CREAMY TEE (T.PINK/MIJT-01PNK)
60281 MISHKA M61000421 HOODIE
58108 MISHKA M21000251 SHIRT
58114 MISHKA M21000509 Jacket
60288 MISHKA M61000526 JACKET
61263 MISHKA M61000623 JACKET BROWN
50245 MISHKA MAW193223 CAP YELLOW
50246 MISHKA MAW193206 CAP
50247 MISHKA MAW193236 CAP
53868 MISHKA(ミシカ) MSS200069 T-SHIRTS WHITE
53869 MISHKA(ミシカ) MSS200069 T-SHIRTS BLACK
53871 MISHKA(ミシカ) MSS200085 T-SHIRTS BLACK
53872 MISHKA(ミシカ) MSS200086 T-SHIRTS
54199 MISHKA MSS200029M80 T-SHIRTS BLACK
54453 MISHKA(ミシカ) MSS200031 T-SHIRTS Gray
54663 MISHKA(ミシカ) MSS203210 CAP
54665 MISHKA(ミシカ) MSS203224 BUCKET HAT
54668 MISHKA(ミシカ) MSS203209 CAP
56182 MISHKA(ミシカ) MAW203228 CAP
57360 MISHKA M21000013 T-Shirt GREEN
58129 MISHKA M21000007 T-Shirt Black
58131 MISHKA M21000007 T-Shirt Yellow
58136 MISHKA M21003251 Cap Black
58137 MISHKA M21003251 Cap White
58138 MISHKA M21003253 Hat
58577 MISHKA(ミシカ) M21000072 T-Shirt PURPLE
58578 MISHKA(ミシカ) M21000072 T-Shirt BLACK
58821 MISHKA(ミシカ) M21000014 T-SHIRTS PURPLE
58822 MISHKA(ミシカ) M21000014 T-SHIRTS WHITE
60294 MISHKA M61000007 T-SHIRT WHITE
61764 MISHKA (ミシカ) M21100011 T-SHIRT
63098 MISHKA (ミシカ) M21100009 T-SHIRT YELLOW
63099 MISHKA (ミシカ) M21100009 T-SHIRT PURPLE
63100 MISHKA (ミシカ) M21100009 T-SHIRT BLACK
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
60556 MISHKA M61000519 JACKET BLACK
54454 MISHKA(ミシカ) MSS200076 T-SHIRTS Black
54459 MISHKA(ミシカ) MSS200044 T-SHIRTS
54664 MISHKA(ミシカ) MSS203225 BUCKET HAT
54707 MISHKA (ミシカ) KUMARA TEE
54708 MISHKA (ミシカ) BUTIGER TEE
55903 MISHKA x Johnny Ryan DON'T LET THEM S/S T-SHIRTS
55911 MISHKA MAW200004 T-SHIRTS WHITE
56889 MISHKA(ミシカ) FRKO x Mishka "Pop! Pop! Pop!" Hoodie BLACK
57283 MISHKA GALACTIC GHOULS LS TEE WHITE
57284 MISHKA FLAMING KEEP WATCH LS TEE
57285 MISHKA 2 CHILL 4 DEATH LS TEE BLACK
57286 MISHKA 2 CHILL 4 DEATH LS TEE LIME
57287 MISHKA STACKED LS TEE BLACK
57288 MISHKA STACKED LS TEE LIME
58127 MISHKA M21000011 T-Shirt Black
58128 MISHKA M21000011 T-Shirt White
58133 MISHKA M21000066 T-Shirt Yellow
58506 MISHKA OPTIC KEEP WATCH L/S L/S T-Shirt BLACK
58507 MISHKA OPTIC KEEP WATCH L/S L/S T-Shirt WHITE
58571 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE BLACK
58747 MISHKA NEW WORLD ORDER LONGSLEEVE WHITE
61762 MISHKA (ミシカ) M21100401 CREW BLACK
61781 MISHKA (ミシカ) M21100412 CREW BLACK
61783 MISHKA (ミシカ) M21100032 T-SHIRT WHITE
61784 MISHKA (ミシカ) M21100032 T-SHIRT L.GREEN
61817 MISHKA (ミシカ) M21100032 T-SHIRT BLACK
63081 MISHKA (ミシカ) M21100409 CREW BLACK
64925 MISHKA (ミシカ) M21100062 T-SHIRT OFF WHITE
64926 MISHKA (ミシカ) M21100062 T-SHIRT BLACK
64929 MISHKA (ミシカ) M21100064 T-SHIRT WHITE
50243 MISHKA MAW193108 BAG BLACK
53202 MISHKA [ミシカ] MSS203213F99 CAP BLACK
53203 MISHKA [ミシカ] MSS203213F99 CAP INDIGO
54197 MISHKA MSS200033F80 T-SHIRTS BLACK
54666 MISHKA(ミシカ) MSS203214 CAP BLUE
54667 MISHKA(ミシカ) MSS203213 CAP BLACK
54669 MISHKA(ミシカ) MSS203202 CAP
54700 MISHKA(ミシカ) MSS200032 T-SHIRTS GREEN
54703 MISHKA MSS200005 T-SHIRTS GREEN
54704 MISHKA MSS200005 T-SHIRTS ORANGE
55905 MISHKA MAW200074 L/S T-SHIRTS ORANGE
55927 MISHKA MAW203112 BAG
55928 MISHKA MAW203111 BAG
56883 MISHKA(ミシカ) MAW203117 WHITE
56884 MISHKA(ミシカ) MAW203118 WHITE
57361 MISHKA M21000059 T-Shirt BLACK