mysql_error on line

SELECT *, guide.id, guide.description, (SELECT COUNT(*) FROM r_guide WHERE r_guide.guide_id = guide.id) AS number, (SELECT images.id FROM r_guide LEFT JOIN images ON images.project_id = r_guide.project_id WHERE r_guide.guide_id = guide.id ORDER BY r_guide.position ASC, r_guide.project_id ASC, images.main DESC LIMIT 1) as image FROM guide LEFT JOIN users on users.id = guide.user_id WHERE name = 'Düsseldorf'AND users.screenname = 'dirk1955' AND guide.private = '0' LIMIT 1

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