0111nobodyさん2006/03/14(火) 20:25:15ID:??? 奈良、88でできるんじゃね? SELECT user_id, SUBSTRING(MAX(CONCAT(time,profile),9) AS profile, SUBSTRING(MAX(CONCAT(time,uname),9) AS uname, MAX(time) AS time, COUNT(*) AS cnt FROM users WHERE win_lose = 'w' GROUP BY user_id