Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like':
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 '%Spălătoria de covoare Tecuci%' AND wfp_users_desc.is_active = 'Da'