Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like'

SELECT *,
(SELECT name FROM storage_bin WHERE id=storage_files.bin_id) AS bin_name,
CONCAT('foMOV',id) as foMOV
FROM
storage_files
WHERE




(
(CONCAT('fomov',id) like "%auerhahn%" OR suchtext like "%Auerhahn%" OR en_suchtext like "%Auerhahn%" OR geographie like "%Auerhahn%" OR suchtext_emo like "%Auerhahn%" OR jahreszeit like "%Auerhahn%" OR diskrete_infos like "%Auerhahn%" OR verwertungsrechte like "%Auerhahn%" OR en_geographie like "%Auerhahn%" OR en_suchtext_emo like "%Auerhahn%" OR en_infos like "%Auerhahn%" OR en_diskrete_infos like "%Auerhahn%")
AND (CONCAT('fomov',id) like "%balzt%" OR suchtext like "%balzt%" OR en_suchtext like "%balzt%" OR geographie like "%balzt%" OR suchtext_emo like "%balzt%" OR jahreszeit like "%balzt%" OR diskrete_infos like "%balzt%" OR verwertungsrechte like "%balzt%" OR en_geographie like "%balzt%" OR en_suchtext_emo like "%balzt%" OR en_infos like "%balzt%" OR en_diskrete_infos like "%balzt%")
AND (CONCAT('fomov',id) like "%am%" OR suchtext like "%am%" OR en_suchtext like "%am%" OR geographie like "%am%" OR suchtext_emo like "%am%" OR jahreszeit like "%am%" OR diskrete_infos like "%am%" OR verwertungsrechte like "%am%" OR en_geographie like "%am%" OR en_suchtext_emo like "%am%" OR en_infos like "%am%" OR en_diskrete_infos like "%am%")
AND (CONCAT('fomov',id) like "%frühen%" OR suchtext like "%frühen%" OR en_suchtext like "%frühen%" OR geographie like "%frühen%" OR suchtext_emo like "%frühen%" OR jahreszeit like "%frühen%" OR diskrete_infos like "%frühen%" OR verwertungsrechte like "%frühen%" OR en_geographie like "%frühen%" OR en_suchtext_emo like "%frühen%" OR en_infos like "%frühen%" OR en_diskrete_infos like "%frühen%")
AND (CONCAT('fomov',id) like "%morgen%" OR suchtext like "%Morgen%" OR en_suchtext like "%Morgen%" OR geographie like "%Morgen%" OR suchtext_emo like "%Morgen%" OR jahreszeit like "%Morgen%" OR diskrete_infos like "%Morgen%" OR verwertungsrechte like "%Morgen%" OR en_geographie like "%Morgen%" OR en_suchtext_emo like "%Morgen%" OR en_infos like "%Morgen%" OR en_diskrete_infos like "%Morgen%")
AND (CONCAT('fomov',id) like "%im%" OR suchtext like "%im%" OR en_suchtext like "%im%" OR geographie like "%im%" OR suchtext_emo like "%im%" OR jahreszeit like "%im%" OR diskrete_infos like "%im%" OR verwertungsrechte like "%im%" OR en_geographie like "%im%" OR en_suchtext_emo like "%im%" OR en_infos like "%im%" OR en_diskrete_infos like "%im%")
AND (CONCAT('fomov',id) like "%unterholz%" OR suchtext like "%Unterholz%" OR en_suchtext like "%Unterholz%" OR geographie like "%Unterholz%" OR suchtext_emo like "%Unterholz%" OR jahreszeit like "%Unterholz%" OR diskrete_infos like "%Unterholz%" OR verwertungsrechte like "%Unterholz%" OR en_geographie like "%Unterholz%" OR en_suchtext_emo like "%Unterholz%" OR en_infos like "%Unterholz%" OR en_diskrete_infos like "%Unterholz%")

)





AND
(user_id = 0 ||
(
(SELECT COUNT(id) FROM storage_files_rights_user WHERE file_id=storage_files.id) <= 0
AND
(SELECT COUNT(id) FROM storage_files_rights_group WHERE file_id=storage_files.id) <= 0
AND
(SELECT COUNT(id) FROM storage_bin_rights_group WHERE bin_id=storage_files.bin_id) <= 0
)
||
(
SELECT count(storage_files.id)
FROM storage_files, storage_bin_rights_group, usergroups_user
WHERE storage_bin_rights_group.bin_id = storage_files.bin_id
AND storage_bin_rights_group.usergroup_id = usergroups_user.usergroup_id
AND usergroups_user.user_id = 0
)
)
ORDER BY
realfilename ASC