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 "%füttern-2%" OR (suchtext like "%f_¼ttern-2%" OR suchtext like "%fÃ_ttern-2%" OR suchtext like "%fü_tern-2%" OR suchtext like "%füt_ern-2%" OR suchtext like "%fütt_rn-2%" OR suchtext like "%fütte_n-2%" OR suchtext like "%fütter_-2%" OR suchtext like "%füttern_2%" OR suchtext like "%füttern-_%" ) OR (en_suchtext like "%f_¼ttern-2%" OR en_suchtext like "%fÃ_ttern-2%" OR en_suchtext like "%fü_tern-2%" OR en_suchtext like "%füt_ern-2%" OR en_suchtext like "%fütt_rn-2%" OR en_suchtext like "%fütte_n-2%" OR en_suchtext like "%fütter_-2%" OR en_suchtext like "%füttern_2%" OR en_suchtext like "%füttern-_%" ) OR (geographie like "%f_¼ttern-2%" OR geographie like "%fÃ_ttern-2%" OR geographie like "%fü_tern-2%" OR geographie like "%füt_ern-2%" OR geographie like "%fütt_rn-2%" OR geographie like "%fütte_n-2%" OR geographie like "%fütter_-2%" OR geographie like "%füttern_2%" OR geographie like "%füttern-_%" ) OR (suchtext_emo like "%f_¼ttern-2%" OR suchtext_emo like "%fÃ_ttern-2%" OR suchtext_emo like "%fü_tern-2%" OR suchtext_emo like "%füt_ern-2%" OR suchtext_emo like "%fütt_rn-2%" OR suchtext_emo like "%fütte_n-2%" OR suchtext_emo like "%fütter_-2%" OR suchtext_emo like "%füttern_2%" OR suchtext_emo like "%füttern-_%" ) OR (jahreszeit like "%f_¼ttern-2%" OR jahreszeit like "%fÃ_ttern-2%" OR jahreszeit like "%fü_tern-2%" OR jahreszeit like "%füt_ern-2%" OR jahreszeit like "%fütt_rn-2%" OR jahreszeit like "%fütte_n-2%" OR jahreszeit like "%fütter_-2%" OR jahreszeit like "%füttern_2%" OR jahreszeit like "%füttern-_%" ) OR (diskrete_infos like "%f_¼ttern-2%" OR diskrete_infos like "%fÃ_ttern-2%" OR diskrete_infos like "%fü_tern-2%" OR diskrete_infos like "%füt_ern-2%" OR diskrete_infos like "%fütt_rn-2%" OR diskrete_infos like "%fütte_n-2%" OR diskrete_infos like "%fütter_-2%" OR diskrete_infos like "%füttern_2%" OR diskrete_infos like "%füttern-_%" ) OR (verwertungsrechte like "%f_¼ttern-2%" OR verwertungsrechte like "%fÃ_ttern-2%" OR verwertungsrechte like "%fü_tern-2%" OR verwertungsrechte like "%füt_ern-2%" OR verwertungsrechte like "%fütt_rn-2%" OR verwertungsrechte like "%fütte_n-2%" OR verwertungsrechte like "%fütter_-2%" OR verwertungsrechte like "%füttern_2%" OR verwertungsrechte like "%füttern-_%" ) OR (en_geographie like "%f_¼ttern-2%" OR en_geographie like "%fÃ_ttern-2%" OR en_geographie like "%fü_tern-2%" OR en_geographie like "%füt_ern-2%" OR en_geographie like "%fütt_rn-2%" OR en_geographie like "%fütte_n-2%" OR en_geographie like "%fütter_-2%" OR en_geographie like "%füttern_2%" OR en_geographie like "%füttern-_%" ) OR (en_suchtext_emo like "%f_¼ttern-2%" OR en_suchtext_emo like "%fÃ_ttern-2%" OR en_suchtext_emo like "%fü_tern-2%" OR en_suchtext_emo like "%füt_ern-2%" OR en_suchtext_emo like "%fütt_rn-2%" OR en_suchtext_emo like "%fütte_n-2%" OR en_suchtext_emo like "%fütter_-2%" OR en_suchtext_emo like "%füttern_2%" OR en_suchtext_emo like "%füttern-_%" ) OR (en_infos like "%f_¼ttern-2%" OR en_infos like "%fÃ_ttern-2%" OR en_infos like "%fü_tern-2%" OR en_infos like "%füt_ern-2%" OR en_infos like "%fütt_rn-2%" OR en_infos like "%fütte_n-2%" OR en_infos like "%fütter_-2%" OR en_infos like "%füttern_2%" OR en_infos like "%füttern-_%" ) OR (en_diskrete_infos like "%f_¼ttern-2%" OR en_diskrete_infos like "%fÃ_ttern-2%" OR en_diskrete_infos like "%fü_tern-2%" OR en_diskrete_infos like "%füt_ern-2%" OR en_diskrete_infos like "%fütt_rn-2%" OR en_diskrete_infos like "%fütte_n-2%" OR en_diskrete_infos like "%fütter_-2%" OR en_diskrete_infos like "%füttern_2%" OR en_diskrete_infos like "%füttern-_%" ))

)





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