You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Олерон'
ORDER BY add_time DESC
LIMIT 3' at line 3
SELECT d.*, p.name_ru name, p.slug
FROM SC_discussions d LEFT JOIN SC_products p ON p.productID = d.productID
WHERE confirm = 1 AND d.city = 'Сен-Жорж-д'Олерон'
ORDER BY add_time DESC
LIMIT 3