SET @n=0;SET @f=0;
SELECT * FROM (
SELECT title,@n:=IF(@f=categoryid,@n:=@n+1,1) AS id,@f:=categoryid AS categoryid FROM hpm_news
) a WHERE id <10;
SELECT * FROM (
SELECT title,@n:=IF(@f=categoryid,@n:=@n+1,1) AS id,@f:=categoryid AS categoryid FROM hpm_news
) a WHERE id <10;