SELECT b.id, tab, name, name2,bildname, zweifel,filter,plz,ort,a.art,lkcode,z.zustand from burgen b, art a, zustand z where b.art = a.id and b.zustand = z.id and lkcode = 'HERF' order by name limit 500