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 11:30:11')
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, 60
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
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
59364 MISHKA(ミシカ) 96187 CAP
58137 MISHKA M21003251 Cap White
58136 MISHKA M21003251 Cap Black
55790 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 キャップ
56182 MISHKA(ミシカ) MAW203228 CAP
54465 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 キャップ
6252 MISHKA (ミシカ) KEEP WATCH OR DIE NEW ERA GREY
6975 MISHKA (ミシカ) K.W. DESTROY! PAINTERS CAP BLACK
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
12228 MISHKA (ミシカ) KILL WITH POWER NE 5950 RED
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
12259 MISHKA (ミシカ) DESTROY WORLD WIDESNAPBACK BLACK
12330 MISHKA (ミシカ) KEEP WATCH NE 5950 PURPLE
13478 MISHKA (ミシカ) DEATH ADDER TIE DYE NEW ERA PURPLE
13487 MISHKA (ミシカ) KIRBY CAMO 5-PANEL CAMO
14302 MISHKA (ミシカ) ALIEN DEATH CAP
14305 MISHKA (ミシカ) DEATH ADDER NEW ERA BURGUNDY
14306 MISHKA (ミシカ) DEATH ADDER NEW ERA BLACK
14775 MISHKA (ミシカ) BOOTLEG HORNS SNAPBACK 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
16835 MISHKA (ミシカ) KANJI AUTOPSY SNAPBACK
17530 MISHKA (ミシカ) KEEP WATCH NEW ERA 5950 BLACK
17531 MISHKA (ミシカ) KEEP WATCH NEW ERA 5950 Turquoise/SP151705E
17532 MISHKA (ミシカ) ETERNAL KEEP WATCH NEW ERA 5950
17534 MISHKA (ミシカ) LAMOUR KEEP WATCH NEW ERA 5950 PURPLE
18843 MISHKA (ミシカ) CYRILLIC BONES (GID) SNAPBACK
18932 MISHKA (ミシカ) LAMOUR KEEP WATCH SNAPBACK
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
20330 MISHKA (ミシカ) ATOMIC KEEP WATCH SNAPBACK
20494 MISHKA (ミシカ) KEEP WATCH SNAPBACK RED
20495 MISHKA (ミシカ) MISHKA KEEP WATCH SNAPBACK BLACK
20499 MISHKA (ミシカ) CYCO MANIA SNAPBACK BLACK/WHITE
21274 MISHKA (ミシカ) NEW PANIC REVERSIBLE BUCKET HAT Green/Whiti
21727 MISHKA (ミシカ) SPENCER NUZZI DEATH AND ONLY DEATH SNAPBACK
21740 MISHKA (ミシカ) CYCO SPLIT KEEP WATCH NEW ERA 5920