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 'oreal%' AND wfp_produse.is_active = 'Da'' at line 1:

SELECT wfp_produse.*, wfp_users.rank FROM wfp_produse, wfp_users WHERE wfp_users.user_id = wfp_produse.user_id AND wfp_produse.keywords like '%rimel l'oreal%' AND wfp_produse.is_active = 'Da'