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-21 00:29:21')
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
LIMIT 0, 120
5625 MISHKA D.A. SCRIMMAGE T-SHIRT BLACK
6252 MISHKA (ミシカ) KEEP WATCH OR DIE NEW ERA GREY
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
6522 MISHKA (ミシカ) TRAVEL MOUSEPAD: LAMOUR KW CLASSIC
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
6616 MISHKA The Keep Watch or Die Tank in Navy
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
7812 MISHKA (ミシカ) CYRILLIC SCRIPT NEW ERA GREEN
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
9304 MISHKA DEATH ADDERS FLEECE JACKET BROWN
9306 MISHKA (ミシカ) KEEP WATCH CARDIGAN RED BERRY
9329 MISHKA (ミシカ) FRAGRANT WORK PANTS OLIVE
9330 MISHKA MR. NICE GUY WORK PANTS DARK INDIGO
9333 MISHKA (ミシカ) NEW ERA: OVERSIZE ADDER DARK GREEN
9335 MISHKA (ミシカ) NEW ERA: LAMOUR KEEP WATCH MAGENTA
9336 MISHKA (ミシカ) NEW ERA: KEEP WATCH ORANGE
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
10035 MISHKA (ミシカ) NEW ERA: ARMY OF DARKNESS BLACK
10068 MISHKA (ミシカ) BORIS SKINNY-LEG DENIM BLACK
10070 MISHKA (ミシカ) ANIMAL PARADE BUTTON UP STORMY BLACK
10071 MISHKA (ミシカ) TERRITORY BUTTON UP WHITE
10208 MISHKA (ミシカ) RUBBER KEYCHAINS D.A.R.T
10209 MISHKA (ミシカ) RUBBER KEYCHAINS LOBSTER ROLL
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
10602 MISHKA (ミシカ) JUNIOR ADDER BEANIE BLACK
10608 MISHKA (ミシカ) HELLA STUFF PULLOVER WHITE
10657 MISHKA (ミシカ) LULZ SHORT SLEEVE BUTTON UP WHITE
10660 MISHKA (ミシカ) ETD CRACKLED DEBOSSED BELT BLACK
10773 MISHKA (ミシカ) D.A. SNAKEBITE POM BEANIE GREEN
10778 MISHKA (ミシカ) HEATSEEKER POM BEANIE GREEN
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
10828 MISHKA (ミシカ) GHOST TO THE POST II TANK TOP BLACK
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
11084 MISHKA (ミシカ) PARTY ANIMAL T-SHIRT RED
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
11099 MISHKA (ミシカ) DART NE CYCLE CAP WHITE
11909 MISHKA (ミシカ) D.A. SNAKE BITE POM BEANIE GREEN
11913 MISHKA (ミシカ) WAVE ETD POM BEANIE MULTI
11915 MISHKA (ミシカ) JUNGLE BDU SHORTS DAY
11916 MISHKA (ミシカ) MR. NICE GUY II SHORTS BLUE
12188 MISHKA (ミシカ) KEEP WATCH SHORTS WHITE
12189 MISHKA (ミシカ) KILL WITH POWER SHORTS BLACK
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
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
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