create view cat1_view as (SELECT distinct categorylev1,
       @rownum := @rownum + 1 AS id
  FROM topic t,
       (SELECT @rownum := 0) r
group by categorylev1)