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-29 00:38:00')
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 240, 120
56886 MISHKA(ミシカ) MAW200678 JACKET
55792 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 コーチJKT
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
56887 MISHKA(ミシカ) MAW200737 JACKET
56176 MISHKA(ミシカ) MAW200612 JACKET BLACK
56885 MISHKA(ミシカ) MAW200508 JACKET
56888 MISHKA(ミシカ) MAW200901 PANTS
55977 MISHKA(ミシカ) MAW200512 JACKET
55925 MISHKA MAW200911 PANTS
55976 MISHKA(ミシカ) MAW200511 JACKET
56876 MISHKA(ミシカ) MAW200374 SWEATER BLACK
56877 MISHKA(ミシカ) MAW200470 HOODIE ORANGE
56878 MISHKA(ミシカ) MAW200470 HOODIE SAFTY GREEN
56879 MISHKA(ミシカ) MAW200470 HOODIE BLACK
55917 MISHKA MAW200210 SHIRTS
55906 MISHKA MAW200002 L/S T-SHIRTS WHITE
56889 MISHKA(ミシカ) FRKO x Mishka "Pop! Pop! Pop!" Hoodie BLACK
56890 MISHKA(ミシカ) FRKO x Mishka "Pop! Pop! Pop!" Hoodie ASHGRAY
55914 MISHKA MAW200423 SWEAT WHITE
56180 MISHKA(ミシカ) MAW200405 HOODIE BLACK
56181 MISHKA(ミシカ) MAW200405 HOODIE BEIGE
55926 MISHKA MAW200904 PANTS
55978 MISHKA(ミシカ) MAW200507 JACKET BLACK
55979 MISHKA(ミシカ) MAW200507 JACKET SAFTY GREEN
55922 MISHKA MAW200380 CARDIGAN
55923 MISHKA MAW200376 CARDIGAN
55915 MISHKA MAW200401 HOODIE BLACK
55916 MISHKA MAW200401 HOODIE WHITE
55918 MISHKA MAW200214 SHIRTS
55980 MISHKA(ミシカ) MAW200608W JACKET
55919 MISHKA MAW200201 SHIRTS
55920 MISHKA MAW200377 KNIT BLACK
55921 MISHKA MAW200377 KNIT 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
55908 MISHKA MAW200002 L/S T-SHIRTS SAFTY GREEN
55912 MISHKA MAW200004 T-SHIRTS BEIGE
55911 MISHKA MAW200004 T-SHIRTS WHITE
55924 MISHKA MAW200809 PANTS
55900 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS BLACK
55901 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS WHITE
55902 MISHKA x Johnny Ryan WILLY WASHUMS S/S T-SHIRTS
55903 MISHKA x Johnny Ryan DON'T LET THEM S/S T-SHIRTS
55904 MISHKA x Johnny Ryan DON'T LET THEM L/S T-SHIRTS BLUE
55913 MISHKA MAW200423 SWEAT BLACK
54463 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 パーカー
54464 【バンドリ!×ゲキクロ第1弾復刻】MISHKA×戸山香澄コラボ 限定 Tシャツ
54198 MISHKA MSS200029M80 T-SHIRTS WHITE
54199 MISHKA MSS200029M80 T-SHIRTS BLACK
54196 MISHKA MSS200033F80 T-SHIRTS WHITE
54197 MISHKA MSS200033F80 T-SHIRTS BLACK
54450 MISHKA(ミシカ) MSS200839 SHORTS
54656 MISHKA(ミシカ) MSS200830 PANTS
6265 MISHKA (ミシカ) ANTIGONE BUTTON-UP WHITE
6285 MISHKA (ミシカ) KEEP WATCH T-SHIRT WHITE
6291 MISHKA (ミシカ) WESTWORLD T-SHIRT BLACK
6316 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK NAVY
6317 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK BLACK
6435 MISHKA (ミシカ) KEEP WATCH BASEBALL JACKET BLACK
6452 MISHKA (ミシカ) SOLID KEEP WATCH POLO NAVY
6502 MISHKA 3-DESTROY T-SHIRT TURQUOISE
6566 MISHKA DART RING T-SHIRT BLACK
6568 MISHKA (ミシカ) SKY BEAR MOP T-SHIRT BLACK
6573 MISHKA (ミシカ) DEATH ADDERS T-SHIRT BLACK
6612 MISHKA (ミシカ) The Keep Watch or Die Tee in Black
6975 MISHKA (ミシカ) K.W. DESTROY! PAINTERS CAP BLACK
7185 MISHKA (ミシカ) BONEYARD SHIRT BLACK
7282 MISHKA (ミシカ) PIXEL MOP T-SHIRT BLACK
7289 MISHKA (ミシカ) KEEP WATCH TANK TOP WHITE
8139 MISHKA (ミシカ) KEEP WATCH CARDIGAN HEATHER GREY
8142 MISHKA KEEP WATCH VINTAGE JACKET HEATHER CRIMSON
8266 MISHKA (ミシカ) VERMILYEA KEEP WATCH T-SHIRT BLACK
8778 MISHKA (ミシカ) FOLEY LETTERMAN JACKET BLACK
8921 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT ATHLETIC HEATHER
8923 MISHKA (ミシカ) OVERSIZE ETD BADGE T-SHIRT BLACK
9182 MISHKA (ミシカ) RAKE CPO JACKET ARMY GREEN
9183 MISHKA (ミシカ) RAKE CPO JACKET BLACK
9494 MISHKA LAMOUR KEEP WATCH T-SHIRT BLACK
9495 MISHKA (ミシカ) KEEP WATCH T-SHIRT BURGUNDY
9497 MISHKA (ミシカ) KEEP WATCH T-SHIRT HEATHER
9502 MISHKA (ミシカ) DEATH ADDER T-SHIRT BLACK/LIGHTGREEN
9503 MISHKA (ミシカ) LUNAR SCORPION T-SHIRT BLACK
9509 MISHKA (ミシカ) ENFORCER T-SHIRT BLACK
9510 MISHKA (ミシカ) CYCO SERPENT T-SHIRT BLACK
10027 MISHKA (ミシカ) AOD NECRONOMICON CREWNECK BLACK
10028 MISHKA (ミシカ) AOD NECRONOMICON T-SHIRT BLACK
10070 MISHKA (ミシカ) ANIMAL PARADE BUTTON UP STORMY BLACK
10071 MISHKA (ミシカ) TERRITORY BUTTON UP WHITE
10608 MISHKA (ミシカ) HELLA STUFF PULLOVER WHITE
10657 MISHKA (ミシカ) LULZ SHORT SLEEVE BUTTON UP WHITE
10660 MISHKA (ミシカ) ETD CRACKLED DEBOSSED BELT BLACK
10791 MISHKA (ミシカ) BEAST OF THE EAST T-SHIRT BLACK YELLOW
10792 MISHKA (ミシカ) BEAST OF THE EAST T-SHIRT NAVY BLUE
10795 MISHKA (ミシカ) CITY ON FIRE T-SHIRT BLACK
10807 MISHKA (ミシカ) CYCO PUSHER RAGLAN WHITE
10812 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT WHITE
10814 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT BLACK
10815 MISHKA (ミシカ) DEATH DEALER T-SHIRT GREY LAVA TIE DYE
10822 MISHKA (ミシカ) CYCO PUSHER TANK TOP TIE-DYE
10824 MISHKA (ミシカ) CYCO PUSHER TANK TOP BLACK
10826 MISHKA (ミシカ) FINAL MOMENTS TANK TOP PURPLE TIE-DYE
10832 MISHKA (ミシカ) KEEP WATCH TANK RED
10833 MISHKA (ミシカ) LAMOUR RING OF HELL KW TANK TOP BLACK
11082 MISHKA (ミシカ) THE MOTOR CITY DEATH ADDERS TANK TOP BLACK
11087 MISHKA (ミシカ) CYCO SPIDER TANK BLACK
11088 MISHKA (ミシカ) OVER SIZE BEAR MOP TIE-DYE T-SHIRT MAGENTA
11089 MISHKA (ミシカ) FROM THE ASHES T-SHIRT PURPLE
11091 MISHKA (ミシカ) THE WORLD WIDE WEIRDOS TANK GREEN TIE DYE
11092 MISHKA (ミシカ) THE WORLD WIDE WEIRDOS TANK BLACK
11093 MISHKA (ミシカ) THE CYRILLIC MOSAIC POCKET TEE BLACK
11096 MISHKA (ミシカ) THE HELLA STUFF S/S BUTTONDOWN BLACK
11097 MISHKA (ミシカ) THE HELLA STUFF S/S BUTTONDOWN WHITE
12188 MISHKA (ミシカ) KEEP WATCH SHORTS WHITE
12192 MISHKA (ミシカ) SNAKE BITE BOA TANK TOP BOA
12194 MISHKA (ミシカ) BEAST OF THE EAST TANK TOP ARMY
12195 MISHKA (ミシカ) BEAST OF THE EAST TANK TOP WHITE
12204 MISHKA (ミシカ) MR. NICE GUY II TANK TOP STRAWBERRY
12206 MISHKA (ミシカ) KEEP WATCH DYNASTY TANK TOP GOLD