SELECT SQL_CALC_FOUND_ROWS 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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =97
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-26 22:52:43')
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 p.update_date DESC
LIMIT 0, 120
61763 MISHKA (ミシカ) M21100054 L/S T-Shirt
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
58747 MISHKA NEW WORLD ORDER LONGSLEEVE WHITE
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
60720 MISHKA M61000010 L/S T-Shirt
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60295 MISHKA M61000014 L/S T-SHIRT
58572 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE PURPLE
58571 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE BLACK
58507 MISHKA OPTIC KEEP WATCH L/S L/S T-Shirt WHITE
58506 MISHKA OPTIC KEEP WATCH L/S L/S T-Shirt BLACK
57366 MISHKA M21000003 L/S T-Shirt
57365 MISHKA M21000001 L/S T-Shirt WHITE
57364 MISHKA M21000001 L/S T-Shirt BLACK
58124 MISHKA M21000061 L/S T-Shirt
57283 MISHKA GALACTIC GHOULS LS TEE WHITE
57284 MISHKA FLAMING KEEP WATCH LS TEE
57286 MISHKA 2 CHILL 4 DEATH LS TEE LIME
57287 MISHKA STACKED LS TEE BLACK
57288 MISHKA STACKED LS TEE LIME
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
55906 MISHKA MAW200002 L/S T-SHIRTS WHITE
55909 MISHKA MAW200003 L/S T-SHIRTS BLACK
55910 MISHKA MAW200003 L/S T-SHIRTS CHARCOAL GRAY
55905 MISHKA MAW200074 L/S T-SHIRTS ORANGE
55907 MISHKA MAW200002 L/S T-SHIRTS BLACK
55908 MISHKA MAW200002 L/S T-SHIRTS SAFTY GREEN
55904 MISHKA x Johnny Ryan DON'T LET THEM L/S T-SHIRTS BLUE
10807 MISHKA (ミシカ) CYCO PUSHER RAGLAN WHITE
14842 MISHKA (ミシカ) AUTOPSY DEATH LONGSLEEVE T-SHIRT
14908 MISHKA (ミシカ) RITUAL COLUMN LONGSLEEVE T-SHIRT
20347 MISHKA (ミシカ) KEEP WATCH L/S SHIRT (BLACK)
20448 MISHKA (ミシカ) ANDREI BOUZIKOV KEEP WATCH L/S SHIRT BLK
21726 MISHKA (ミシカ) SPENCER NUZZI: LUCK'S RUN OUT L/S SHIRT
21809 MISHKA (ミシカ) Yard Bird Longsleeve
21913 MISHKA (ミシカ) STATIC-AGE LONGSLEEVE TEE
21915 MISHKA (ミシカ) DEATH ADDER LONGSLEEVE TEE
21917 MISHKA (ミシカ) AWAY KEEP WATCH LONGSLEEVE TEE BLK
21918 MISHKA (ミシカ) AWAY KEEP WATCH LONGSLEEVE TEE WHT
21927 MISHKA (ミシカ) CYRILLIC LEGACY LONGSLEEVE TEE
23443 MISHKA (ミシカ) NATION OF MILLIONS L/S TEE Gold
23444 MISHKA (ミシカ) LAMOUR BOARD WALK L/S TEE Black
23445 MISHKA (ミシカ) LAMOUR BOARD WALK L/S TEE White
23867 MISHKA (ミシカ) SICK SAD KEEP WATCH L/S TIE DYE TEE Lime/Kelly Tie Dye
23873 MISHKA (ミシカ) HERITAGE KEEP WATCH L/S TEE WHITE
24194 MISHKA (ミシカ) METAL DEATH ADDER L/S TEE White
24977 MISHKA (ミシカ) LIGHT BULB EYEBALL L/S TEE White
24978 MISHKA (ミシカ) LIGHT BULB EYEBALL L/S TEE Black
28561 MISHKA (ミシカ) MAW160004M L/S BLACK
28562 MISHKA (ミシカ) MAW160004M L/S WHITE
28985 MISHKA(ミシカ) MAW160012 WHITE
28986 MISHKA(ミシカ) MAW160012 BLACK
29758 MISHKA FANZINE KEEP WATCH LONG SLEEVE TEE BLK
29760 MISHKA FANZINE KEEP WATCH LONG SLEEVE TEE WHT
29776 MISHKA DEATH ADDER SPORT LONG SLEEVE TEE BLK
29788 MISHKA STAR SPANGLED KEEP WATCH BOX LOGO LONG SLEEVE TEE WHT
29789 MISHKA STAR SPANGLED KEEP WATCH BOX LOGO LONG SLEEVE TEE BLK
29803 MISHKA HAZELIP KEEP WATCH LONG SLEEVE TEE BLK
30009 MISHKA (ミシカ) MELTDOWN L/S SHIRT CELADON
30010 MISHKA (ミシカ) MELTDOWN L/S SHIRT BLACK
30011 MISHKA (ミシカ) LAMOUR SUPREME: MISLED YOUTH L/S SHIRT SLATE
30012 MISHKA (ミシカ) LAMOUR SUPREME: MISLED YOUTH L/S SHIRT WHITE
33646 MISHKA (ミシカ) Keep Watch Longsleeve Black
33647 MISHKA (ミシカ) Keep Watch Longsleeve Cream
33658 MISHKA (ミシカ) ICE CREAM LONGSLEEVE TEE BLK
33659 MISHKA (ミシカ) ICE CREAM LONGSLEEVE TEE WHT
33663 MISHKA (ミシカ) LAMOUR K.W LONGSLEEVE TEE WHT
33666 MISHKA (ミシカ) Do Unto Others Longsleeves
33667 MISHKA (ミシカ) Stiletto Longsleeves Black
33668 MISHKA (ミシカ) Stiletto Longsleeves Pink
33669 MISHKA (ミシカ) Police State Longsleeves Black
33674 MISHKA (ミシカ) Spectator Longsleeves
33675 MISHKA (ミシカ) Heart of ColdSteel Longsleeves
34047 MISHKA (ミシカ) EXSP1709OL (L/S T) LONGSLEEVE TEE BLACK
35068 MISHKA (ミシカ) EXSP1726 WHITE
35069 MISHKA (ミシカ) EXSP1726 BLACK
35070 MISHKA (ミシカ) EXSP1726 PINK
35071 MISHKA (ミシカ) EXSP1725 WHITE
35072 MISHKA (ミシカ) EXSP1725 BLACK
35073 MISHKA (ミシカ) EXSP1725 ORANGE
37079 MISHKA(ミシカ) MAW170420 BLACK
37081 MISHKA(ミシカ) MAW170407 BLACK
37082 MISHKA(ミシカ) MAW170416
37503 MISHKA(ミシカ) EXSP1726B WHITE
37504 MISHKA(ミシカ) EXSP1726B BLACK
38795 MISHKA(ミシカ) NEIGHBORHOOD KEEP WATCH L/S TEE (BLACK/FL171105LSBLK)
38796 MISHKA(ミシカ) NEIGHBORHOOD KEEP WATCH L/S TEE (WHITE/FL171105LSWHT)
38797 MISHKA(ミシカ) MISHKA TV L/S TEE (BLACK/FL171106LSBLK)
38798 MISHKA(ミシカ) MISHKA TV L/S TEE (WHITE/FL171106LSWHT)
38799 MISHKA(ミシカ) ENTANGLED KEEP WATCH L/S TEE (BLACK/FL171104LSBLK)
38800 MISHKA(ミシカ) ENTANGLED KEEP WATCH L/S TEE (WHITE/FL171104LSWHT)
38801 MISHKA(ミシカ) ENTANGLED KEEP WATCH L/S TEE (BLACK/FL171104LSWHT)
38802 MISHKA(ミシカ) LAMOUR ON SIGHT L/S TEE (CHARCOAL/FL171120LSCHR)
38803 MISHKA(ミシカ) LAMOUR ON SIGHT L/S TEE (WHITE/FL171120LSWHT)
38816 MISHKA(ミシカ) DEATH ADDER L/S TEE (BLACK/FL171102LSBLK)
38817 MISHKA(ミシカ) DEATH ADDER L/S TEE (WHITE/FL171102LSWHT)
39321 MISHKA (ミシカ) MAW170438 L/S TEE
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
40652 MISHKA SP181305LS APOCALYPSE NOW LS TEE BLACK
40672 MISHKA SP181313LS DEEP SPACE 78MM LS TEE BLACK
41816 MISHKA (ミシカ) MAW180002 L/S TEE Black
44060 MISHKA (ミシカ) FW181302LS LAMOUR MISHKA THE MARTIAN L/S TEE BLACK
44061 MISHKA (ミシカ) FW181304LS BELIEVE 'N MISHKA L/S TEE BLACK
44065 MISHKA (ミシカ) FW181306LS MISHKA DEATH FIEND L/S TEE BLACK
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
45640 MISHKA MSS190445M99 CREW
45643 MISHKA MSS190021F00 T-SHIRT
45680 MISHKA x MISFITS Halloween L/S Tee BLACK
45683 MISHKA x MISFITS Halloween L/S Tee WHITE
47033 MISHKA SP191013LS L/T P.BLUE
47454 MISHKA SP191004LS WHITE
49664 MISHKA MAW190034 L/S TEE BLACK
49665 MISHKA MAW190034 L/S TEE WHITE
49769 MISHKA MAW190037 L/S TEE GREEN
49770 MISHKA MAW190037 L/S TEE BLACK
49771 MISHKA MAW190037 L/S TEE ORANGE
49772 MISHKA MAW190037 L/S TEE WHITE
51501 MISHKA MSS200057F99 L/S TEE BLACK