Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'current_listings' at line 8

SELECT `tbl_mls_listings_data`.`sysid`,`tbl_mls_listings_data`.`type`, `tbl_mls_listings_data`.`open_house_to`, `tbl_mls_listings_data`.`listingID`, `tbl_mls_listings_data`.`186` AS totalImages, `tbl_mls_listings_data`.`224` AS listdate, `tbl_mls_listings_data`.`248` AS listingid, `tbl_mls_listings_data`.`226` AS price, `tbl_mls_listings_data`.`14` AS address, `tbl_mls_listings_data`.`2568` AS area, `tbl_mls_listings_data`.`3922` AS interior, `tbl_mls_listings_data`.`2233`, `tbl_mls_listings_data`.`2570` AS subarea, `tbl_mls_listings_data`.`3794` AS city, `tbl_mls_listings_data`.`378` AS bedrooms, `tbl_mls_listings_data`.`3928` AS bathrooms, `tbl_mls_listings_data`.`26` AS video, `tbl_mls_listings_data`.`363` AS ListingStatus , `tbl_mls_listings_data`.`2679` AS provider, CONCAT(`tbl_mls_listings_data`.`411`, `tbl_mls_listings_data`.`3985`) AS description, `tbl_mls_listings_data`.`upon_request`, `tbl_mls_listings_data`.`tags`, `tbl_mls_listings_data`.`address2`, `tbl_mls_listings_data`.`textonbutton`, `tbl_mls_listings_data`.`image_path`, `tbl_mls_listings_data`.`geoLon`, `tbl_mls_listings_data`.`geoLat`, (SELECT largepic FROM tbl_listing_images WHERE type = 1 AND listingid = tbl_mls_listings_data.listingID LIMIT 0,1) AS main_image FROM `tbl_mls_listings_data` WHERE (`tbl_mls_listings_data`.`type` = 3) AND (`tbl_mls_listings_data`.`226` >= 300000) AND (`tbl_mls_listings_data`.`378` BETWEEN 1 AND 5) AND (`tbl_mls_listings_data`.`2733` = "Apart") AND (`tbl_mls_listings_data`.`43` = "Real Estate Board of Greater Vancouver") AND (`tbl_mls_listings_data`.`2233` IN ("VNV","VVE","VVW","VWV")) AND (`tbl_mls_listings_data`.`2570` IN ("VVWAR","VNVBL","VNVBD","VNVBR","VNVCV","VVWCA","VNVCY","VNVCH","VNVCA","VNVCL","VVECH","VVWCB","VVECO","VNVDC","VNVDE","VNVDO","VVEDT","VVWDT","VVWDU","VVWFA","VVWFC","VVWYA","VNVFH","VVEFR","VVEFV","VVEGR","VNVGW","VNVHM","VNVHH","VVEHA","VVEHE","VNVIA","VNVIR","VVWKE","VVEKL","VVWKT","VVEKN","VNVLL","VNVLV","VNVLY","VVWMH","VVEMN","VVWMR","VVEMP","VVWMP","VNVNG","VNVNL","VNVPH","VNVPN","VNVPP","VNVQU","VVERH","VVERE","VNVRP","VNVSY","VVESV","VNVTE","VNVUD","VNVUL","VVEVI","VNVWL","VNVWT","VNVWP","VNVWS")) AND (`tbl_mls_listings_data`.`248` != "") OR (`tbl_mls_listings_data`.`type` = 1 AND `tbl_mls_listings_data`.`client_id` = 732 AND `tbl_mls_listings_data`.`hide` = 1) GROUP BY `tbl_mls_listings_data`.`listingID` ORDER BY `tbl_mls_listings_data`.`226` DESC LIMIT 0, current_listings