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 "%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%")<br />
 AND (CONCAT('fomov',id) like "%wildschweine%" OR suchtext like "%Wildschweine%" OR en_suchtext like "%Wildschweine%" OR geographie like "%Wildschweine%" OR suchtext_emo like "%Wildschweine%" OR jahreszeit like "%Wildschweine%" OR diskrete_infos like "%Wildschweine%" OR verwertungsrechte like "%Wildschweine%" OR en_geographie like "%Wildschweine%" OR en_suchtext_emo like "%Wildschweine%" OR en_infos like "%Wildschweine%" OR en_diskrete_infos like "%Wildschweine%")<br />
 AND (CONCAT('fomov',id) like "%suchen%" OR suchtext like "%suchen%" OR en_suchtext like "%suchen%" OR geographie like "%suchen%" OR suchtext_emo like "%suchen%" OR jahreszeit like "%suchen%" OR diskrete_infos like "%suchen%" OR verwertungsrechte like "%suchen%" OR en_geographie like "%suchen%" OR en_suchtext_emo like "%suchen%" OR en_infos like "%suchen%" OR en_diskrete_infos like "%suchen%")<br />
 AND (CONCAT('fomov',id) like "%in%" OR suchtext like "%in%" OR en_suchtext like "%in%" OR geographie like "%in%" OR suchtext_emo like "%in%" OR jahreszeit like "%in%" OR diskrete_infos like "%in%" OR verwertungsrechte like "%in%" OR en_geographie like "%in%" OR en_suchtext_emo like "%in%" OR en_infos like "%in%" OR en_diskrete_infos like "%in%")<br />
 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%")<br />
 AND (CONCAT('fomov',id) like "%abenddämmerung%" OR suchtext like "%Abenddämmerung%" OR en_suchtext like "%Abenddämmerung%" OR geographie like "%Abenddämmerung%" OR suchtext_emo like "%Abenddämmerung%" OR jahreszeit like "%Abenddämmerung%" OR diskrete_infos like "%Abenddämmerung%" OR verwertungsrechte like "%Abenddämmerung%" OR en_geographie like "%Abenddämmerung%" OR en_suchtext_emo like "%Abenddämmerung%" OR en_infos like "%Abenddämmerung%" OR en_diskrete_infos like "%Abenddämmerung%")<br />
 AND (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%")<br />
 AND (CONCAT('fomov',id) like "%auwald%" OR suchtext like "%Auwald%" OR en_suchtext like "%Auwald%" OR geographie like "%Auwald%" OR suchtext_emo like "%Auwald%" OR jahreszeit like "%Auwald%" OR diskrete_infos like "%Auwald%" OR verwertungsrechte like "%Auwald%" OR en_geographie like "%Auwald%" OR en_suchtext_emo like "%Auwald%" OR en_infos like "%Auwald%" OR en_diskrete_infos like "%Auwald%")<br />
 AND (CONCAT('fomov',id) like "%nach%" OR suchtext like "%nach%" OR en_suchtext like "%nach%" OR geographie like "%nach%" OR suchtext_emo like "%nach%" OR jahreszeit like "%nach%" OR diskrete_infos like "%nach%" OR verwertungsrechte like "%nach%" OR en_geographie like "%nach%" OR en_suchtext_emo like "%nach%" OR en_infos like "%nach%" OR en_diskrete_infos like "%nach%")<br />
 AND (CONCAT('fomov',id) like "%nahrung%" OR suchtext like "%Nahrung%" OR en_suchtext like "%Nahrung%" OR geographie like "%Nahrung%" OR suchtext_emo like "%Nahrung%" OR jahreszeit like "%Nahrung%" OR diskrete_infos like "%Nahrung%" OR verwertungsrechte like "%Nahrung%" OR en_geographie like "%Nahrung%" OR en_suchtext_emo like "%Nahrung%" OR en_infos like "%Nahrung%" OR en_diskrete_infos like "%Nahrung%")<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