mysql_error on line

SELECT *,,, projects.user_id AS user_id,, AS country_id, states.state AS projectstate, beenthere.user_id AS beenthere, favorites.user_id AS favorites,, projects.lon, users.removed AS removedUser, (SELECT COUNT(*) AS count FROM guide LEFT JOIN r_guide ON r_guide.guide_id = WHERE guide.user_id = '' AND r_guide.project_id = as guide FROM projects LEFT JOIN countries ON = projects.country_id LEFT JOIN states ON = projects.state_id LEFT JOIN beenthere ON beenthere.project_id = AND beenthere.user_id = '' LEFT JOIN favorites ON favorites.project_id = AND favorites.user_id = '' LEFT JOIN users ON = projects.user_id WHERE TRIM( = 'Spain' AND TRIM( = 'A Coruņa' AND TRIM(project) = 'Fishermen\'s refuge in Redes village' 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 '='