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-27 09:34:01')
AND pc.price02 > 4545
AND price02 <= 9090
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
LIMIT 0, 120
50242 MISHKA MAW193106 BAG BLACK
50243 MISHKA MAW193108 BAG BLACK
50245 MISHKA MAW193223 CAP YELLOW
50246 MISHKA MAW193206 CAP
50247 MISHKA MAW193236 CAP
53202 MISHKA [ミシカ] MSS203213F99 CAP BLACK
53203 MISHKA [ミシカ] MSS203213F99 CAP INDIGO
53868 MISHKA(ミシカ) MSS200069 T-SHIRTS WHITE
53869 MISHKA(ミシカ) MSS200069 T-SHIRTS BLACK
53871 MISHKA(ミシカ) MSS200085 T-SHIRTS BLACK
53872 MISHKA(ミシカ) MSS200086 T-SHIRTS
53876 MISHKA(ミシカ) MSS201102 T-SHIRTS WHITE
53877 MISHKA(ミシカ) MSS201102 T-SHIRTS BLACK
53880 MISHKA(ミシカ) MSS200834 SHORTS BLACK
53881 MISHKA(ミシカ) MSS200834 SHORTS WHITE
53885 MISHKA(ミシカ) MSS200832 LEGGINGS
54197 MISHKA MSS200033F80 T-SHIRTS BLACK
54199 MISHKA MSS200029M80 T-SHIRTS BLACK
54449 MISHKA(ミシカ) MSS200873 SHORTS
54451 MISHKA(ミシカ) MSS200906 SHORTS
54453 MISHKA(ミシカ) MSS200031 T-SHIRTS Gray
54454 MISHKA(ミシカ) MSS200076 T-SHIRTS Black
54459 MISHKA(ミシカ) MSS200044 T-SHIRTS
54464 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 Tシャツ
54465 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 キャップ
54663 MISHKA(ミシカ) MSS203210 CAP
54664 MISHKA(ミシカ) MSS203225 BUCKET HAT
54665 MISHKA(ミシカ) MSS203224 BUCKET HAT
54666 MISHKA(ミシカ) MSS203214 CAP BLUE
54667 MISHKA(ミシカ) MSS203213 CAP BLACK
54668 MISHKA(ミシカ) MSS203209 CAP
54669 MISHKA(ミシカ) MSS203202 CAP
54700 MISHKA(ミシカ) MSS200032 T-SHIRTS GREEN
54703 MISHKA MSS200005 T-SHIRTS GREEN
54704 MISHKA MSS200005 T-SHIRTS ORANGE
54707 MISHKA (ミシカ) KUMARA TEE
54708 MISHKA (ミシカ) BUTIGER TEE
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
55903 MISHKA x Johnny Ryan DON'T LET THEM S/S T-SHIRTS
55905 MISHKA MAW200074 L/S T-SHIRTS ORANGE
55906 MISHKA MAW200002 L/S T-SHIRTS WHITE
55907 MISHKA MAW200002 L/S T-SHIRTS BLACK
55909 MISHKA MAW200003 L/S T-SHIRTS BLACK
55910 MISHKA MAW200003 L/S T-SHIRTS CHARCOAL GRAY
55911 MISHKA MAW200004 T-SHIRTS WHITE
55917 MISHKA MAW200210 SHIRTS
55927 MISHKA MAW203112 BAG
55928 MISHKA MAW203111 BAG
55977 MISHKA(ミシカ) MAW200512 JACKET
55979 MISHKA(ミシカ) MAW200507 JACKET SAFTY GREEN
55981 MISHKA(ミシカ) 88318 CHARGER
55982 MISHKA(ミシカ) 91344 LED LAMP
56182 MISHKA(ミシカ) MAW203228 CAP
56883 MISHKA(ミシカ) MAW203117 WHITE
56884 MISHKA(ミシカ) MAW203118 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
57341 MISHKA M21000402 SWEAT SHIRT BLACK
57356 MISHKA M21000030 T-Shirt BLACK
57357 MISHKA M21000030 T-Shirt WHITE
57360 MISHKA M21000013 T-Shirt GREEN
57361 MISHKA M21000059 T-Shirt BLACK
57362 MISHKA M21000059 T-Shirt YELLOW
57363 MISHKA M21000059 T-Shirt ORANGE
57374 MISHKA M21003104 BAG
57375 MISHKA M21003106 BAG
58108 MISHKA M21000251 SHIRT
58112 MISHKA M21000414M BLACK
58113 MISHKA M21000414M WHITE
58114 MISHKA M21000509 Jacket
58125 MISHKA M21000006 T-Shirt Black
58127 MISHKA M21000011 T-Shirt Black
58128 MISHKA M21000011 T-Shirt White
58129 MISHKA M21000007 T-Shirt Black
58131 MISHKA M21000007 T-Shirt Yellow
58133 MISHKA M21000066 T-Shirt Yellow
58136 MISHKA M21003251 Cap Black
58137 MISHKA M21003251 Cap White
58138 MISHKA M21003253 Hat
58142 MISHKA M21003101 Bag
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
58574 MISHKA(ミシカ) M21000029 T-Shirt
58577 MISHKA(ミシカ) M21000072 T-Shirt PURPLE
58578 MISHKA(ミシカ) M21000072 T-Shirt BLACK
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
58747 MISHKA NEW WORLD ORDER LONGSLEEVE WHITE
58819 MISHKA(ミシカ) M21000012 T-SHIRTS BLACK
58821 MISHKA(ミシカ) M21000014 T-SHIRTS PURPLE
58822 MISHKA(ミシカ) M21000014 T-SHIRTS WHITE
58823 MISHKA(ミシカ) M21000015 T-SHIRTS
58824 MISHKA(ミシカ) M21000021 T-SHIRTS
60170 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE WHITE
60173 MISHKA X DENNIS THE MENACE DENNIS TEE BLACK
60273 MISHKA M61000301 KNIT BLACK
60274 MISHKA M61000301 KNIT PINK
60275 MISHKA M61000301 KNIT BLUE
60280 MISHKA M61000411 HOODIE
60281 MISHKA M61000421 HOODIE
60288 MISHKA M61000526 JACKET
60290 MISHKA M61000209 L/S SHIRT
60294 MISHKA M61000007 T-SHIRT WHITE
60555 MISHKA M61000418 HOODE BLACK
60556 MISHKA M61000519 JACKET BLACK
60560 MISHKA M61000251 CHECK SHIRT
60660 MISHKA M61000253 SHIRT L.BLUE
60720 MISHKA M61000010 L/S T-Shirt
60721 MISHKA M61000417 HOODIE BLACK
61263 MISHKA M61000623 JACKET BROWN
61762 MISHKA (ミシカ) M21100401 CREW BLACK
61763 MISHKA (ミシカ) M21100054 L/S T-Shirt