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 05:04:13')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.classcategory_id1 IN( 13,35,44)
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
69290 MISHKA (ミシカ) M61200052 Embroidery Tee Ivory
69291 MISHKA (ミシカ) M61200052 Embroidery Black
68220 MISHKA (ミシカ) CROWN TEDDY BEAR TEE M21200014 WHITE
65665 MISHKA (ミシカ) M61100053 MONOGRAM“MOP”Tee
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
68058 MISHKA (ミシカ) CREAMY TEE (BLACK/MIJT-01BLK)
68056 MISHKA (ミシカ) INFINITE PAIN TEE (BLACK/MIDT-01BLK)
64926 MISHKA (ミシカ) M21100062 T-SHIRT BLACK
61263 MISHKA M61000623 JACKET BROWN
63081 MISHKA (ミシカ) M21100409 CREW BLACK
61781 MISHKA (ミシカ) M21100412 CREW BLACK
61762 MISHKA (ミシカ) M21100401 CREW BLACK
65663 MISHKA (ミシカ) M61100907 DAMAGE PANTS
61814 MISHKA (ミシカ) M21100404 HOODIE
61763 MISHKA (ミシカ) M21100054 L/S T-Shirt
60274 MISHKA M61000301 KNIT PINK
60273 MISHKA M61000301 KNIT BLACK
60281 MISHKA M61000421 HOODIE
60288 MISHKA M61000526 JACKET
60721 MISHKA M61000417 HOODIE BLACK
60660 MISHKA M61000253 SHIRT L.BLUE
60560 MISHKA M61000251 CHECK SHIRT
60556 MISHKA M61000519 JACKET BLACK
60555 MISHKA M61000418 HOODE BLACK
60280 MISHKA M61000411 HOODIE
60275 MISHKA M61000301 KNIT BLUE
60173 MISHKA X DENNIS THE MENACE DENNIS TEE BLACK
58745 MISHKA NEW WORLD ORDER TEE BLACK
58819 MISHKA(ミシカ) M21000012 T-SHIRTS BLACK
58824 MISHKA(ミシカ) M21000021 T-SHIRTS
58574 MISHKA(ミシカ) M21000029 T-Shirt
58127 MISHKA M21000011 T-Shirt Black
57360 MISHKA M21000013 T-Shirt GREEN
58125 MISHKA M21000006 T-Shirt Black
58744 MISHKA NEW WORLD ORDER TEE WHITE
58746 MISHKA NEW WORLD ORDER TEE BLUE
58747 MISHKA NEW WORLD ORDER LONGSLEEVE WHITE
58625 MISHKA OPTIC KEEP WATCH TEE GREEN
57363 MISHKA M21000059 T-Shirt ORANGE
61764 MISHKA (ミシカ) M21100011 T-SHIRT
64929 MISHKA (ミシカ) M21100064 T-SHIRT WHITE
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
60720 MISHKA M61000010 L/S T-Shirt
60290 MISHKA M61000209 L/S SHIRT
60294 MISHKA M61000007 T-SHIRT WHITE
60170 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE WHITE
58823 MISHKA(ミシカ) M21000015 T-SHIRTS
58822 MISHKA(ミシカ) M21000014 T-SHIRTS WHITE
58821 MISHKA(ミシカ) M21000014 T-SHIRTS PURPLE
58128 MISHKA M21000011 T-Shirt White
57362 MISHKA M21000059 T-Shirt YELLOW
57361 MISHKA M21000059 T-Shirt BLACK
57357 MISHKA M21000030 T-Shirt WHITE
57356 MISHKA M21000030 T-Shirt BLACK
58571 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE BLACK
58507 MISHKA OPTIC KEEP WATCH L/S L/S T-Shirt WHITE
58506 MISHKA OPTIC KEEP WATCH L/S L/S T-Shirt BLACK
58113 MISHKA M21000414M WHITE
58112 MISHKA M21000414M BLACK
57341 MISHKA M21000402 SWEAT SHIRT BLACK
58108 MISHKA M21000251 SHIRT
58114 MISHKA M21000509 Jacket
57283 MISHKA GALACTIC GHOULS LS TEE WHITE
57284 MISHKA FLAMING KEEP WATCH LS TEE
57286 MISHKA 2 CHILL 4 DEATH LS TEE LIME
57287 MISHKA STACKED LS TEE BLACK
57288 MISHKA STACKED LS TEE LIME
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
55977 MISHKA(ミシカ) MAW200512 JACKET
55917 MISHKA MAW200210 SHIRTS
55906 MISHKA MAW200002 L/S T-SHIRTS WHITE
56889 MISHKA(ミシカ) FRKO x Mishka "Pop! Pop! Pop!" Hoodie BLACK
55979 MISHKA(ミシカ) MAW200507 JACKET SAFTY GREEN
55909 MISHKA MAW200003 L/S T-SHIRTS BLACK
55910 MISHKA MAW200003 L/S T-SHIRTS CHARCOAL GRAY
55905 MISHKA MAW200074 L/S T-SHIRTS ORANGE
55907 MISHKA MAW200002 L/S T-SHIRTS BLACK
55911 MISHKA MAW200004 T-SHIRTS WHITE
55903 MISHKA x Johnny Ryan DON'T LET THEM S/S T-SHIRTS
54464 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 Tシャツ
54199 MISHKA MSS200029M80 T-SHIRTS BLACK
54197 MISHKA MSS200033F80 T-SHIRTS BLACK
6265 MISHKA (ミシカ) ANTIGONE BUTTON-UP WHITE
6452 MISHKA (ミシカ) SOLID KEEP WATCH POLO NAVY
6502 MISHKA 3-DESTROY T-SHIRT TURQUOISE
6566 MISHKA DART RING T-SHIRT BLACK
8139 MISHKA (ミシカ) KEEP WATCH CARDIGAN HEATHER GREY
8142 MISHKA KEEP WATCH VINTAGE JACKET HEATHER CRIMSON
8266 MISHKA (ミシカ) VERMILYEA KEEP WATCH T-SHIRT BLACK
9495 MISHKA (ミシカ) KEEP WATCH T-SHIRT BURGUNDY
9497 MISHKA (ミシカ) KEEP WATCH T-SHIRT HEATHER
9510 MISHKA (ミシカ) CYCO SERPENT T-SHIRT BLACK
10027 MISHKA (ミシカ) AOD NECRONOMICON CREWNECK BLACK
10028 MISHKA (ミシカ) AOD NECRONOMICON T-SHIRT BLACK
10608 MISHKA (ミシカ) HELLA STUFF PULLOVER WHITE
10807 MISHKA (ミシカ) CYCO PUSHER RAGLAN WHITE
11088 MISHKA (ミシカ) OVER SIZE BEAR MOP TIE-DYE T-SHIRT MAGENTA
11091 MISHKA (ミシカ) THE WORLD WIDE WEIRDOS TANK GREEN TIE DYE
11093 MISHKA (ミシカ) THE CYRILLIC MOSAIC POCKET TEE BLACK
12194 MISHKA (ミシカ) BEAST OF THE EAST TANK TOP ARMY
12206 MISHKA (ミシカ) KEEP WATCH DYNASTY TANK TOP GOLD
12209 MISHKA (ミシカ) CRYPT KEEPER TANK TOP BLACK
12210 MISHKA (ミシカ) CRYPT KEEPER TANK TOP WHITE
12537 MISHKA (ミシカ) IRON SKULL T-SHIRT WHITE
13241 MISHKA (ミシカ) LAMOUR ENTOMBED BUTTON UP WHITE
13475 MISHKA (ミシカ) CYCO TARANTURA TIE-DYE T-SHIRT TURQUOISE
13495 MISHKA (ミシカ) DEATH DIVISION T-SHIRT CAMO
13511 MISHKA (ミシカ) CITY JACK BUTTON UP RED
14310 MISHKA (ミシカ) DENIM BUTTON UP
14773 MISHKA (ミシカ) ELEVATED REALM ZIP UP HOODIE
14911 MISHKA (ミシカ) CYRILLIC CANNABIS HOCKEY LACED PULLOVER