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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =17
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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 23:24:14')
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, 100
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
55790 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 キャップ
6252 MISHKA (ミシカ) KEEP WATCH OR DIE NEW ERA GREY
7812 MISHKA (ミシカ) CYRILLIC SCRIPT NEW ERA GREEN
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
11099 MISHKA (ミシカ) DART NE CYCLE CAP 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
12330 MISHKA (ミシカ) KEEP WATCH NE 5950 PURPLE
13487 MISHKA (ミシカ) KIRBY CAMO 5-PANEL CAMO
14302 MISHKA (ミシカ) ALIEN DEATH CAP
14306 MISHKA (ミシカ) DEATH ADDER NEW ERA BLACK
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
17530 MISHKA (ミシカ) KEEP WATCH NEW ERA 5950 BLACK
17531 MISHKA (ミシカ) KEEP WATCH NEW ERA 5950 Turquoise/SP151705E
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
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
21274 MISHKA (ミシカ) NEW PANIC REVERSIBLE BUCKET HAT Green/Whiti
21740 MISHKA (ミシカ) CYCO SPLIT KEEP WATCH NEW ERA 5920
21741 MISHKA (ミシカ) REFLECTIVE KEEP WATCH NEW ERA 5920
21742 MISHKA (ミシカ) OLDE SCHOOL NEW ERA 1920 STRAPBACK BLK
21743 MISHKA (ミシカ) OLDE SCHOOL NEW ERA 1920 STRAPBACK WHT
21747 MISHKA (ミシカ) AWAY KEEP WATCH NEW ERA 5920
21793 MISHKA (ミシカ) Cookie Monster Keep Watch New Era
21795 MISHKA (ミシカ) Big Bird Snapback
21796 MISHKA (ミシカ) Snuffy Emotional Snapback
22604 MISHKA (ミシカ) HERITAGE KEEP WATCH NEW ERA BLK
23302 MISHKA (ミシカ) HERITAGE DEATH ADDER NEW ERA
23303 MISHKA (ミシカ) HERITAGE KEEP WATCH NEW ERA
23429 MISHKA (ミシカ) VARSITY KEEP WATCH STRAPBACK
23430 MISHKA (ミシカ) VARSITY KEEP WATCH STRAPBACK BLACK
24181 MISHKA (ミシカ) TALLBOY KEEP WATCH TIE DYE SNAPBACK Green Tie Dye
24183 MISHKA (ミシカ) TALLBOY KEEP WATCH SNAPBACK Black
24189 MISHKA (ミシカ) SICK SAD KEEP WATCH SNAPBACK Black
24199 MISHKA (ミシカ) CYRILLIC SCRIPT SNAPBACK
24979 MISHKA (ミシカ) LIGHT BULB EYEBALL GOLF CAP
24980 MISHKA (ミシカ) CHOCOMOO PATTERNED ALL OVER BUCKET HAT
24982 MISHKA (ミシカ) MASK KEEP WATCH SNAPBACK
26551 MISHKA (ミシカ) EXPLODING KEEP WATCH NEW ERA 5950
26575 MISHKA (ミシカ) ERMSY KEEP WATCH CAP
27490 MISHKA (ミシカ) LAMOUR KEEP WATCH TIE DYE SNAPBACK Pink
27491 MISHKA (ミシカ) KEEP WATCH TIE DYE SNAPBACK Seafoam
28556 MISHKA (ミシカ) MAW163207F CAP BLACK
28557 MISHKA (ミシカ) MAW163212F CAP GALAXY BLACK
28989 MISHKA(ミシカ) MAW163218 GOLD
32262 MISHKA (ミシカ) MSS173217 SILVER KEEP WATCH CAP
32263 MISHKA (ミシカ) MSS173217 GRAY KEEP WATCH CAP
32264 MISHKA (ミシカ) MSS173217 GOLD KEEP WATCH CAP
32265 MISHKA (ミシカ) MSS173206 THUNDER BLACK KEEP WATCH CAP
32266 MISHKA (ミシカ) MSS173215 BLACK CAP
32267 MISHKA (ミシカ) MSS173215 WHITE CAP
32268 MISHKA (ミシカ) MSS173224 THUNDER KEEP WATCH CAP
33621 MISHKA(ミシカ) CYCO TRUCK MADNESS SNAPBACK
34308 MISHKA (ミシカ) MSP163206 LOGO STRAPBACK
34309 MISHKA (ミシカ) MSP163207 CAP GOLD
36898 MISHKA (ミシカ) MAW173206 GOLD KW CAP
36899 MISHKA (ミシカ) MAW173211 HAND CAP
37086 MISHKA(ミシカ) MAW173224 BLACK
37087 MISHKA(ミシカ) MAW173203 RED
37088 MISHKA(ミシカ) MAW173207 BLACK
37442 MISHKA(ミシカ) MAW173215
37443 MISHKA(ミシカ) MAW173208
37444 MISHKA(ミシカ) MAW173202
39219 MISHKA (ミシカ) MSS183204 GALAXY CAP
39221 MISHKA (ミシカ) MSS183212 DENIM CAP
39222 MISHKA (ミシカ) MSS183222 CAP
39223 MISHKA (ミシカ) MSS183210 CAP
39236 MISHKA (ミシカ) MSS183212B CAP
39237 MISHKA (ミシカ) MSS183212B CAP 2
39238 MISHKA (ミシカ) MSS183215 CAP
39807 MISHKA (ミシカ) MSS183228 CAP
39808 MISHKA (ミシカ) MSS183205 CAP
41891 MISHKA (ミシカ) MAW183227 CAP Red
41892 MISHKA (ミシカ) MAW183229 CAP Black
41893 MISHKA (ミシカ) MAW183229 CAP Pink
41894 MISHKA (ミシカ) MAW183236 CAP Black
41895 MISHKA (ミシカ) MAW183207 CAP Black
41896 MISHKA (ミシカ) MAW183235 CAP Denim
41904 MISHKA (ミシカ) MAW183201 CAP Yellow
41905 MISHKA MAW183201 CAP Black
41906 MISHKA MAW183203 CAP Red