Error #1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=':SELECT cust_firstname, cust_lastname, auth_publishname, auth_id, cust_image, auth_biography, auth_where_start_write, auth_when_start_write, auth_what_love, auth_other_forms, auth_other_passions, auth_distracts, auth_favourite, auth_fave_author1, auth_fave_author2, auth_fave_author3, auth_dream_location, auth_room101, auth_advice from ( SELECT distinct c.cust_firstname, c.cust_lastname, a.*, c.cust_image, count(cs.story_id) as published from cals_customer c inner join cals_authors a on a.auth_id = c.cust_id inner join cals_stories cs on cs.story_authid = a.auth_id where cs.story_status = 1 and a.auth_id = '1430' and replace(replace(a.auth_publishname,"'",''),' ','-') = 'daniel-tour��' order by story_uploadeddate desc ) t1 order by cust_lastname asc