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 22:42:00')
AND pc.price02 > 909
AND price02 <= 2727
AND pc.classcategory_id1 IN( 11)
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
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
55908 MISHKA MAW200002 L/S T-SHIRTS SAFTY GREEN
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
10833 MISHKA (ミシカ) LAMOUR RING OF HELL KW TANK TOP BLACK
12319 MISHKA (ミシカ) OVERSPRAY KEEP WATCH TANK BLACK
14766 MISHKA (ミシカ) GONE BLACK T-SHIRT
17416 MISHKA (ミシカ) STONEY BALONEY T-SHIRT BLACK
18848 MISHKA (ミシカ) MECHA KEEP WATCH T-SHIRT
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
20273 MISHKA (ミシカ) SLOBO MOP TEE
20279 MISHKA (ミシカ) RELEASE THE BATS T-SHIRT BLK
20315 MISHKA (ミシカ) ATOMIC KEEP WATCH T-SHIRT BLACK
20324 MISHKA (ミシカ) KEEP WATCH T-SHIRT BLK/GRN
20450 MISHKA (ミシカ) ANDREI BOUZIKOV KEEP WATCH T-SHIRT BLK
20451 MISHKA (ミシカ) ANDREI BOUZIKOV KEEP WATCH T-SHIRT H.Navy
21912 MISHKA (ミシカ) SPLIT ICONS TEE
21916 MISHKA (ミシカ) WORLDWIDE DEATH ADDERS INC. TEE
21920 MISHKA (ミシカ) MONOCHROME KEEP WATCH TEE BLK
21921 MISHKA (ミシカ) GLOW IN THE DARK KEEP WATCH TEE Celadon
21924 MISHKA (ミシカ) CYCO SPLIT KEEP WATCH TEE
21967 MISHKA (ミシカ) CYCO NECRO T-SHIRT
23870 MISHKA (ミシカ) TALLBOY KEEP WATCH TEE BLACK
24191 MISHKA (ミシカ) MISHKA (ミシカ) KEEP WATCH CAMO BOX LOGO TEE Black
25315 MISHKA (ミシカ) GALAXY KEEP WATCH TEE WHITE
25316 MISHKA (ミシカ) GALAXY KEEP WATCH TEE BLACK
25317 MISHKA (ミシカ) LAMOUR RING OF HELL KW TEE WHITE
25318 MISHKA (ミシカ) LAMOUR RING OF HELL KW TEE BLACK
25319 MISHKA (ミシカ) CYRILLIC KEEP WATCH TEE WHITE
25320 MISHKA (ミシカ) CYRILLIC KEEP WATCH TEE BLACK
25321 MISHKA (ミシカ) CLASSIC KEEP WATCH TEE WHITE
25322 MISHKA (ミシカ) CLASSIC KEEP WATCH TEE BLACK
25323 MISHKA (ミシカ) COOKIE KEEP WATCH TEE WHITE
25324 MISHKA (ミシカ) COOKIE KEEP WATCH TEE BLACK
25325 MISHKA (ミシカ) SMILEY KEEP WATCH TEE WHITE
25326 MISHKA (ミシカ) SMILEY KEEP WATCH TEE BLACK
25328 MISHKA (ミシカ) CAMO KEEP WATCH TEE BLACK
26553 MISHKA (ミシカ) TONAL KEEP WATCH TEE Black
26554 MISHKA (ミシカ) TONAL KEEP WATCH TEE White
26555 MISHKA (ミシカ) TRASH POCKET TEE White
27459 MISHKA (ミシカ) EXPLODING KEEP WATCH TEE
27462 MISHKA (ミシカ) EXPLODING KEEP WATCH TANK Black
27468 MISHKA (ミシカ) DAMAGED KEEP WATCH TEE Black
27469 MISHKA (ミシカ) DAMAGED KEEP WATCH TEE White
27834 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE BLK
27835 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE WHT
27837 FAMOUS STARS AND STRAPS x MISHKA MERCY TEE WHT
28185 MISHKA (ミシカ) SOFT CREAM TEE BLACK
28186 MISHKA (ミシカ) WATERMALON TEE BLACK
28187 MISHKA (ミシカ) ICE TEE BLACK
29764 MISHKA LAMOUR CYCO HANDPLANT TEE BLK
29772 MISHKA HAZELIP KEEP WATCH TEE BLK
29799 MISHKA MISLED YOUTH TEE WHT
29800 MISHKA MISLED YOUTH TEE BLK
29806 MISHKA LAMOUR SPLIT ICONS TEE BLK
29807 MISHKA x BAKER RITUAL TEE BLK
29958 MISHKA (ミシカ) AIR JAM 2016 x MISHKA TEE BLACK
29959 MISHKA (ミシカ) AIR JAM 2016 x MISHKA TEE WHITE
33628 MISHKA (ミシカ) Hyper Real Keep Watch Ash Black
33637 MISHKA (ミシカ) ICE CREAM TEE BLK
33638 MISHKA (ミシカ) ICE CREAM TEE WHT
33644 MISHKA (ミシカ) ICE CREAM TEE PINK
33651 MISHKA (ミシカ) LAMOUR K.W TEE WHT
33654 MISHKA (ミシカ) LAMOUR K.W TEE PINK
34038 MISHKA (ミシカ) EXSP1701OL TEE BLACK
34039 MISHKA (ミシカ) EXSP1702OL TEE BLACK
34040 MISHKA (ミシカ) EXSP1702OL TEE WHITE
34041 MISHKA (ミシカ) EXSP1703OL TEE SEAFOAM
34042 MISHKA (ミシカ) EXSP1704OL TEE BLACK
34044 MISHKA (ミシカ) EXSP1706OL BLACK
34045 MISHKA (ミシカ) EXSP1707OL BLACK
34046 MISHKA (ミシカ) EXSP1708OL TEE BLACK
34047 MISHKA (ミシカ) EXSP1709OL (L/S T) LONGSLEEVE TEE BLACK
34050 MISHKA (ミシカ) EXSP1712OL TEE BLACK
34052 MISHKA (ミシカ) EXSP1713OL TEE BLACK
34057 MISHKA (ミシカ) MELTDOWN KEEP WATCH BLACK
34413 MISHKA (ミシカ) MISHKA (ミシカ) EXSP1703OL TEE BLACK
35056 MISHKA (ミシカ) EXSP1723 WHITE
35057 MISHKA (ミシカ) EXSP1723 BLACK
35063 MISHKA (ミシカ) EXSP1723 PURPLE
35065 MISHKA (ミシカ) EXSP1724 BLACK
35066 MISHKA (ミシカ) EXSP1724 WHITE
35067 MISHKA (ミシカ) EXSP1724 PINK
35265 MISHKA (ミシカ) MSS170052 BLACK
36247 MISHKA (ミシカ) Butterfly Keep Watch Tank Tops BLACK
36248 MISHKA (ミシカ) Butterfly Keep Watch TEE WHITE
36249 MISHKA (ミシカ) Butterfly Keep Watch TEE BLACK
36256 MISHKA (ミシカ) Wrung Out Keep Watch TEE WHITE
36257 MISHKA (ミシカ) Wrung Out Keep Watch TEE BLACK
37303 MISHKA (ミシカ) EXFA1800 WHITE
37304 MISHKA (ミシカ) EXFA1800 YELLOW
37305 MISHKA (ミシカ) EXFA1800 BLACK
37306 MISHKA(ミシカ) EXFA1801 WHITE
37308 MISHKA (ミシカ) EXFA1802 WHITE
37309 MISHKA (ミシカ) EXFA1802 BLACK
37310 MISHKA (ミシカ) EXFA1803 WHITE
37311 MISHKA (ミシカ) EXFA1803 BLACK
38818 MISHKA(ミシカ) CYCO KEEP WATCH T-SHIRT FL 171113 BLK
38819 MISHKA(ミシカ) CYCO KEEP WATCH T-SHIRT FL 171113 PNK
38821 MISHKA(ミシカ) LAMOUR HAND OF HELL T-SHIRT WHT
38822 MISHKA(ミシカ) CYRILLIC VARSITY T-SHIRT FL 171103 COFFEE
38823 MISHKA(ミシカ) LAMOUR VENOMOUS KEEP WATCH T-SHIRT FL171130 BLK
38824 MISHKA(ミシカ) LAMOUR VENOMOUS KEEP WATCH T-SHIRT FL171130 WHT
38825 MISHKA(ミシカ) LAMOUR VENOMOUS KEEP WATCH T-SHIRT FL171130 PNK
38826 MISHKA(ミシカ) LAMOUR CYCO COLLAGE TEE FL171133 BLK