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:10:46')
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, 60
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
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
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