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 (
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-30 20:52:48')
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 MAX(price02)
LIMIT 0, 120
55904 MISHKA x Johnny Ryan DON'T LET THEM L/S T-SHIRTS BLUE
58572 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE PURPLE
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
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
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
34047 MISHKA (ミシカ) EXSP1709OL (L/S T) LONGSLEEVE TEE BLACK
55908 MISHKA MAW200002 L/S T-SHIRTS SAFTY GREEN
57364 MISHKA M21000001 L/S T-Shirt BLACK
33658 MISHKA (ミシカ) ICE CREAM LONGSLEEVE TEE BLK
33659 MISHKA (ミシカ) ICE CREAM LONGSLEEVE TEE WHT
33663 MISHKA (ミシカ) LAMOUR K.W LONGSLEEVE TEE WHT
21726 MISHKA (ミシカ) SPENCER NUZZI: LUCK'S RUN OUT L/S SHIRT
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
33666 MISHKA (ミシカ) Do Unto Others Longsleeves
33667 MISHKA (ミシカ) Stiletto Longsleeves Black
33669 MISHKA (ミシカ) Police State Longsleeves Black
33674 MISHKA (ミシカ) Spectator Longsleeves
35068 MISHKA (ミシカ) EXSP1726 WHITE
35069 MISHKA (ミシカ) EXSP1726 BLACK
35070 MISHKA (ミシカ) EXSP1726 PINK
35071 MISHKA (ミシカ) EXSP1725 WHITE
35072 MISHKA (ミシカ) EXSP1725 BLACK
35073 MISHKA (ミシカ) EXSP1725 ORANGE
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)
40652 MISHKA SP181305LS APOCALYPSE NOW LS TEE BLACK
40672 MISHKA SP181313LS DEEP SPACE 78MM LS 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
47028 MISHKA SP191007LS L/T ROYAL
47454 MISHKA SP191004LS WHITE
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
14842 MISHKA (ミシカ) AUTOPSY DEATH LONGSLEEVE T-SHIRT
14908 MISHKA (ミシカ) RITUAL COLUMN LONGSLEEVE T-SHIRT
21809 MISHKA (ミシカ) Yard Bird Longsleeve
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
23873 MISHKA (ミシカ) HERITAGE KEEP WATCH L/S TEE WHITE
24194 MISHKA (ミシカ) METAL DEATH ADDER L/S TEE White
28561 MISHKA (ミシカ) MAW160004M L/S BLACK
28562 MISHKA (ミシカ) MAW160004M L/S WHITE
28985 MISHKA(ミシカ) MAW160012 WHITE
28986 MISHKA(ミシカ) MAW160012 BLACK
20347 MISHKA (ミシカ) KEEP WATCH L/S SHIRT (BLACK)
20448 MISHKA (ミシカ) ANDREI BOUZIKOV KEEP WATCH L/S SHIRT BLK
24977 MISHKA (ミシカ) LIGHT BULB EYEBALL L/S TEE White
24978 MISHKA (ミシカ) LIGHT BULB EYEBALL L/S TEE Black
45680 MISHKA x MISFITS Halloween L/S Tee BLACK
45683 MISHKA x MISFITS Halloween L/S Tee WHITE
41816 MISHKA (ミシカ) MAW180002 L/S TEE Black
49664 MISHKA MAW190034 L/S TEE BLACK
49665 MISHKA MAW190034 L/S TEE WHITE
23867 MISHKA (ミシカ) SICK SAD KEEP WATCH L/S TIE DYE TEE Lime/Kelly Tie Dye
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
39321 MISHKA (ミシカ) MAW170438 L/S TEE
57365 MISHKA M21000001 L/S T-Shirt WHITE
37081 MISHKA(ミシカ) MAW170407 BLACK
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
10807 MISHKA (ミシカ) CYCO PUSHER RAGLAN WHITE
33647 MISHKA (ミシカ) Keep Watch Longsleeve Cream
33668 MISHKA (ミシカ) Stiletto Longsleeves Pink
33675 MISHKA (ミシカ) Heart of ColdSteel Longsleeves
37079 MISHKA(ミシカ) MAW170420 BLACK
47033 MISHKA SP191013LS L/T P.BLUE
51554 MISHKA FM191014LS L/T BLACK
51556 MISHKA FM191014LS L/T WHITE
52678 MISHKA Universal Guide Longsleeve Black
52679 MISHKA Universal Guide Longsleeve White
52680 MISHKA Incoming Transmission Longsleeve Black
52681 MISHKA Incoming Transmission Longsleeve White
52682 MISHKA Incoming Transmission Longsleeve Carolina Blue
52683 MISHKA Crack the Crust Longsleeve Black
52684 MISHKA Crack the Crust Longsleeve Safety Green
57283 MISHKA GALACTIC GHOULS LS TEE WHITE
57284 MISHKA FLAMING KEEP WATCH LS TEE
57285 MISHKA 2 CHILL 4 DEATH LS TEE BLACK
57286 MISHKA 2 CHILL 4 DEATH LS TEE LIME
57287 MISHKA STACKED LS TEE BLACK
57288 MISHKA STACKED LS TEE LIME
58506 MISHKA OPTIC KEEP WATCH L/S L/S T-Shirt BLACK
58507 MISHKA OPTIC KEEP WATCH L/S L/S T-Shirt WHITE
58571 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE BLACK
58747 MISHKA NEW WORLD ORDER LONGSLEEVE WHITE
37082 MISHKA(ミシカ) MAW170416
45640 MISHKA MSS190445M99 CREW
52433 MISHKA TARA-12 Long T-Shirt Black
52613 MISHKA MSS200036M21 L/S TEE BLACK
52615 MISHKA MSS200036M21 L/S TEE PURPLE