A Database Error Occurred

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 's +Stortford' IN BOOLEAN MODE) AND `l`.`listing_status` = 'publish' ORDER BY `l`' at line 6

select tb_l.*,m.file_name,m.disk,m.thumb_file_name,p.plan_name from (SELECT `l`.`id`, `l`.`listing_date`, `l`.`listing_content`, `l`.`listing_title`, `l`.`listing_name`, `l`.`address`, `l`.`phone`, `l`.`facebook`, `l`.`twitter`, `l`.`website`, `l`.`featured`, `l`.`listing_status`, `l`.`featured-home`, `l`.`featured-home_duration`, `l`.`featured-home_start_date`, `l`.`plan_id` FROM `listings` `l` JOIN `listing_categories` `lc` ON `lc`.`listing_id`=`l`.`id` JOIN `categories` `c` ON `c`.`id`=`lc`.`category_id` WHERE `c`.`slug` = 'cleaning-service' AND MATCH(l.address) AGAINST ('+Bishop's +Stortford' IN BOOLEAN MODE) AND `l`.`listing_status` = 'publish' ORDER BY `l`.`listing_rank_date` desc LIMIT 10) as tb_l left join listing_media m on tb_l.id=m.listing_id left join plans p on tb_l.plan_id=p.id limit 10

Filename: models/Model_listings.php

Line Number: 91