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