Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/lib/php/pixilink/classes/StrataPage.php on line 356
Server shutdown in progressselect ty_buildings.* from `multi_sites`.`ty_buildings` join boards.listings on (listings.strata_id = ty_buildings.strata_no) where listings.table in ('mlsr_listings','vancouver_lotsland') and listings.status = 'Active' and reciprocity = 'Yes' and ty_buildings.strata_no REGEXP '^(LMS|BCS|VAS|EPS){1,1}' and ty_buildings.sources > 1 and st_within(ty_buildings.point, ST_GeomFromText('POLYGON((-123.1231 49.28611, -123.1231 49.25411, -123.1791 49.25411, -123.1791 49.28611, -123.1231 49.28611))')) and ty_buildings.strata_no <> 'vas61' and ty_buildings.city = 'Vancouver' and listings.city = 'Vancouver' and listings.class=2 group by ty_buildings.strata_no order by ST_Distance_Sphere(ty_buildings.point, point(-123.151100,49.270110)) asc limit 8