0,1853,267,238,826,766,424,218,362,318,923

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 (7 ) or kategorieid2 in (7) or kategorieid3 in (7) or kategorieid4 in (7) or kategorieid5 in (7) ) and a.hausid in (0,1853,267,238,826,766,424,218,362,318,923,823,864,792,739,444,440,790,363,867,612,874,373,441,1019,617,1201,233,720,945,249,261,724,221,778,787,1192,228,861,245,860,772,793,346,786,456,714,741,784,1822,242,481,747,780,213,463,882,756,622,749,716,210,713,1828,651,370,725,451,744,654,834,762,1831,499,506,764,862,390,262,455,244,237,452,428,208,759,763,431,581,1343,652,240,511,355,844,848,217,340,219,655,480,333,243,358,722,309,336,420,239,231,731,777,827,779,268,524,796,774,879,757,255,514,236,539,342,348,775,939,542,619,732,673,460,847,865,380,761,546,881,438,767,878,377,588,845,820,584,768,645,235)

a.hausid

FIELD (a.hausid,0,1853,267,238,826,766,424,218,362,318,923,823,864,792,739,444,440,790,363,867,612,874,373,441,1019,617,1201,233,720,945,249,261,724,221,778,787,1192,228,861,245,860,772,793,346,786,456,714,741,784,1822,242,481,747,780,213,463,882,756,622,749,716,210,713,1828,651,370,725,451,744,654,834,762,1831,499,506,764,862,390,262,455,244,237,452,428,208,759,763,431,581,1343,652,240,511,355,844,848,217,340,219,655,480,333,243,358,722,309,336,420,239,231,731,777,827,779,268,524,796,774,879,757,255,514,236,539,342,348,775,939,542,619,732,673,460,847,865,380,761,546,881,438,767,878,377,588,845,820,584,768,645,235)

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

10