create table Adressen (knr text, firma text, anrede text, titel text, vorname text, name text, strasse text, plz text, ort text, land text, banrede text, email text, telefon text)\n
<!-- wbc:begin write="1" table="watchlist as w left join users as b on b.uid=w.keyid left join properties as l on l.id=b.land left join properties as a on a.id=b.anrede" counton="w.keyid" select="b.*,l.kurzbez as landname,a.keyname as kanrede,a.kurzbez as banrede" where="w.typ='U' and w.uid={app.authuid}" order="b.plz" -->
insert into Adressen (knr, firma, anrede, titel, vorname, name, strasse, plz, ort, land, banrede, email, telefon) values ('{knr}','{firma}','{kanrede}','{titel}','{vorname}','{name}','{strasse}','{plz}','{ort}','{landname}','{banrede}','{email}','{telefon}')
<!-- wbc:begin table="properties" where="id>0" select="keyname" maxrows="1"  counter="{knr}" -->
<!-- wbc:end -->\n
<!-- wbc:end -->