select count(pid) as aaa from tbl_properties left join tbl_currencies on tbl_properties.currencyid=tbl_currencies.id left join tbl_room_types on tbl_properties.noofbedsid=tbl_room_types.roomtypeid left join tbl_properties_countries_regions on tbl_properties.regionid=tbl_properties_countries_regions.regionid left join tbl_properties_countries on tbl_properties.countryid=tbl_properties_countries.countryid left join tbl_properties_countries_regions_cities on tbl_properties.city=tbl_properties_countries_regions_cities.cityid where archive=0 and visible=1 and tbl_properties.roimobile=0 and (tbl_properties.saletypeid=16 or tbl_properties.saletypeid=17) and tbl_properties.propertytypeid=1 and tbl_properties.city in(1) and tbl_properties.regionid=153
Vanzari Apartamente - Agentie Imobiliara Nicole
