Error: 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 'Baneasa'' IN BOOLEAN MODE) AS relevancy, p.product_id FROM pro' at line 2
Error No: 1064
SELECT MATCH(pd.author) AGAINST ('Fabrica de caramizi 'Baneasa'' IN BOOLEAN MODE) AS relevancy, p.product_id FROM product p LEFT JOIN product_description pd ON p.product_id = pd.product_id WHERE MATCH(pd.author) AGAINST ('Fabrica de caramizi 'Baneasa'' IN BOOLEAN MODE) AND p.date_available < now() AND p.quantity > 0 AND p.status = '1' AND p.product_id != 16748 HAVING relevancy > 1.5 ORDER BY relevancy DESC, p.quantity DESC