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 01:29:58')
AND FIND_IN_SET(3, p.color)
AND pc.classcategory_id1 IN( 12,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 p.update_date DESC
LIMIT 0, 120
66453 MISHKA (ミシカ) M61100405 Double Strings Pullover Hoodie WHITE
69297 MISHKA (ミシカ) Embroidery Pullover Off White
65664 MISHKA (ミシカ) M61100404 WHITE“MOP”SWEAT
68219 MISHKA (ミシカ) K.W DAMAGED TEE M21200001 WHITE
68405 MISHKA (ミシカ) COLLAGE ARTWORK TEE (O.WHITE/M21200051WHT)
65670 MISHKA (ミシカ) M61100008 "KEEP WATCH"Tee WHITE
65673 MISHKA (ミシカ) M61100001 “MOP”GRAPHIC Tee WHITE
65675 MISHKA (ミシカ) M61100003 WHITE“MOP”Tee
64927 MISHKA (ミシカ) M21100061 T-SHIRT WHITE
63078 MISHKA (ミシカ) M21100025 T-SHIRT WHITE
68057 MISHKA (ミシカ) INFINITE PAIN TEE (WHITE/MIDT-01WHT)
68412 MISHKA (ミシカ) WASHEDKEEP WATCH TEE (O.WHITE/M21200007WHT)
61752 MISHKA (ミシカ) M21100651 JACKET
66445 MISHKA (ミシカ) M61100455 Monogram Mop Oversized Sweatshirt WHITE
65667 MISHKA (ミシカ) M61100415 BIGSILHOUETTE PARKA WHITE
61759 MISHKA (ミシカ) M21100407 HOODIE
63076 MISHKA (ミシカ) M21100039 T-SHIRT WHITE
63082 MISHKA (ミシカ) M21100201 SHIRT
61763 MISHKA (ミシカ) M21100054 L/S T-Shirt
60660 MISHKA M61000253 SHIRT L.BLUE
60172 MISHKA X DENNIS THE MENACE DENNIS TEE WHITE
58579 MISHKA(ミシカ) M21000204 S/S Shirt
58574 MISHKA(ミシカ) M21000029 T-Shirt
58132 MISHKA M21000066 T-Shirt White
58744 MISHKA NEW WORLD ORDER TEE WHITE
58747 MISHKA NEW WORLD ORDER LONGSLEEVE WHITE
58624 MISHKA OPTIC KEEP WATCH TEE WHITE
58627 MISHKA SPOOKY CREW TEE WHITE
61764 MISHKA (ミシカ) M21100011 T-SHIRT
64929 MISHKA (ミシカ) M21100064 T-SHIRT WHITE
61783 MISHKA (ミシカ) M21100032 T-SHIRT WHITE
61765 MISHKA (ミシカ) M21100001 T-SHIRT WHITE
61782 MISHKA (ミシカ) M21100412 CREW WHITE
61760 MISHKA (ミシカ) M21100401 CREW WHITE
61815 MISHKA (ミシカ) M21100053 T-SHIRT WHITE
60733 MISHKA M61000619 JACKET
60294 MISHKA M61000007 T-SHIRT WHITE
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
61262 MISHKA M61000623 JACKET WHITE
61035 MISHKA M61000730 JACKET WHITE
60270 MISHKA M61000056 T-SHIRT WHITE
60170 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE WHITE
60286 MISHKA M61000410 CREW WHITE
58820 MISHKA(ミシカ) M21000012 T-SHIRTS WHITE
58822 MISHKA(ミシカ) M21000014 T-SHIRTS WHITE
58575 MISHKA(ミシカ) M21000067 T-Shirt GREEN
58576 MISHKA(ミシカ) M21000067 T-Shirt PURPLE
58128 MISHKA M21000011 T-Shirt White
57359 MISHKA M21000013 T-Shirt WHITE
57357 MISHKA M21000030 T-Shirt WHITE
58507 MISHKA OPTIC KEEP WATCH L/S L/S T-Shirt WHITE
58109 MISHKA M21000404 Pullover WHITE
58113 MISHKA M21000414M WHITE
57365 MISHKA M21000001 L/S T-Shirt WHITE
57367 MISHKA M21000205 S/S Shirt
57283 MISHKA GALACTIC GHOULS LS TEE WHITE
56881 MISHKA(ミシカ) MAW200770 JACKET WHITE
55906 MISHKA MAW200002 L/S T-SHIRTS WHITE
55914 MISHKA MAW200423 SWEAT WHITE
55916 MISHKA MAW200401 HOODIE WHITE
55918 MISHKA MAW200214 SHIRTS
55911 MISHKA MAW200004 T-SHIRTS WHITE
54198 MISHKA MSS200029M80 T-SHIRTS WHITE
54196 MISHKA MSS200033F80 T-SHIRTS WHITE
6265 MISHKA (ミシカ) ANTIGONE BUTTON-UP WHITE
10608 MISHKA (ミシカ) HELLA STUFF PULLOVER WHITE
14772 MISHKA (ミシカ) 8-BIT KEEP WATCH T-SHIRT WHITE
15499 MISHKA (ミシカ) Autopsy Vex Crew Neck
20614 MISHKA (ミシカ) BLOOD SPORT BUTTON UP
21838 MISHKA (ミシカ) MIGHTY HEALTHY: KEEP WATCH T-SHIRT
21840 MISHKA (ミシカ) MIGHTY HEALTHY: WARHEAD RAGLAN
24194 MISHKA (ミシカ) METAL DEATH ADDER L/S TEE White
24970 MISHKA (ミシカ) MASK KEEP WATCH TEE White
25319 MISHKA (ミシカ) CYRILLIC KEEP WATCH TEE WHITE
25321 MISHKA (ミシカ) CLASSIC KEEP WATCH TEE WHITE
25323 MISHKA (ミシカ) COOKIE KEEP WATCH TEE WHITE
25325 MISHKA (ミシカ) SMILEY KEEP WATCH TEE WHITE
25327 MISHKA (ミシカ) CAMO KEEP WATCH TEE WHITE
25937 MISHKA (ミシカ) KEEP WATCH PATTERN DUNNY T-SHIRT
26558 MISHKA (ミシカ) DEMONS TEE White
26560 MISHKA (ミシカ) TONAL NEIGHBORHHOOD SNIPER TEE White
26566 MISHKA (ミシカ) DAMAGED KEEP WATCH TANK
27464 MISHKA (ミシカ) EXPLODING KEEP WATCH TANK White
27469 MISHKA (ミシカ) DAMAGED KEEP WATCH TEE White
27473 MISHKA (ミシカ) CLASSIC KEEP WATCH RINGER TEE
27480 MISHKA (ミシカ) MONOCHROME KEEP WATCH TEE
27489 MISHKA (ミシカ) KEEP WATCH BASEBALL JERSEY
27497 MISHKA (ミシカ) KEEP WATCH RINGER TEE
27835 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING F TEE WHT
27838 FAMOUS STARS AND STRAPS x MISHKA ALL SEEING HOODIE WHT
28559 MISHKA (ミシカ) MAW160503M JKT WHITE
28560 MISHKA (ミシカ) MAW160003M TEE WHITE
28562 MISHKA (ミシカ) MAW160004M L/S WHITE
28564 MISHKA (ミシカ) MAW160006M TEE WHITE
28985 MISHKA(ミシカ) MAW160012 WHITE
29760 MISHKA FANZINE KEEP WATCH LONG SLEEVE TEE WHT
29762 MISHKA LAMOUR CYCO HANDPLANT TEE WHT
29765 MISHKA LAMOUR CYCO RIPPER TEE WHT
29770 MISHKA HAZELIP KEEP WATCH TEE WHT
29779 MISHKA PRISONER OF LOVE TEE WHT
29788 MISHKA STAR SPANGLED KEEP WATCH BOX LOGO LONG SLEEVE TEE WHT
29799 MISHKA MISLED YOUTH TEE WHT
29804 MISHKA LAMOUR BOTLEG ANATOMY TEE WHT
29808 MISHKA EXTERMINATOR TEE WHT
29809 MISHKA DEAD END TEE WHT
29813 MISHKA GROTESQUE KEEP WATCH TEE WHT
29959 MISHKA (ミシカ) AIR JAM 2016 x MISHKA TEE WHITE
30005 MISHKA (ミシカ) LOCALS KEEP WATCH PULLOVER HOODIE WHITE
30006 MISHKA (ミシカ) WORLD PEACE PULLOVER HOODIE WHITE
30008 MISHKA (ミシカ) LAMOUR SUPREME: SPLIT ICONS PULLOVER HOODIE HEATHER
30012 MISHKA (ミシカ) LAMOUR SUPREME: MISLED YOUTH L/S SHIRT WHITE
30104 MISHKA (ミシカ) SOFT CREM KEEP WATCH HOODIE WHITE
30107 MISHKA (ミシカ) WORLD PEACE T-SHIRT WHITE
30108 MISHKA (ミシカ) EAD END CREWNECK WHITE
30110 MISHKA (ミシカ) Keep Watch Hocky Jersey
33609 MISHKA(ミシカ) No Mercy Pullover
33632 MISHKA (ミシカ) Chained Death Adder White
33634 MISHKA (ミシカ) Fanzine Keep Watch White
33636 MISHKA (ミシカ) Fanzine Keep Watch Cream
33638 MISHKA (ミシカ) ICE CREAM TEE WHT