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 18:39:41')
AND pc.price02 > 909
AND price02 <= 2727
AND FIND_IN_SET(1, p.color)
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
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
58573 MISHKA(ミシカ) M21000005 T-Shirt
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
60268 MISHKA M61000056 T-SHIRT BLACK
58629 MISHKA SPOOKY CREW TEE BLACK
57364 MISHKA M21000001 L/S T-Shirt BLACK
57369 MISHKA M21003354 SOCKS BLACK
55931 MISHKA MAW203353 SOCKS BLACK
55933 MISHKA MAW203355 SOCKS BLACK
56891 MISHKA(ミシカ) TAPE SET
55932 MISHKA MAW203354 SOCKS BLACK
55983 MISHKA(ミシカ) 89534 LANYARD
10602 MISHKA (ミシカ) JUNIOR ADDER BEANIE BLACK
13306 MISHKA (ミシカ) LAMOUR KEEP WATCH POM BEANIE BLACK
13481 MISHKA (ミシカ) LAMOUR KEEP WATCH RUMBLE POM BEANIE
14769 MISHKA (ミシカ) KEEP WATCH LEGGINGS MULTI
14775 MISHKA (ミシカ) BOOTLEG HORNS SNAPBACK BLACK
20031 MISHKA (ミシカ) PIZZA KEEP WATCH TANK BLACK
20297 MISHKA (ミシカ) STREET TRASH T-SHIRT BLACK
20315 MISHKA (ミシカ) ATOMIC KEEP WATCH T-SHIRT BLACK
20324 MISHKA (ミシカ) KEEP WATCH T-SHIRT BLK/GRN
20348 MISHKA (ミシカ) CYCO HALF LIFE T-SHIRT (BLACK)
20449 MISHKA (ミシカ) CYCO MANIA T-SHIRT BLACK
20450 MISHKA (ミシカ) ANDREI BOUZIKOV KEEP WATCH T-SHIRT BLK
20492 MISHKA (ミシカ) BIO-CREST T-SHIRT BLACK
20497 MISHKA (ミシカ) DEATH COBRA T-SHIRT BLACK
20499 MISHKA (ミシカ) CYCO MANIA SNAPBACK BLACK/WHITE
21728 MISHKA (ミシカ) SPENCER NUZZI: LUCK'S RUN OUT T-SHIRT
21912 MISHKA (ミシカ) SPLIT ICONS TEE
21916 MISHKA (ミシカ) WORLDWIDE DEATH ADDERS INC. TEE
21920 MISHKA (ミシカ) MONOCHROME KEEP WATCH TEE BLK
21925 MISHKA (ミシカ) REFLECTIVE KEEP WATCH TEE
21926 MISHKA (ミシカ) EXPLORER KEEP WATCH TEE
22059 MISHKA (ミシカ) KEEP WATCH SNAPBACK
23868 MISHKA (ミシカ) LAMOUR KILL WITH POWER GID TEE BLACK
24191 MISHKA (ミシカ) MISHKA (ミシカ) KEEP WATCH CAMO BOX LOGO TEE Black
25318 MISHKA (ミシカ) LAMOUR RING OF HELL KW TEE BLACK
25320 MISHKA (ミシカ) CYRILLIC KEEP WATCH TEE BLACK
25322 MISHKA (ミシカ) CLASSIC KEEP WATCH TEE BLACK
25324 MISHKA (ミシカ) COOKIE KEEP WATCH TEE BLACK
25326 MISHKA (ミシカ) SMILEY KEEP WATCH TEE BLACK
25328 MISHKA (ミシカ) CAMO KEEP WATCH TEE BLACK
26556 MISHKA (ミシカ) CARTOON ADDER TEE
26557 MISHKA (ミシカ) DEMONS TEE Black
26559 MISHKA (ミシカ) TONAL NEIGHBORHHOOD SNIPER TEE Black
26565 MISHKA x FAMOUS STARS AND STRAPS ALL SEEING SNAPBACK
26576 MISHKA (ミシカ) DAMAGED KEEP WATCH SNAPBACK Black
26578 MISHKA (ミシカ) KEEP WATCH SNAPBACK
26579 MISHKA (ミシカ) CARTOON ADDER SNAPBACK
27456 MISHKA (ミシカ) ATTITUDE ADJUSTER TEE
27462 MISHKA (ミシカ) EXPLODING KEEP WATCH TANK Black
27467 MISHKA (ミシカ) BLAZER KEEP WATCH TEE
27468 MISHKA (ミシカ) DAMAGED KEEP WATCH TEE Black
27472 MISHKA (ミシカ) LAMOUR DEATH ADDER TEE
27475 MISHKA (ミシカ) WE GET OURS TEE
27834 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE BLK
27836 FAMOUS STARS AND STRAPS x MISHKA MERCY TEE BLK
28185 MISHKA (ミシカ) SOFT CREAM TEE BLACK
28186 MISHKA (ミシカ) WATERMALON TEE BLACK
28187 MISHKA (ミシカ) ICE TEE BLACK
29764 MISHKA LAMOUR CYCO HANDPLANT TEE BLK
29767 MISHKA LAMOUR CYCO RIPPER TEE BLK
29772 MISHKA HAZELIP KEEP WATCH TEE BLK
29784 MISHKA MUSE KEEP WATCH TEE BLK
29795 MISHKA LOCALS KEEP WATCH BOX LOGO TEE BLK
29800 MISHKA MISLED YOUTH TEE BLK
29805 MISHKA LAMOUR BOTLEG ANATOMY TEE BLK
29806 MISHKA LAMOUR SPLIT ICONS TEE BLK
29807 MISHKA x BAKER RITUAL TEE BLK
29818 MISHKA KEEP WATCH SUPPLY LOGO TEE S/S TEE
29958 MISHKA (ミシカ) AIR JAM 2016 x MISHKA TEE BLACK
30000 MISHKA (ミシカ) SMART PHONE CASE COLLAGE
30001 MISHKA (ミシカ) SMART PHONE CASE GALAXY
30106 MISHKA (ミシカ) KEYHOLE KEEP WATCH T-SHIRT
32087 MISHKA (ミシカ) EXPP162001D DADHAT
32088 MISHKA (ミシカ) EXPP162001C DADHAT
33628 MISHKA (ミシカ) Hyper Real Keep Watch Ash Black
33633 MISHKA (ミシカ) Chained Death Adder Black
33637 MISHKA (ミシカ) ICE CREAM TEE BLK
33649 MISHKA (ミシカ) Strong Bodies Black
33676 MISHKA (ミシカ) Gotta Have Job Black
34038 MISHKA (ミシカ) EXSP1701OL TEE BLACK
34039 MISHKA (ミシカ) EXSP1702OL TEE BLACK
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
34052 MISHKA (ミシカ) EXSP1713OL TEE BLACK
34057 MISHKA (ミシカ) MELTDOWN KEEP WATCH BLACK
34217 MISHKA Fanzine Keep Watch Snapback BLK
34223 MISHKA BlackSheep Cap BLK
34225 MISHKA Hyper Real Keep Watch Snapback
34232 MISHKA Strong Bodies Dad Hat BLK
34233 MISHKA Lamour Keep Watch Snapback BLK
34234 MISHKA No Mercy Snapback BLK
34306 MISHKA (ミシカ) MSS173203 KEEP WATCH STRAPBACK
34307 MISHKA (ミシカ) MSS173204 KEEP WATCH STRAPBACK
34413 MISHKA (ミシカ) MISHKA (ミシカ) EXSP1703OL TEE BLACK
35057 MISHKA (ミシカ) EXSP1723 BLACK
35261 MISHKA (ミシカ) MSS170053 BLACK
35265 MISHKA (ミシカ) MSS170052 BLACK
35624 MISHKA (ミシカ) EXSP1728 KEEP WATCH SNAPBACK GREEN
35625 MISHKA (ミシカ) SM171706 KEEP WATCH SNAPBACK
35626 MISHKA (ミシカ) SM171707 SNAPBACK
35627 MISHKA (ミシカ) SM171707B STRAPBACK
35631 MISHKA (ミシカ) SM171710 SNAPBACK BLACK
35636 MISHKA (ミシカ) EXSP1728 KEEP WATCH SNAPBACK PURPLE
36073 MISHKA Scum Black
36075 MISHKA Adored BLACK
36078 MISHKA Teenage Suicide BLACK
36082 MISHKA Mike Sutfin: Tzar of Rock BLACK
36245 MISHKA (ミシカ) Chained Death Adder TEE BLACK
36247 MISHKA (ミシカ) Butterfly Keep Watch Tank Tops BLACK
36249 MISHKA (ミシカ) Butterfly Keep Watch TEE BLACK
36251 MISHKA (ミシカ) Chained Death Adder Tank Tops BLACK
36253 MISHKA (ミシカ) DAU TEE BLACK