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 "%fuchs%" OR suchtext like "%Fuchs%" OR en_suchtext like "%Fuchs%" OR geographie like "%Fuchs%" OR suchtext_emo like "%Fuchs%" OR jahreszeit like "%Fuchs%" OR diskrete_infos like "%Fuchs%" OR verwertungsrechte like "%Fuchs%" OR en_geographie like "%Fuchs%" OR en_suchtext_emo like "%Fuchs%" OR en_infos like "%Fuchs%" OR en_diskrete_infos like "%Fuchs%")
AND (CONCAT('fomov',id) like "%oder%" OR suchtext like "%oder%" OR en_suchtext like "%oder%" OR geographie like "%oder%" OR suchtext_emo like "%oder%" OR jahreszeit like "%oder%" OR diskrete_infos like "%oder%" OR verwertungsrechte like "%oder%" OR en_geographie like "%oder%" OR en_suchtext_emo like "%oder%" OR en_infos like "%oder%" OR en_diskrete_infos like "%oder%")
AND (CONCAT('fomov',id) like "%fähe%" OR suchtext like "%Fähe%" OR en_suchtext like "%Fähe%" OR geographie like "%Fähe%" OR suchtext_emo like "%Fähe%" OR jahreszeit like "%Fähe%" OR diskrete_infos like "%Fähe%" OR verwertungsrechte like "%Fähe%" OR en_geographie like "%Fähe%" OR en_suchtext_emo like "%Fähe%" OR en_infos like "%Fähe%" OR en_diskrete_infos like "%Fähe%")
AND (CONCAT('fomov',id) like "%kümmert%" OR suchtext like "%kümmert%" OR en_suchtext like "%kümmert%" OR geographie like "%kümmert%" OR suchtext_emo like "%kümmert%" OR jahreszeit like "%kümmert%" OR diskrete_infos like "%kümmert%" OR verwertungsrechte like "%kümmert%" OR en_geographie like "%kümmert%" OR en_suchtext_emo like "%kümmert%" OR en_infos like "%kümmert%" OR en_diskrete_infos like "%kümmert%")
AND (CONCAT('fomov',id) like "%sich%" OR suchtext like "%sich%" OR en_suchtext like "%sich%" OR geographie like "%sich%" OR suchtext_emo like "%sich%" OR jahreszeit like "%sich%" OR diskrete_infos like "%sich%" OR verwertungsrechte like "%sich%" OR en_geographie like "%sich%" OR en_suchtext_emo like "%sich%" OR en_infos like "%sich%" OR en_diskrete_infos like "%sich%")
AND (CONCAT('fomov',id) like "%um%" OR suchtext like "%um%" OR en_suchtext like "%um%" OR geographie like "%um%" OR suchtext_emo like "%um%" OR jahreszeit like "%um%" OR diskrete_infos like "%um%" OR verwertungsrechte like "%um%" OR en_geographie like "%um%" OR en_suchtext_emo like "%um%" OR en_infos like "%um%" OR en_diskrete_infos like "%um%")
AND (CONCAT('fomov',id) like "%ihre%" OR suchtext like "%ihre%" OR en_suchtext like "%ihre%" OR geographie like "%ihre%" OR suchtext_emo like "%ihre%" OR jahreszeit like "%ihre%" OR diskrete_infos like "%ihre%" OR verwertungsrechte like "%ihre%" OR en_geographie like "%ihre%" OR en_suchtext_emo like "%ihre%" OR en_infos like "%ihre%" OR en_diskrete_infos like "%ihre%")
AND (CONCAT('fomov',id) like "%jungen%" OR suchtext like "%Jungen%" OR en_suchtext like "%Jungen%" OR geographie like "%Jungen%" OR suchtext_emo like "%Jungen%" OR jahreszeit like "%Jungen%" OR diskrete_infos like "%Jungen%" OR verwertungsrechte like "%Jungen%" OR en_geographie like "%Jungen%" OR en_suchtext_emo like "%Jungen%" OR en_infos like "%Jungen%" OR en_diskrete_infos like "%Jungen%")

)





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