0,548,545,219,955,254,359,343,831,252,613

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 (2 ) or kategorieid2 in (2) or kategorieid3 in (2) or kategorieid4 in (2) or kategorieid5 in (2) ) and a.hausid in (0,548,545,219,955,254,359,343,831,252,613,225,671,822,737,453,899,722,212,897,612,595,487,224,336,720,507,214,617,450)

a.hausid

FIELD (a.hausid,0,548,545,219,955,254,359,343,831,252,613,225,671,822,737,453,899,722,212,897,612,595,487,224,336,720,507,214,617,450)

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

10