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-04 16:33:52')
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, 75
54657 MISHKA(ミシカ) MSS203305 SOCKS WHITE
54658 MISHKA(ミシカ) MSS203305 SOCKS BLACK
54659 MISHKA(ミシカ) MSS203304 SOCKS WHITE
54660 MISHKA(ミシカ) MSS203304 SOCKS YELLOW
54661 MISHKA(ミシカ) MSS203301 SOCKS YELLOW
54662 MISHKA(ミシカ) MSS203301 SOCKS GREEN
55930 MISHKA MAW203353 SOCKS SAFTY GREEN
55931 MISHKA MAW203353 SOCKS BLACK
55932 MISHKA MAW203354 SOCKS BLACK
55933 MISHKA MAW203355 SOCKS BLACK
57369 MISHKA M21003354 SOCKS BLACK
57370 MISHKA M21003354 SOCKS GREEN
57371 MISHKA M21003354 SOCKS PURPLE
57372 MISHKA M21003353 SOCKS BLUE
57373 MISHKA M21003353 SOCKS RED
58624 MISHKA OPTIC KEEP WATCH TEE WHITE
58627 MISHKA SPOOKY CREW TEE WHITE
58628 MISHKA SPOOKY CREW TEE PINK
53870 MISHKA(ミシカ) MSS200085 T-SHIRTS WHITE
54452 MISHKA(ミシカ) MSS200031 T-SHIRTS Safety Green
60292 MISHKA M61000007 T-SHIRT BLACK
55901 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS WHITE
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
58573 MISHKA(ミシカ) M21000005 T-Shirt
60171 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE BLACK
60172 MISHKA X DENNIS THE MENACE DENNIS TEE WHITE
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
55908 MISHKA MAW200002 L/S T-SHIRTS SAFTY GREEN
57364 MISHKA M21000001 L/S T-Shirt BLACK
54198 MISHKA MSS200029M80 T-SHIRTS WHITE
57359 MISHKA M21000013 T-Shirt WHITE
60293 MISHKA M61000007 T-SHIRT PURPLE
63078 MISHKA (ミシカ) M21100025 T-SHIRT WHITE
54450 MISHKA(ミシカ) MSS200839 SHORTS
54455 MISHKA(ミシカ) MSS200076 T-SHIRTS Purple
55900 MISHKA x Johnny Ryan SAVE THE WORLD S/S T-SHIRTS BLACK
55902 MISHKA x Johnny Ryan WILLY WASHUMS S/S T-SHIRTS
55912 MISHKA MAW200004 T-SHIRTS BEIGE
58132 MISHKA M21000066 T-Shirt White
60271 MISHKA M61000053 T-SHIRT BLACK
60272 MISHKA M61000053 T-SHIRT BLUE
64930 MISHKA (ミシカ) M21100064 T-SHIRT BLACK
54196 MISHKA MSS200033F80 T-SHIRTS WHITE
63076 MISHKA (ミシカ) M21100039 T-SHIRT WHITE
64928 MISHKA (ミシカ) M21100061 T-SHIRT BLACK
65670 MISHKA (ミシカ) M61100008 "KEEP WATCH"Tee WHITE
58126 MISHKA M21000006 T-Shirt Beige
58626 MISHKA OPTIC KEEP WATCH TEE BLACK
58820 MISHKA(ミシカ) M21000012 T-SHIRTS WHITE
60269 MISHKA M61000056 T-SHIRT PURPLE
60270 MISHKA M61000056 T-SHIRT WHITE
56877 MISHKA(ミシカ) MAW200470 HOODIE ORANGE
60166 MISHKA X DENNIS THE MENACE TROUBLE MAKER SHORTS
57358 MISHKA M21000013 T-Shirt BLACK
58130 MISHKA M21000007 T-Shirt Green
60291 MISHKA M61000907W PANT
61759 MISHKA (ミシカ) M21100407 HOODIE
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
54699 MISHKA(ミシカ) MSS200030 T-SHIRTS ORANGE/PURPLE
55790 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 キャップ
55929 MISHKA MAW203224 BEANIE
57365 MISHKA M21000001 L/S T-Shirt WHITE
58575 MISHKA(ミシカ) M21000067 T-Shirt GREEN
58576 MISHKA(ミシカ) M21000067 T-Shirt PURPLE
60664 MISHKAM M61000413 CREW
60726 MISHKA M61000452 HOODIE
60729 MISHKA M61000841 PANTS
61778 MISHKA (ミシカ) M21100352 KNIT