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_vil' at line 3