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 05:07:05')
AND FIND_IN_SET(3, 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
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
68408 MISHKA (ミシカ) WASHED BEAR MOP TEE (O.WHITE/M21200006WHT)
68405 MISHKA (ミシカ) COLLAGE ARTWORK TEE (O.WHITE/M21200051WHT)
68220 MISHKA (ミシカ) CROWN TEDDY BEAR TEE M21200014 WHITE
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
61754 MISHKA (ミシカ) M21100602 JACKET
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
58137 MISHKA M21003251 Cap White
58142 MISHKA M21003101 Bag
57367 MISHKA M21000205 S/S Shirt
57283 MISHKA GALACTIC GHOULS LS TEE WHITE
56883 MISHKA(ミシカ) MAW203117 WHITE
56881 MISHKA(ミシカ) MAW200770 JACKET WHITE
55906 MISHKA MAW200002 L/S T-SHIRTS WHITE
56884 MISHKA(ミシカ) MAW203118 WHITE
55914 MISHKA MAW200423 SWEAT WHITE
55916 MISHKA MAW200401 HOODIE WHITE
55918 MISHKA MAW200214 SHIRTS
55911 MISHKA MAW200004 T-SHIRTS WHITE
55982 MISHKA(ミシカ) 91344 LED LAMP
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
17532 MISHKA (ミシカ) ETERNAL KEEP WATCH NEW ERA 5950
20614 MISHKA (ミシカ) BLOOD SPORT BUTTON UP
21743 MISHKA (ミシカ) OLDE SCHOOL NEW ERA 1920 STRAPBACK WHT
21838 MISHKA (ミシカ) MIGHTY HEALTHY: KEEP WATCH T-SHIRT
21840 MISHKA (ミシカ) MIGHTY HEALTHY: WARHEAD RAGLAN
22054 MISHKA (ミシカ) KEEP WATCH PATTERN SOCKS WHITE
24194 MISHKA (ミシカ) METAL DEATH ADDER L/S TEE White
24970 MISHKA (ミシカ) MASK KEEP WATCH TEE White
25216 MISHKA (ミシカ) KEEP WATCH TOY
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
26567 MISHKA x FAMOUS STARS AND STRAPS SNAPBACK WHITE
26569 MISHKA (ミシカ) CREEP SNAPBACK
26573 MISHKA (ミシカ) KEEP WATCH CAP
26577 MISHKA (ミシカ) DAMAGED KEEP WATCH SNAPBACK White
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
28094 MISHKA RING OF HELL KEEP WATCH STICKER
28095 MISHKA RETRO KEEP WATCH STICKER
28096 MISHKA CLASSIC KEEP WATCH STICKER
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