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-25 15:23:27')
AND pc.price02 > 909
AND price02 <= 2727
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, 120
61816 MISHKA (ミシカ) M21100053 T-SHIRT BLACK
60292 MISHKA M61000007 T-SHIRT BLACK
60171 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE BLACK
60172 MISHKA X DENNIS THE MENACE DENNIS TEE WHITE
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
58573 MISHKA(ミシカ) M21000005 T-Shirt
58628 MISHKA SPOOKY CREW TEE PINK
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
58624 MISHKA OPTIC KEEP WATCH TEE WHITE
58627 MISHKA SPOOKY CREW TEE WHITE
60268 MISHKA M61000056 T-SHIRT BLACK
58629 MISHKA SPOOKY CREW TEE BLACK
58572 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE PURPLE
57364 MISHKA M21000001 L/S T-Shirt BLACK
57373 MISHKA M21003353 SOCKS RED
57372 MISHKA M21003353 SOCKS BLUE
57370 MISHKA M21003354 SOCKS GREEN
57369 MISHKA M21003354 SOCKS BLACK
57371 MISHKA M21003354 SOCKS PURPLE
55931 MISHKA MAW203353 SOCKS BLACK
55933 MISHKA MAW203355 SOCKS BLACK
55930 MISHKA MAW203353 SOCKS SAFTY GREEN
56891 MISHKA(ミシカ) TAPE SET
55908 MISHKA MAW200002 L/S T-SHIRTS SAFTY GREEN
55932 MISHKA MAW203354 SOCKS BLACK
55983 MISHKA(ミシカ) 89534 LANYARD
55901 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS WHITE
55904 MISHKA x Johnny Ryan DON'T LET THEM L/S T-SHIRTS BLUE
6285 MISHKA (ミシカ) KEEP WATCH T-SHIRT WHITE
6291 MISHKA (ミシカ) WESTWORLD T-SHIRT BLACK
6316 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK NAVY
6522 MISHKA (ミシカ) TRAVEL MOUSEPAD: LAMOUR KW CLASSIC
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
7282 MISHKA (ミシカ) PIXEL MOP T-SHIRT BLACK
9494 MISHKA LAMOUR KEEP WATCH T-SHIRT BLACK
9502 MISHKA (ミシカ) DEATH ADDER T-SHIRT BLACK/LIGHTGREEN
9503 MISHKA (ミシカ) LUNAR SCORPION T-SHIRT BLACK
9509 MISHKA (ミシカ) ENFORCER T-SHIRT BLACK
10602 MISHKA (ミシカ) JUNIOR ADDER BEANIE 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
10812 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT WHITE
10814 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT BLACK
10824 MISHKA (ミシカ) CYCO PUSHER TANK TOP BLACK
10826 MISHKA (ミシカ) FINAL MOMENTS TANK TOP PURPLE TIE-DYE
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
11089 MISHKA (ミシカ) FROM THE ASHES T-SHIRT PURPLE
11092 MISHKA (ミシカ) THE WORLD WIDE WEIRDOS TANK BLACK
11909 MISHKA (ミシカ) D.A. SNAKE BITE POM BEANIE GREEN
11913 MISHKA (ミシカ) WAVE ETD POM BEANIE MULTI
12259 MISHKA (ミシカ) DESTROY WORLD WIDESNAPBACK BLACK
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
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
12327 MISHKA (ミシカ) PIZZA KEEP WATCH TANK WHITE
12921 MISHKA (ミシカ) TELESCOPIC PENCIL CASE SKYBLUE
13004 MISHKA (ミシカ) KEEP WATCH T-SHIRT PURPLE
13304 MISHKA (ミシカ) ENTOMBED CYCO BEANIE WHITE
13306 MISHKA (ミシカ) LAMOUR KEEP WATCH POM BEANIE BLACK
13311 MISHKA (ミシカ) DA NATION T-SHIRT BLACK
13481 MISHKA (ミシカ) LAMOUR KEEP WATCH RUMBLE POM BEANIE
13482 MISHKA (ミシカ) LAMOUR CYCO BOOTLEG POM BEANIE
13483 MISHKA (ミシカ) HEATSEEKER POM BEANIE TEAL
13484 MISHKA (ミシカ) HEATSEEKER POM BEANIE RED
13486 MISHKA (ミシカ) DEATH ADDER BEANIE BLACK
13490 MISHKA (ミシカ) LAMOUR CYCO BOOTLEG T-SHIRT HEATHER
14362 Nunettes x MISHKA SUNGLASSES EYE Red
14366 Nunettes x MISHKA SUNGLASSES EYE Purple
14367 Nunettes x MISHKA SUNGLASSES EYE BLACK
14626 MISHKA (ミシカ) KEEP WATCH SAFARI POM BEANIE GREEN
14627 MISHKA (ミシカ) KEEP WATCH SAFARI POM BEANIE BROWN
14764 MISHKA (ミシカ) KEEP WATCH T-SHIRT 2014HO BLACK
14766 MISHKA (ミシカ) GONE BLACK T-SHIRT
14769 MISHKA (ミシカ) KEEP WATCH LEGGINGS MULTI
14772 MISHKA (ミシカ) 8-BIT KEEP WATCH T-SHIRT WHITE
14775 MISHKA (ミシカ) BOOTLEG HORNS SNAPBACK BLACK
14778 MISHKA (ミシカ) BOOTLEG HORNS POM BEANIE RED
14840 MISHKA (ミシカ) AUTOPSY SKULL T-SHIRT
14900 MISHKA (ミシカ) OVERSIZED DEATH ADDER T-SHIRT BLACK
14901 MISHKA (ミシカ) OVERSIZED DEATH ADDER T-SHIRT NAVY
14902 MISHKA (ミシカ) OVERSIZED DEATH ADDER T-SHIRT CARDINAL
14905 MISHKA (ミシカ) SOCIETY OF THE SNAKE REDUX T-SHIRT BLACK
14967 MISHKA (ミシカ) MISHKA RX T-SHIRT
15012 MISHKA (ミシカ) RX T-SHIRT GRAY
16821 MISHKA (ミシカ) KAWAII ADDER T-SHIRT BLACK
16822 MISHKA (ミシカ) KAWAII ADDER T-SHIRT Magenta
16823 MISHKA (ミシカ) KAWAII ADDER T-SHIRT WHITE
16835 MISHKA (ミシカ) KANJI AUTOPSY SNAPBACK
17416 MISHKA (ミシカ) STONEY BALONEY T-SHIRT BLACK
17519 MISHKA (ミシカ) BLIND SPOT MUSCLE T-SHIRT BLACK
17520 MISHKA (ミシカ) BLIND SPOT MUSCLE T-SHIRT WHITE
17522 MISHKA (ミシカ) KEEP WATCH T-SHIRT Turquoise/SP151101
17528 MISHKA (ミシカ) DEATH ADDER T-SHIRT BLACK/SP151119
17588 MISHKA (ミシカ) KEEP WATCH TIE DYE TANK TOP BLACK SPHERE
18843 MISHKA (ミシカ) CYRILLIC BONES (GID) SNAPBACK
18848 MISHKA (ミシカ) MECHA KEEP WATCH T-SHIRT
18850 MISHKA (ミシカ) CHILD OF THE SYSTEM T-SHIRT