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 "%perspektive%" OR suchtext like "%Perspektive%" OR en_suchtext like "%Perspektive%" OR geographie like "%Perspektive%" OR suchtext_emo like "%Perspektive%" OR jahreszeit like "%Perspektive%" OR diskrete_infos like "%Perspektive%" OR verwertungsrechte like "%Perspektive%" OR en_geographie like "%Perspektive%" OR en_suchtext_emo like "%Perspektive%" OR en_infos like "%Perspektive%" OR en_diskrete_infos like "%Perspektive%")
AND (CONCAT('fomov',id) like "%(zum%" OR suchtext like "%(zum%" OR en_suchtext like "%(zum%" OR geographie like "%(zum%" OR suchtext_emo like "%(zum%" OR jahreszeit like "%(zum%" OR diskrete_infos like "%(zum%" OR verwertungsrechte like "%(zum%" OR en_geographie like "%(zum%" OR en_suchtext_emo like "%(zum%" OR en_infos like "%(zum%" OR en_diskrete_infos like "%(zum%")
AND (CONCAT('fomov',id) like "%mehrfachen%" OR suchtext like "%mehrfachen%" OR en_suchtext like "%mehrfachen%" OR geographie like "%mehrfachen%" OR suchtext_emo like "%mehrfachen%" OR jahreszeit like "%mehrfachen%" OR diskrete_infos like "%mehrfachen%" OR verwertungsrechte like "%mehrfachen%" OR en_geographie like "%mehrfachen%" OR en_suchtext_emo like "%mehrfachen%" OR en_infos like "%mehrfachen%" OR en_diskrete_infos like "%mehrfachen%")
AND (CONCAT('fomov',id) like "%auswählen%" OR suchtext like "%Auswählen%" OR en_suchtext like "%Auswählen%" OR geographie like "%Auswählen%" OR suchtext_emo like "%Auswählen%" OR jahreszeit like "%Auswählen%" OR diskrete_infos like "%Auswählen%" OR verwertungsrechte like "%Auswählen%" OR en_geographie like "%Auswählen%" OR en_suchtext_emo like "%Auswählen%" OR en_infos like "%Auswählen%" OR en_diskrete_infos like "%Auswählen%")
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 "%nix)pov%" OR suchtext like "%nix)POV%" OR en_suchtext like "%nix)POV%" OR geographie like "%nix)POV%" OR suchtext_emo like "%nix)POV%" OR jahreszeit like "%nix)POV%" OR diskrete_infos like "%nix)POV%" OR verwertungsrechte like "%nix)POV%" OR en_geographie like "%nix)POV%" OR en_suchtext_emo like "%nix)POV%" OR en_infos like "%nix)POV%" OR en_diskrete_infos like "%nix)POV%")
AND (CONCAT('fomov',id) like "%(point%" OR suchtext like "%(point%" OR en_suchtext like "%(point%" OR geographie like "%(point%" OR suchtext_emo like "%(point%" OR jahreszeit like "%(point%" OR diskrete_infos like "%(point%" OR verwertungsrechte like "%(point%" OR en_geographie like "%(point%" OR en_suchtext_emo like "%(point%" OR en_infos like "%(point%" OR en_diskrete_infos like "%(point%")
AND (CONCAT('fomov',id) like "%of%" OR suchtext like "%of%" OR en_suchtext like "%of%" OR geographie like "%of%" OR suchtext_emo like "%of%" OR jahreszeit like "%of%" OR diskrete_infos like "%of%" OR verwertungsrechte like "%of%" OR en_geographie like "%of%" OR en_suchtext_emo like "%of%" OR en_infos like "%of%" OR en_diskrete_infos like "%of%")
AND (CONCAT('fomov',id) like "%view%" OR suchtext like "%view%" OR en_suchtext like "%view%" OR geographie like "%view%" OR suchtext_emo like "%view%" OR jahreszeit like "%view%" OR diskrete_infos like "%view%" OR verwertungsrechte like "%view%" OR en_geographie like "%view%" OR en_suchtext_emo like "%view%" OR en_infos like "%view%" OR en_diskrete_infos like "%view%")
AND (CONCAT('fomov',id) like "%shot)%" OR suchtext like "%shot)%" OR en_suchtext like "%shot)%" OR geographie like "%shot)%" OR suchtext_emo like "%shot)%" OR jahreszeit like "%shot)%" OR diskrete_infos like "%shot)%" OR verwertungsrechte like "%shot)%" OR en_geographie like "%shot)%" OR en_suchtext_emo like "%shot)%" OR en_infos like "%shot)%" OR en_diskrete_infos like "%shot)%")

)





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