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-05-17 20:59:36')
AND FIND_IN_SET(1, 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 MAX(price02)
LIMIT 0, 60
54658 MISHKA(ミシカ) MSS203305 SOCKS BLACK
55931 MISHKA MAW203353 SOCKS BLACK
55932 MISHKA MAW203354 SOCKS BLACK
55933 MISHKA MAW203355 SOCKS BLACK
57369 MISHKA M21003354 SOCKS BLACK
60292 MISHKA M61000007 T-SHIRT BLACK
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
58573 MISHKA(ミシカ) M21000005 T-Shirt
60171 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE BLACK
61816 MISHKA (ミシカ) M21100053 T-SHIRT BLACK
56891 MISHKA(ミシカ) TAPE SET
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
55983 MISHKA(ミシカ) 89534 LANYARD
58629 MISHKA SPOOKY CREW TEE BLACK
60268 MISHKA M61000056 T-SHIRT BLACK
57364 MISHKA M21000001 L/S T-Shirt BLACK
54450 MISHKA(ミシカ) MSS200839 SHORTS
60271 MISHKA M61000053 T-SHIRT BLACK
64930 MISHKA (ミシカ) M21100064 T-SHIRT BLACK
64928 MISHKA (ミシカ) M21100061 T-SHIRT BLACK
58626 MISHKA OPTIC KEEP WATCH TEE BLACK
60166 MISHKA X DENNIS THE MENACE TROUBLE MAKER SHORTS
57358 MISHKA M21000013 T-Shirt BLACK
60291 MISHKA M61000907W PANT
55929 MISHKA MAW203224 BEANIE
60664 MISHKAM M61000413 CREW
60726 MISHKA M61000452 HOODIE
60729 MISHKA M61000841 PANTS
68289 MISHKA (ミシカ) PINK LEOPARD KEEP WATCH TRUCKER CAP
68403 MISHKA (ミシカ) DEEP DRIP KEEP WATCH TRUCKER CAP
60560 MISHKA M61000251 CHECK SHIRT
60721 MISHKA M61000417 HOODIE BLACK
54449 MISHKA(ミシカ) MSS200873 SHORTS
55981 MISHKA(ミシカ) 88318 CHARGER
55982 MISHKA(ミシカ) 91344 LED LAMP
58745 MISHKA NEW WORLD ORDER TEE BLACK
68056 MISHKA (ミシカ) INFINITE PAIN TEE (BLACK/MIDT-01BLK)
68058 MISHKA (ミシカ) CREAMY TEE (BLACK/MIJT-01BLK)
58108 MISHKA M21000251 SHIRT
50246 MISHKA MAW193206 CAP
50247 MISHKA MAW193236 CAP
53869 MISHKA(ミシカ) MSS200069 T-SHIRTS BLACK
53871 MISHKA(ミシカ) MSS200085 T-SHIRTS BLACK
53872 MISHKA(ミシカ) MSS200086 T-SHIRTS
54199 MISHKA MSS200029M80 T-SHIRTS BLACK
54663 MISHKA(ミシカ) MSS203210 CAP
54665 MISHKA(ミシカ) MSS203224 BUCKET HAT
54668 MISHKA(ミシカ) MSS203209 CAP
58129 MISHKA M21000007 T-Shirt Black
58578 MISHKA(ミシカ) M21000072 T-Shirt BLACK
63100 MISHKA (ミシカ) M21100009 T-SHIRT BLACK
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
60556 MISHKA M61000519 JACKET BLACK
54454 MISHKA(ミシカ) MSS200076 T-SHIRTS Black
54664 MISHKA(ミシカ) MSS203225 BUCKET HAT
54707 MISHKA (ミシカ) KUMARA TEE
54708 MISHKA (ミシカ) BUTIGER TEE
56889 MISHKA(ミシカ) FRKO x Mishka "Pop! Pop! Pop!" Hoodie BLACK
57284 MISHKA FLAMING KEEP WATCH LS TEE
57285 MISHKA 2 CHILL 4 DEATH LS TEE BLACK