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