mysql_error on line

SELECT *,, guide.description, (SELECT COUNT(*) FROM r_guide WHERE r_guide.guide_id = AS number, (SELECT FROM r_guide LEFT JOIN images ON images.project_id = r_guide.project_id WHERE r_guide.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 = guide.user_id WHERE name = 'Würzburg-Nürnberg-München'AND users.screenname = 'anitapona' AND guide.private = '0' LIMIT 1

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