mysql 取出每天发文章最多的2个用户

SELECT LEFT(addtime,10) as date, writer, count(writer) as writer_count FROM archives
GROUP BY date,writer ORDER BY date DESC, writer_count DESC

SET @num = 0;
SET @date = ‘‘;
SELECT *, @num := if(@date=date, @num := @num+1, 1) as row_num, @date := date as ‘@date‘ FROM
    ( SELECT LEFT(addtime,10) as date, writer, count(writer) as writer_count FROM archives
      GROUP BY date,writer ORDER BY date DESC, writer_count DESC
    ) as archives_count

SET @num = 0;
SET @date = ‘‘;
SELECT * FROM 
    ( SELECT *, @num := if(@date=date, @num := @num+1, 1) as row_num, @date := date as ‘@date‘ FROM
            ( SELECT LEFT(addtime,10) as date, writer, count(writer) as writer_count FROM archives
              GROUP BY date,writer ORDER BY date DESC, writer_count DESC
            ) as archives_count
    ) as archives_count_row_num
WHERE row_num<=2