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` BETWEEN 25000 AND 4000000) AND (`tbl_mls_listings_data`.`378` BETWEEN 1 AND 5) AND (`tbl_mls_listings_data`.`43` = "Real Estate Board of Greater Vancouver") AND (`tbl_mls_listings_data`.`2233` IN ("VNV","VWV")) AND (`tbl_mls_listings_data`.`2570` IN ("VWVAL","VWVAM","VWVBR","VNVBL","VNVBD","VNVBR","VWVBP","VNVCV","VWVCB","VNVCY","VNVCH","VNVCA","VWVCA","VWVCD","VNVCL","VWVCW","VWVCP","VVWCB","VWVCY","VWVCE","VNVDC","VWVDR","VNVDE","VNVDO","VWVDU","VWVEH","VWVER","VNVFH","VWVFC","VWVGL","VWVGM","VNVGW","VNVHM","VNVHH","VWVHB","VWVHS","VNVIA","VNVIR","VWVLB","VNVLL","VNVLV","VNVLY","VNVNG","VNVNL","VWVOC","VWVPV","VWVPR","VNVPH","VNVPN","VWVPO","VNVPP","VWVQU","VNVQU","VNVRP","VWVRR","VWVSC","VNVSY","VNVTE","VNVUD","VNVUL","VNVWL","VNVWT","VNVWP","VNVWS")) AND (`tbl_mls_listings_data`.`248` != "") OR (`tbl_mls_listings_data`.`type` = 1 AND `tbl_mls_listings_data`.`client_id` = 821 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