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