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.129442 49.279832, -123.129442 49.247832, -123.185442 49.247832, -123.185442 49.279832, -123.129442 49.279832))')) and ty_buildings.strata_no <> 'lms731' 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.157442,49.263832)) asc limit 8