0,738,763,775,261,848,825,356,546

a.*,c.bezeichnung as bezirkname,b.name as ortname

haus a left join ort b on a.ortid=b.id left join ortsteil c on a.ortsteilid=c.ortsteilid left join hauseigenschaft v on a.hausid=v.hausid

a.sperre=0 and a.status=0 and a.ortid in (65) and ( kategorieid in (3 ) or kategorieid2 in (3) or kategorieid3 in (3) or kategorieid4 in (3) or kategorieid5 in (3) ) and a.hausid in (0,209,897,367,744,741,249,713,654,219,236,2044,453,736,792,612,617,779,739,726,336,369,656,732,661,731,254,780,720,793,749,738,763,775,261,848,825,356,546)

a.hausid

FIELD (a.hausid,0,209,897,367,744,741,249,713,654,219,236,2044,453,736,792,612,617,779,739,726,336,369,656,732,661,731,254,780,720,793,749,738,763,775,261,848,825,356,546)

771,777,E-Mail,Ab-Preis / Nacht,Tel ,in,Buchen,Anfrage,0,de,Details,767,768,,

10