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.10026 49.27591, -123.10026 49.24391, -123.15626 49.24391, -123.15626 49.27591, -123.10026 49.27591))')) and ty_buildings.strata_no <> 'vas1373' 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.128260,49.259910)) asc limit 8