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 "%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 "%juni%" OR suchtext like "%Juni%" OR en_suchtext like "%Juni%" OR geographie like "%Juni%" OR suchtext_emo like "%Juni%" OR jahreszeit like "%Juni%" OR diskrete_infos like "%Juni%" OR verwertungsrechte like "%Juni%" OR en_geographie like "%Juni%" OR en_suchtext_emo like "%Juni%" OR en_infos like "%Juni%" OR en_diskrete_infos like "%Juni%")
AND (CONCAT('fomov',id) like "%türmen%" OR suchtext like "%türmen%" OR en_suchtext like "%türmen%" OR geographie like "%türmen%" OR suchtext_emo like "%türmen%" OR jahreszeit like "%türmen%" OR diskrete_infos like "%türmen%" OR verwertungsrechte like "%türmen%" OR en_geographie like "%türmen%" OR en_suchtext_emo like "%türmen%" OR en_infos like "%türmen%" OR en_diskrete_infos like "%türmen%")
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 "%die%" OR suchtext like "%die%" OR en_suchtext like "%die%" OR geographie like "%die%" OR suchtext_emo like "%die%" OR jahreszeit like "%die%" OR diskrete_infos like "%die%" OR verwertungsrechte like "%die%" OR en_geographie like "%die%" OR en_suchtext_emo like "%die%" OR en_infos like "%die%" OR en_diskrete_infos like "%die%")
AND (CONCAT('fomov',id) like "%ersten%" OR suchtext like "%ersten%" OR en_suchtext like "%ersten%" OR geographie like "%ersten%" OR suchtext_emo like "%ersten%" OR jahreszeit like "%ersten%" OR diskrete_infos like "%ersten%" OR verwertungsrechte like "%ersten%" OR en_geographie like "%ersten%" OR en_suchtext_emo like "%ersten%" OR en_infos like "%ersten%" OR en_diskrete_infos like "%ersten%")
AND (CONCAT('fomov',id) like "%gewitterwolken%" OR suchtext like "%Gewitterwolken%" OR en_suchtext like "%Gewitterwolken%" OR geographie like "%Gewitterwolken%" OR suchtext_emo like "%Gewitterwolken%" OR jahreszeit like "%Gewitterwolken%" OR diskrete_infos like "%Gewitterwolken%" OR verwertungsrechte like "%Gewitterwolken%" OR en_geographie like "%Gewitterwolken%" OR en_suchtext_emo like "%Gewitterwolken%" OR en_infos like "%Gewitterwolken%" OR en_diskrete_infos like "%Gewitterwolken%")
AND (CONCAT('fomov',id) like "%der%" OR suchtext like "%der%" OR en_suchtext like "%der%" OR geographie like "%der%" OR suchtext_emo like "%der%" OR jahreszeit like "%der%" OR diskrete_infos like "%der%" OR verwertungsrechte like "%der%" OR en_geographie like "%der%" OR en_suchtext_emo like "%der%" OR en_infos like "%der%" OR en_diskrete_infos like "%der%")
AND (CONCAT('fomov',id) like "%saison%" OR suchtext like "%Saison%" OR en_suchtext like "%Saison%" OR geographie like "%Saison%" OR suchtext_emo like "%Saison%" OR jahreszeit like "%Saison%" OR diskrete_infos like "%Saison%" OR verwertungsrechte like "%Saison%" OR en_geographie like "%Saison%" OR en_suchtext_emo like "%Saison%" OR en_infos like "%Saison%" OR en_diskrete_infos like "%Saison%")
AND (CONCAT('fomov',id) like "%über%" OR suchtext like "%über%" OR en_suchtext like "%über%" OR geographie like "%über%" OR suchtext_emo like "%über%" OR jahreszeit like "%über%" OR diskrete_infos like "%über%" OR verwertungsrechte like "%über%" OR en_geographie like "%über%" OR en_suchtext_emo like "%über%" OR en_infos like "%über%" OR en_diskrete_infos like "%über%")
AND (CONCAT('fomov',id) like "%sonnwelleck%" OR suchtext like "%Sonnwelleck%" OR en_suchtext like "%Sonnwelleck%" OR geographie like "%Sonnwelleck%" OR suchtext_emo like "%Sonnwelleck%" OR jahreszeit like "%Sonnwelleck%" OR diskrete_infos like "%Sonnwelleck%" OR verwertungsrechte like "%Sonnwelleck%" OR en_geographie like "%Sonnwelleck%" OR en_suchtext_emo like "%Sonnwelleck%" OR en_infos like "%Sonnwelleck%" OR en_diskrete_infos like "%Sonnwelleck%")

)





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