MariaDB: RowNumber in Select

SELECT @ROW := @ROW +1 AS Nummer, fg.web_text
FROM (SELECT @ROW :=0) n
JOIN avd_def_fg fg;