Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like'<br><br />
	SELECT *, <br />
	(SELECT name FROM storage_bin WHERE id=storage_files.bin_id) AS bin_name,<br />
	CONCAT('foMOV',id) as foMOV   <br />
FROM <br />
	storage_files<br />
	 WHERE <br />
	<br />
	<br />
	<br />
	<br />
	(<br />
(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%")<br />
 AND (CONCAT('fomov',id) like "%platzhirsch%" OR suchtext like "%Platzhirsch%" OR en_suchtext like "%Platzhirsch%" OR geographie like "%Platzhirsch%" OR suchtext_emo like "%Platzhirsch%" OR jahreszeit like "%Platzhirsch%" OR diskrete_infos like "%Platzhirsch%" OR verwertungsrechte like "%Platzhirsch%" OR en_geographie like "%Platzhirsch%" OR en_suchtext_emo like "%Platzhirsch%" OR en_infos like "%Platzhirsch%" OR en_diskrete_infos like "%Platzhirsch%")<br />
 AND (CONCAT('fomov',id) like "%passt%" OR suchtext like "%passt%" OR en_suchtext like "%passt%" OR geographie like "%passt%" OR suchtext_emo like "%passt%" OR jahreszeit like "%passt%" OR diskrete_infos like "%passt%" OR verwertungsrechte like "%passt%" OR en_geographie like "%passt%" OR en_suchtext_emo like "%passt%" OR en_infos like "%passt%" OR en_diskrete_infos like "%passt%")<br />
 AND (CONCAT('fomov',id) like "%auf%" OR suchtext like "%auf%" OR en_suchtext like "%auf%" OR geographie like "%auf%" OR suchtext_emo like "%auf%" OR jahreszeit like "%auf%" OR diskrete_infos like "%auf%" OR verwertungsrechte like "%auf%" OR en_geographie like "%auf%" OR en_suchtext_emo like "%auf%" OR en_infos like "%auf%" OR en_diskrete_infos like "%auf%")<br />
 AND (CONCAT('fomov',id) like "%seine%" OR suchtext like "%seine%" OR en_suchtext like "%seine%" OR geographie like "%seine%" OR suchtext_emo like "%seine%" OR jahreszeit like "%seine%" OR diskrete_infos like "%seine%" OR verwertungsrechte like "%seine%" OR en_geographie like "%seine%" OR en_suchtext_emo like "%seine%" OR en_infos like "%seine%" OR en_diskrete_infos like "%seine%")<br />
 AND (CONCAT('fomov',id) like "%hirschkühe%" OR suchtext like "%Hirschkühe%" OR en_suchtext like "%Hirschkühe%" OR geographie like "%Hirschkühe%" OR suchtext_emo like "%Hirschkühe%" OR jahreszeit like "%Hirschkühe%" OR diskrete_infos like "%Hirschkühe%" OR verwertungsrechte like "%Hirschkühe%" OR en_geographie like "%Hirschkühe%" OR en_suchtext_emo like "%Hirschkühe%" OR en_infos like "%Hirschkühe%" OR en_diskrete_infos like "%Hirschkühe%")<br />
 AND (CONCAT('fomov',id) like "%auf%" OR suchtext like "%auf%" OR en_suchtext like "%auf%" OR geographie like "%auf%" OR suchtext_emo like "%auf%" OR jahreszeit like "%auf%" OR diskrete_infos like "%auf%" OR verwertungsrechte like "%auf%" OR en_geographie like "%auf%" OR en_suchtext_emo like "%auf%" OR en_infos like "%auf%" OR en_diskrete_infos like "%auf%")<br />
 AND (CONCAT('fomov',id) like "%und%" OR suchtext like "%und%" OR en_suchtext like "%und%" OR geographie like "%und%" OR suchtext_emo like "%und%" OR jahreszeit like "%und%" OR diskrete_infos like "%und%" OR verwertungsrechte like "%und%" OR en_geographie like "%und%" OR en_suchtext_emo like "%und%" OR en_infos like "%und%" OR en_diskrete_infos like "%und%")<br />
 AND (CONCAT('fomov',id) like "%treibt%" OR suchtext like "%treibt%" OR en_suchtext like "%treibt%" OR geographie like "%treibt%" OR suchtext_emo like "%treibt%" OR jahreszeit like "%treibt%" OR diskrete_infos like "%treibt%" OR verwertungsrechte like "%treibt%" OR en_geographie like "%treibt%" OR en_suchtext_emo like "%treibt%" OR en_infos like "%treibt%" OR en_diskrete_infos like "%treibt%")<br />
 AND (CONCAT('fomov',id) like "%seine%" OR suchtext like "%seine%" OR en_suchtext like "%seine%" OR geographie like "%seine%" OR suchtext_emo like "%seine%" OR jahreszeit like "%seine%" OR diskrete_infos like "%seine%" OR verwertungsrechte like "%seine%" OR en_geographie like "%seine%" OR en_suchtext_emo like "%seine%" OR en_infos like "%seine%" OR en_diskrete_infos like "%seine%")<br />
 AND (CONCAT('fomov',id) like "%nebenbuhler%" OR suchtext like "%Nebenbuhler%" OR en_suchtext like "%Nebenbuhler%" OR geographie like "%Nebenbuhler%" OR suchtext_emo like "%Nebenbuhler%" OR jahreszeit like "%Nebenbuhler%" OR diskrete_infos like "%Nebenbuhler%" OR verwertungsrechte like "%Nebenbuhler%" OR en_geographie like "%Nebenbuhler%" OR en_suchtext_emo like "%Nebenbuhler%" OR en_infos like "%Nebenbuhler%" OR en_diskrete_infos like "%Nebenbuhler%")<br />
 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%")<br />
 AND (CONCAT('fomov',id) like "%beihirsche%" OR suchtext like "%Beihirsche%" OR en_suchtext like "%Beihirsche%" OR geographie like "%Beihirsche%" OR suchtext_emo like "%Beihirsche%" OR jahreszeit like "%Beihirsche%" OR diskrete_infos like "%Beihirsche%" OR verwertungsrechte like "%Beihirsche%" OR en_geographie like "%Beihirsche%" OR en_suchtext_emo like "%Beihirsche%" OR en_infos like "%Beihirsche%" OR en_diskrete_infos like "%Beihirsche%")<br />
 AND (CONCAT('fomov',id) like "%weg%" OR suchtext like "%weg%" OR en_suchtext like "%weg%" OR geographie like "%weg%" OR suchtext_emo like "%weg%" OR jahreszeit like "%weg%" OR diskrete_infos like "%weg%" OR verwertungsrechte like "%weg%" OR en_geographie like "%weg%" OR en_suchtext_emo like "%weg%" OR en_infos like "%weg%" OR en_diskrete_infos like "%weg%")<br />
<br />
)<br />
 <br />
	<br />
	<br />
	<br />
	<br />
	 AND <br />
	(user_id = 0 || <br />
		(<br />
			(SELECT COUNT(id) FROM storage_files_rights_user WHERE file_id=storage_files.id) <= 0<br />
			AND<br />
			(SELECT COUNT(id) FROM storage_files_rights_group WHERE file_id=storage_files.id) <= 0<br />
			AND<br />
			(SELECT COUNT(id) FROM storage_bin_rights_group WHERE bin_id=storage_files.bin_id) <= 0<br />
		)<br />
		||<br />
		(<br />
			SELECT count(storage_files.id)<br />
FROM storage_files, storage_bin_rights_group, usergroups_user<br />
WHERE storage_bin_rights_group.bin_id = storage_files.bin_id<br />
AND storage_bin_rights_group.usergroup_id = usergroups_user.usergroup_id<br />
AND usergroups_user.user_id = 0<br />
		)<br />
	)<br />
ORDER BY <br />
	realfilename ASC