Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/lib/php/pixilink/classes/Functions.php on line 285
Server shutdown in progressSELECT listingid, inserted, listprice_2, bedrooms, IF (inserted between '2024-11-12 10:57:40' and '2024-11-13 22:57:40', 1, 0) as datematch, IF (inserted between '2024-11-10 22:57:40' and '2024-11-12 10:57:40', 1, 0) as datematch2, IF (inserted < '2024-11-10 22:57:40', DATEDIFF(inserted, '2024-11-13 22:57:40'), 0) as datematch3, IF (listprice_2 between 3880000 and 4480000, 1, 0) as pricematch, IF (bedrooms >= 5, 1, 0) as bedsmatch FROM boards.listings WHERE `table` = 'mlsr_listings' AND city = 'West Vancouver' AND class = '1' AND `status` = 'Active' AND reciprocity = 'Yes' AND listingid not in ('R2936277','R2838377','R2838381','R2887633','R2923907','R2933962','R2880274','R2936625','R2936298','R2870102','R2903006') order by datematch desc, datematch2 desc, datematch3 desc, pricematch desc, bedsmatch desc limit 3