mysql_error on line

SELECT *, projects.id, projects.city, projects.user_id AS user_id, countries.country, countries.id AS country_id, states.state AS projectstate, beenthere.user_id AS beenthere, favorites.user_id AS favorites, projects.lat, projects.lon, users.removed AS removedUser, (SELECT COUNT(*) AS count FROM guide LEFT JOIN r_guide ON r_guide.guide_id = guide.id WHERE guide.user_id = '' AND r_guide.project_id = projects.id) as guide FROM projects LEFT JOIN countries ON countries.id = projects.country_id LEFT JOIN states ON states.id = projects.state_id LEFT JOIN beenthere ON beenthere.project_id = projects.id AND beenthere.user_id = '' LEFT JOIN favorites ON favorites.project_id = projects.id AND favorites.user_id = '' LEFT JOIN users ON users.id = projects.user_id WHERE TRIM(countries.country) = 'Spain' AND TRIM(projects.city) = 'San Sebastián' AND TRIM(project) = 'Peine del Viento' AND (projects.status = 5 OR (projects.other = 1 AND projects.showother = 1)) LIMIT 1

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='