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 04:24:06')
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 MAX(price02)
LIMIT 0, 120
37375 Hi-STANDARD×MISHKA EXWDHS02H SPHINX PULLOVER WHT
10828 MISHKA (ミシカ) GHOST TO THE POST II TANK TOP BLACK
58624 MISHKA OPTIC KEEP WATCH TEE WHITE
58627 MISHKA SPOOKY CREW TEE WHITE
58628 MISHKA SPOOKY CREW TEE PINK
6616 MISHKA The Keep Watch or Die Tank in Navy
30106 MISHKA (ミシカ) KEYHOLE KEEP WATCH T-SHIRT
52660 MISHKA MSS200034 T-SHIRTS SAFTY GREEN
53870 MISHKA(ミシカ) MSS200085 T-SHIRTS WHITE
54452 MISHKA(ミシカ) MSS200031 T-SHIRTS Safety Green
60292 MISHKA M61000007 T-SHIRT BLACK
39982 MISHKA (ミシカ) MSKBC-1T T-Shirt LT PINK
39983 MISHKA (ミシカ) MSKBC-1T T-Shirt Black
39984 MISHKA (ミシカ) MSKBC-1T T-Shirt Orange
39985 MISHKA (ミシカ) MSKBC-1T T-Shirt White
39986 MISHKA (ミシカ) MSKBC-1T T-Shirt Purple
39988 MISHKA (ミシカ) MSKBC-1T T-Shirt Gray
39989 MISHKA (ミシカ) MSKBC-1T T-Shirt LT Blue
39990 MISHKA (ミシカ) MSKBC-1T T-Shirt LT Yellow
39991 MISHKA (ミシカ) MSKBC-1T T-Shirt LT Navy
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
58572 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE PURPLE
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
14769 MISHKA (ミシカ) KEEP WATCH LEGGINGS MULTI
58573 MISHKA(ミシカ) M21000005 T-Shirt
60171 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE BLACK
60172 MISHKA X DENNIS THE MENACE DENNIS TEE WHITE
61816 MISHKA (ミシカ) M21100053 T-SHIRT BLACK
39992 MISHKA (ミシカ) MSKBC-1L L/S T-Shirt Black
39993 MISHKA (ミシカ) MSKBC-1L L/S T-Shirt White
39994 MISHKA (ミシカ) MSKBC-1L L/S T-Shirt Navy
6316 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK NAVY
10824 MISHKA (ミシカ) CYCO PUSHER TANK TOP BLACK
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
11092 MISHKA (ミシカ) THE WORLD WIDE WEIRDOS TANK BLACK
12265 MISHKA (ミシカ) YAIA GIFT SANDS OF DOOM TANK BLACK
12289 MISHKA (ミシカ) BEAST IMPACT TANK TOP WHITE
12290 MISHKA (ミシカ) BEAST IMPACT TANK TOP BLACK
12317 MISHKA (ミシカ) DARK PORTAL TANK TOP WHITE
12318 MISHKA (ミシカ) DARK PORTAL TANK TOP BLACK
12327 MISHKA (ミシカ) PIZZA KEEP WATCH TANK WHITE
20031 MISHKA (ミシカ) PIZZA KEEP WATCH TANK BLACK
27834 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE BLK
27835 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE WHT
27836 FAMOUS STARS AND STRAPS x MISHKA MERCY TEE BLK
27837 FAMOUS STARS AND STRAPS x MISHKA MERCY TEE WHT
52245 MISHKA MSS200006F80 T-SHIRTS WHITE
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
6285 MISHKA (ミシカ) KEEP WATCH T-SHIRT WHITE
6291 MISHKA (ミシカ) WESTWORLD 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
7282 MISHKA (ミシカ) PIXEL MOP T-SHIRT BLACK
9494 MISHKA LAMOUR KEEP WATCH T-SHIRT BLACK
9502 MISHKA (ミシカ) DEATH ADDER T-SHIRT BLACK/LIGHTGREEN
9509 MISHKA (ミシカ) ENFORCER T-SHIRT 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
10812 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT WHITE
10814 MISHKA (ミシカ) DAVY JONES LOCKER T-SHIRT BLACK
10826 MISHKA (ミシカ) FINAL MOMENTS TANK TOP PURPLE TIE-DYE
11084 MISHKA (ミシカ) PARTY ANIMAL T-SHIRT RED
11089 MISHKA (ミシカ) FROM THE ASHES T-SHIRT PURPLE
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
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
12319 MISHKA (ミシカ) OVERSPRAY KEEP WATCH TANK BLACK
13004 MISHKA (ミシカ) KEEP WATCH T-SHIRT PURPLE
13311 MISHKA (ミシカ) DA NATION T-SHIRT BLACK
13490 MISHKA (ミシカ) LAMOUR CYCO BOOTLEG T-SHIRT HEATHER
14766 MISHKA (ミシカ) GONE BLACK T-SHIRT
14772 MISHKA (ミシカ) 8-BIT KEEP WATCH T-SHIRT WHITE
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
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
18848 MISHKA (ミシカ) MECHA KEEP WATCH T-SHIRT
18850 MISHKA (ミシカ) CHILD OF THE SYSTEM T-SHIRT
18854 MISHKA (ミシカ) LAMOUR GRAPPLER BEAST T-SHIRT BLK
18855 MISHKA (ミシカ) LAMOUR GRAPPLER BEAST T-SHIRT WHT
18859 MISHKA (ミシカ) MORBID ROT KEEP WATCH T-SHIRT
18860 MISHKA (ミシカ) STONEY BALONEY T-SHIRT Black/SM151104
18863 MISHKA (ミシカ) KEEP WATCH (GID) T-SHIRT
19807 MISHKA (ミシカ) DIMENSIONAL KEEP WATCH T-SHIRT
20271 MISHKA (ミシカ) SOFT T-SHIRT WHT
20272 MISHKA (ミシカ) SOFT T-SHIRT BLK
20273 MISHKA (ミシカ) SLOBO MOP TEE
20274 MISHKA (ミシカ) DAMAGED KEEP WATCH T-SHIRT
20275 MISHKA (ミシカ) LAMOUR KEEP WATCH WHT
20276 MISHKA (ミシカ) LAMOUR KEEP WATCH BLK
20277 MISHKA (ミシカ) LAMOUR KEEP WATCH PINK
20278 MISHKA (ミシカ) RELEASE THE BATS T-SHIRT WHT
20279 MISHKA (ミシカ) RELEASE THE BATS T-SHIRT BLK