Error: SELECT * FROM ((SELECT countryName AS name FROM module_villas_countries WHERE MATCH (alternatives) AGAINST ('Cala D'or*' IN BOOLEAN MODE) >0) UNION ALL (SELECT name FROM module_villas_region WHERE MATCH (alternatives) AGAINST ('Cala D'or*' IN BOOLEAN MODE) >0) UNION ALL (SELECT name FROM module_villas_towns WHERE MATCH (alternatives) AGAINST ('Cala D'or*' IN BOOLEAN MODE) >0)) AS tmp LIMIT 15

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 'or*' IN BOOLEAN MODE) >0) UNION ALL (SELECT name FROM module_villas_region WHER' at line 1