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 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-27 00:07:15')
AND pc.price02 > 2727
AND price02 <= 4545
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
65670 MISHKA (ミシカ) M61100008 "KEEP WATCH"Tee WHITE
64930 MISHKA (ミシカ) M21100064 T-SHIRT BLACK
63078 MISHKA (ミシカ) M21100025 T-SHIRT WHITE
68402 MISHKA (ミシカ) BLUE & RED KEEP WATCH TRUCKER CAP
68403 MISHKA (ミシカ) DEEP DRIP KEEP WATCH TRUCKER CAP
68288 MISHKA (ミシカ) RAINBOW KEEP WATCH TRUCKER CAP
68289 MISHKA (ミシカ) PINK LEOPARD KEEP WATCH TRUCKER CAP
61759 MISHKA (ミシカ) M21100407 HOODIE
63076 MISHKA (ミシカ) M21100039 T-SHIRT WHITE
61778 MISHKA (ミシカ) M21100352 KNIT
60726 MISHKA M61000452 HOODIE
60729 MISHKA M61000841 PANTS
60664 MISHKAM M61000413 CREW
60291 MISHKA M61000907W PANT
60166 MISHKA X DENNIS THE MENACE TROUBLE MAKER SHORTS
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
58132 MISHKA M21000066 T-Shirt White
58126 MISHKA M21000006 T-Shirt Beige
51494 MISHKA MSS201002W31 SKIRT INDIGO
64928 MISHKA (ミシカ) M21100061 T-SHIRT BLACK
60293 MISHKA M61000007 T-SHIRT PURPLE
60271 MISHKA M61000053 T-SHIRT BLACK
60272 MISHKA M61000053 T-SHIRT BLUE
60270 MISHKA M61000056 T-SHIRT WHITE
60269 MISHKA M61000056 T-SHIRT PURPLE
58820 MISHKA(ミシカ) M21000012 T-SHIRTS WHITE
58575 MISHKA(ミシカ) M21000067 T-Shirt GREEN
58576 MISHKA(ミシカ) M21000067 T-Shirt PURPLE
58130 MISHKA M21000007 T-Shirt Green
57359 MISHKA M21000013 T-Shirt WHITE
57358 MISHKA M21000013 T-Shirt BLACK
58626 MISHKA OPTIC KEEP WATCH TEE BLACK
57365 MISHKA M21000001 L/S T-Shirt WHITE
55790 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 キャップ
56877 MISHKA(ミシカ) MAW200470 HOODIE ORANGE
55912 MISHKA MAW200004 T-SHIRTS BEIGE
55929 MISHKA MAW203224 BEANIE
55900 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS BLACK
55902 MISHKA x Johnny Ryan WILLY WASHUMS S/S T-SHIRTS
54198 MISHKA MSS200029M80 T-SHIRTS WHITE
54196 MISHKA MSS200033F80 T-SHIRTS WHITE
54450 MISHKA(ミシカ) MSS200839 SHORTS
6252 MISHKA (ミシカ) KEEP WATCH OR DIE NEW ERA GREY
6317 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK BLACK
7289 MISHKA (ミシカ) KEEP WATCH TANK TOP WHITE
7812 MISHKA (ミシカ) CYRILLIC SCRIPT NEW ERA GREEN
8921 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT ATHLETIC HEATHER
8923 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT BLACK
9333 MISHKA (ミシカ) NEW ERA: OVERSIZE ADDER DARK GREEN
9335 MISHKA (ミシカ) NEW ERA: LAMOUR KEEP WATCH MAGENTA
9336 MISHKA (ミシカ) NEW ERA: KEEP WATCH ORANGE
10035 MISHKA (ミシカ) NEW ERA: ARMY OF DARKNESS BLACK
10596 MISHKA (ミシカ) KEEP WATCH NEW ERA NAVY 2014SP
10597 MISHKA (ミシカ) KEEP WATCH NEW ERA BLACK 2014SP
10600 MISHKA (ミシカ) OVER SIZED DEATH ADDER NEW ERA NAVY 2014SP
10601 MISHKA (ミシカ) OVER SIZED DEATH ADDER NEW ERA BLACK 2014SP
10815 MISHKA (ミシカ) DEATH DEALER T-SHIRT GREY LAVA TIE DYE
10822 MISHKA (ミシカ) CYCO PUSHER TANK TOP TIE-DYE
10832 MISHKA (ミシカ) KEEP WATCH TANK RED
11099 MISHKA (ミシカ) DART NE CYCLE CAP WHITE
12192 MISHKA (ミシカ) SNAKE BITE BOA TANK TOP BOA
12195 MISHKA (ミシカ) BEAST OF THE EAST TANK TOP WHITE
12204 MISHKA (ミシカ) MR. NICE GUY II TANK TOP STRAWBERRY
12207 MISHKA (ミシカ) KEEP WATCH TANK TOP BLACK
12208 MISHKA (ミシカ) KEEP WATCH TANK TOP WHITE
12230 MISHKA (ミシカ) STEAL YOUR SOUL TIE DYE SNAPBACK RAINBOW
12240 MISHKA (ミシカ) BEAST OF THE EAST NE 5950 BLUE DENIM
12243 MISHKA (ミシカ) BEAST OF THE EAST NE 5950 BLACK DENIM
12250 MISHKA (ミシカ) OVERSIZED RASTA ADDER NE 5950 BLACK
12251 MISHKA (ミシカ) OVERSIZED RASTA ADDER NE 5950 DARK GREEN
12264 MISHKA (ミシカ) SONS OF NIHILISM T-SHIRT RED TIE DYE
12282 MISHKA (ミシカ) PERMANEBT VACATION T-SHIRT TEAL TIE DYE
12321 MISHKA (ミシカ) OVERSPRAY KEEP WATCH T-SHIRT NAVY TIE DYE
12322 MISHKA (ミシカ) OVERSPRAY KEEP WATCH T-SHIRT PURPLE
12323 MISHKA (ミシカ) OVERSPRAY KEEP WATCH T-SHIRT BLACK
12330 MISHKA (ミシカ) KEEP WATCH NE 5950 PURPLE
13309 MISHKA (ミシカ) DEATH RITUAL 78 T-SHIRT BLACK
13310 MISHKA (ミシカ) PARALYZED T-SHIRT BLACK
13487 MISHKA (ミシカ) KIRBY CAMO 5-PANEL CAMO
13497 MISHKA (ミシカ) KIRBY KEEP WATCH CAMO T-SHIRT CAMO
13500 MISHKA (ミシカ) DEATH ADDER T-SHIRT BLACK
13501 MISHKA (ミシカ) DEATH ADDER T-SHIRT TEAL
13502 MISHKA (ミシカ) DEATH ADDER T-SHIRT PURPLE
13771 MISHKA (ミシカ) ALTITUDE KEEP WATCH T-SHIRT BLK
13772 MISHKA (ミシカ) ALTITUDE KEEP WATCH T-SHIRT RED
14302 MISHKA (ミシカ) ALIEN DEATH CAP
14306 MISHKA (ミシカ) DEATH ADDER NEW ERA BLACK
14842 MISHKA (ミシカ) AUTOPSY DEATH LONGSLEEVE T-SHIRT
14903 MISHKA (ミシカ) AUTOPSY SKULL T-SHIRT WHITE
14906 MISHKA (ミシカ) SOCIETY OF THE SNAKE REDUX CAMO T-SHIRT
14907 MISHKA (ミシカ) LAMOUR UNDERTOW T-SHIRTMarble Lime Tie Dye
14908 MISHKA (ミシカ) RITUAL COLUMN LONGSLEEVE T-SHIRT
16364 MISHKA (ミシカ) CRUSHED/KEEP WATCH REVERSIBLE BUCKET
16833 MISHKA (ミシカ) SUPER SOLDIER NEW ERA 5950 Camo
16834 MISHKA (ミシカ) PETRO KEEP WATCH NEW ERA 5950 Oil SPill
17417 MISHKA (ミシカ) BALANCED KEEP WATCH T-SHIRT RED
17527 MISHKA (ミシカ) ULTRA-SIZED DEATH ADDER T-SHIRT
17530 MISHKA (ミシカ) KEEP WATCH NEW ERA 5950 BLACK
17531 MISHKA (ミシカ) KEEP WATCH NEW ERA 5950 Turquoise/SP151705E
18840 MISHKA (ミシカ) BLIND SPOT BASKETBALL JERSEY
18849 MISHKA (ミシカ) CYCO SIGHT TIE DYE TANK TOP
19802 MISHKA (ミシカ) MAINFRAME BEAR MOP T-SHIRT
19803 MISHKA (ミシカ) GLITCH IN THE DOMINATRIX T-SHIRT
19804 MISHKA (ミシカ) KEEP WATCH (GID) T-SHIRT Black Spiral TD
19809 MISHKA (ミシカ) RADIOACTIVE BLOCK T-SHIRT
19811 MISHKA (ミシカ) STONEY BALONEY TIE DYE T-SHIRT
19816 MISHKA (ミシカ) DIMENSIONAL KEEP WATCH NEW ERA 5950
19960 MISHKA (ミシカ) LAMOUR KEEP WATCH NEW ERA Hurricane Camo
20063 MISHKA (ミシカ) KEEP WATCH New Era GRY/ORG SNAPBACK CAP
20314 MISHKA (ミシカ) ATOMIC KEEP WATCH TIE-DYE T-SHIRT INFERNO
20326 MISHKA (ミシカ) KEEP WATCH TIE-DYE T-SHIRT ORANGE
20327 MISHKA (ミシカ) DEAD AIM KEEP WATCH NEW ERA
20328 MISHKA (ミシカ) ANDREI BOUZIKOV: KEEP WATCH NEW ERA BLK
20329 MISHKA (ミシカ) ANDREI BOUZIKOV: KEEP WATCH NEW ERA TEAL
20332 MISHKA (ミシカ) LOGO COLLAGE BACKPACK
20347 MISHKA (ミシカ) KEEP WATCH L/S SHIRT (BLACK)
20448 MISHKA (ミシカ) ANDREI BOUZIKOV KEEP WATCH L/S SHIRT BLK
20452 MISHKA (ミシカ) ANDREI BOUZIKOV: KEEP WATCH TIE-DYE T-SHIRT
20496 MISHKA (ミシカ) CYCO MANIA TIE-DYE T-SHIRT RED SPIRAL
20611 MISHKA (ミシカ) LAMOUR SUPREME: DEATH ADDER TIE-DYE T-SHIRT