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 13:56:09')
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
LIMIT 0, 120
51510 MISHKA MSS200055F12 L/S TEE SAFTY GREEN
60666 MISHKA M61000729 JACKET GRAY
10828 MISHKA (ミシカ) GHOST TO THE POST II TANK TOP BLACK
11084 MISHKA (ミシカ) PARTY ANIMAL T-SHIRT RED
27484 MISHKA (ミシカ) JV KEEP WATCH BASKETBALL JERSEY White
38833 MISHKA (ミシカ) LAMOUR SCUM LOVE T-SHIRT FL 171116 YEL
40647 MISHKA SP181303 FLYING TIGER KEEP WATCH TEE BLACK
42873 MISHKA x AIR JAM 2018 TEE WHITE
55658 MISHKA (ミシカ) KEEP WATCH SWIM SHORTS
6616 MISHKA The Keep Watch or Die Tank in Navy
9306 MISHKA (ミシカ) KEEP WATCH CARDIGAN RED BERRY
52681 MISHKA Incoming Transmission Longsleeve White
53882 MISHKA(ミシカ) MSS200874 PANTS
53884 MISHKA(ミシカ) MSS200072 HOODIE WHITE
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
12207 MISHKA (ミシカ) KEEP WATCH TANK TOP BLACK
12208 MISHKA (ミシカ) KEEP WATCH TANK TOP WHITE
12209 MISHKA (ミシカ) CRYPT KEEPER TANK TOP BLACK
12210 MISHKA (ミシカ) CRYPT KEEPER TANK TOP WHITE
12264 MISHKA (ミシカ) SONS OF NIHILISM T-SHIRT RED TIE DYE
12265 MISHKA (ミシカ) YAIA GIFT SANDS OF DOOM TANK BLACK
12276 MISHKA (ミシカ) HELLS BELLS T-SHIRT HEATHER GREY
12278 MISHKA (ミシカ) BEAST IMPACT T-SHIRT PURPLE
12279 MISHKA (ミシカ) BEAST IMPACT T-SHIRT WHITE
12281 MISHKA (ミシカ) MURDER JUNKIE T-SHIRT BLACK
12282 MISHKA (ミシカ) PERMANEBT VACATION T-SHIRT TEAL TIE DYE
12284 MISHKA (ミシカ) CYCO JERKS T-SHIRT BLACK
12286 MISHKA (ミシカ) YAIA GIFT SANDS OF DOOM T-SHIRT WHITE
12287 MISHKA (ミシカ) YAIA GIFT SANDS OF DOOM T-SHIRT BLACK
12289 MISHKA (ミシカ) BEAST IMPACT TANK TOP WHITE
12290 MISHKA (ミシカ) BEAST IMPACT TANK TOP BLACK
12293 MISHKA (ミシカ) DARK PORTAL T-SHIRT HEATHER GREY
12297 MISHKA (ミシカ) CYCO POP T-SHIRT BLACK
12298 MISHKA (ミシカ) CYCO POP T-SHIRT TURQUOISE
12300 MISHKA (ミシカ) CYCO POP T-SHIRT WHITE
12315 MISHKA (ミシカ) OFF SIDE T-SHIRT BLACK
12317 MISHKA (ミシカ) DARK PORTAL TANK TOP WHITE
12318 MISHKA (ミシカ) DARK PORTAL TANK TOP BLACK
12319 MISHKA (ミシカ) OVERSPRAY KEEP WATCH TANK BLACK
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
12327 MISHKA (ミシカ) PIZZA KEEP WATCH TANK WHITE
12537 MISHKA (ミシカ) IRON SKULL T-SHIRT WHITE
13004 MISHKA (ミシカ) KEEP WATCH T-SHIRT PURPLE
13241 MISHKA (ミシカ) LAMOUR ENTOMBED BUTTON UP WHITE
13309 MISHKA (ミシカ) DEATH RITUAL 78 T-SHIRT BLACK
13310 MISHKA (ミシカ) PARALYZED T-SHIRT BLACK
13311 MISHKA (ミシカ) DA NATION T-SHIRT BLACK
13324 MISHKA (ミシカ) CREEPING DEATH SPLIT ZIP HOODIE BLACK
13326 MISHKA (ミシカ) LAMOUR ENTOMBED JACKET WHITE
13475 MISHKA (ミシカ) CYCO TARANTURA TIE-DYE T-SHIRT TURQUOISE
13490 MISHKA (ミシカ) LAMOUR CYCO BOOTLEG T-SHIRT HEATHER
13495 MISHKA (ミシカ) DEATH DIVISION T-SHIRT CAMO
13497 MISHKA (ミシカ) KIRBY KEEP WATCH CAMO T-SHIRT CAMO
13500 MISHKA (ミシカ) DEATH ADDER T-SHIRT BLACK