select @i := @i + 1 AS row_number, z1.*
from 
	(
	SELECT *
	FROM table 
	) z1, (select @i:=-1) z2