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 's%' AND wfp_users_desc.is_active = 'Da'' at line 1:
SELECT wfp_users_desc.*, wfp_users.rank FROM wfp_users_desc, wfp_users WHERE wfp_users_desc.username = wfp_users.username AND wfp_users_desc.keywords like '%Valentine's%' AND wfp_users_desc.is_active = 'Da'