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 "%das%" OR suchtext like "%Das%" OR en_suchtext like "%Das%" OR geographie like "%Das%" OR suchtext_emo like "%Das%" OR jahreszeit like "%Das%" OR diskrete_infos like "%Das%" OR verwertungsrechte like "%Das%" OR en_geographie like "%Das%" OR en_suchtext_emo like "%Das%" OR en_infos like "%Das%" OR en_diskrete_infos like "%Das%")<br />
 AND (CONCAT('fomov',id) like "%flugzeug%" OR suchtext like "%Flugzeug%" OR en_suchtext like "%Flugzeug%" OR geographie like "%Flugzeug%" OR suchtext_emo like "%Flugzeug%" OR jahreszeit like "%Flugzeug%" OR diskrete_infos like "%Flugzeug%" OR verwertungsrechte like "%Flugzeug%" OR en_geographie like "%Flugzeug%" OR en_suchtext_emo like "%Flugzeug%" OR en_infos like "%Flugzeug%" OR en_diskrete_infos like "%Flugzeug%")<br />
 AND (CONCAT('fomov',id) like "%boeing%" OR suchtext like "%Boeing%" OR en_suchtext like "%Boeing%" OR geographie like "%Boeing%" OR suchtext_emo like "%Boeing%" OR jahreszeit like "%Boeing%" OR diskrete_infos like "%Boeing%" OR verwertungsrechte like "%Boeing%" OR en_geographie like "%Boeing%" OR en_suchtext_emo like "%Boeing%" OR en_infos like "%Boeing%" OR en_diskrete_infos like "%Boeing%")<br />
 AND (CONCAT('fomov',id) like "%767%" OR suchtext like "%767%" OR en_suchtext like "%767%" OR geographie like "%767%" OR suchtext_emo like "%767%" OR jahreszeit like "%767%" OR diskrete_infos like "%767%" OR verwertungsrechte like "%767%" OR en_geographie like "%767%" OR en_suchtext_emo like "%767%" OR en_infos like "%767%" OR en_diskrete_infos like "%767%")<br />
 AND (CONCAT('fomov',id) like "%fliegt%" OR suchtext like "%fliegt%" OR en_suchtext like "%fliegt%" OR geographie like "%fliegt%" OR suchtext_emo like "%fliegt%" OR jahreszeit like "%fliegt%" OR diskrete_infos like "%fliegt%" OR verwertungsrechte like "%fliegt%" OR en_geographie like "%fliegt%" OR en_suchtext_emo like "%fliegt%" OR en_infos like "%fliegt%" OR en_diskrete_infos like "%fliegt%")<br />
 AND (CONCAT('fomov',id) like "%hoch%" OR suchtext like "%hoch%" OR en_suchtext like "%hoch%" OR geographie like "%hoch%" OR suchtext_emo like "%hoch%" OR jahreszeit like "%hoch%" OR diskrete_infos like "%hoch%" OR verwertungsrechte like "%hoch%" OR en_geographie like "%hoch%" OR en_suchtext_emo like "%hoch%" OR en_infos like "%hoch%" OR en_diskrete_infos like "%hoch%")<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 "%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 "%nord%" OR suchtext like "%Nord%" OR en_suchtext like "%Nord%" OR geographie like "%Nord%" OR suchtext_emo like "%Nord%" OR jahreszeit like "%Nord%" OR diskrete_infos like "%Nord%" OR verwertungsrechte like "%Nord%" OR en_geographie like "%Nord%" OR en_suchtext_emo like "%Nord%" OR en_infos like "%Nord%" OR en_diskrete_infos like "%Nord%")<br />
 AND (CONCAT('fomov',id) like "%atlantik%" OR suchtext like "%Atlantik%" OR en_suchtext like "%Atlantik%" OR geographie like "%Atlantik%" OR suchtext_emo like "%Atlantik%" OR jahreszeit like "%Atlantik%" OR diskrete_infos like "%Atlantik%" OR verwertungsrechte like "%Atlantik%" OR en_geographie like "%Atlantik%" OR en_suchtext_emo like "%Atlantik%" OR en_infos like "%Atlantik%" OR en_diskrete_infos like "%Atlantik%")<br />
 AND (CONCAT('fomov',id) like "%luftstrasse%" OR suchtext like "%Luftstrasse%" OR en_suchtext like "%Luftstrasse%" OR geographie like "%Luftstrasse%" OR suchtext_emo like "%Luftstrasse%" OR jahreszeit like "%Luftstrasse%" OR diskrete_infos like "%Luftstrasse%" OR verwertungsrechte like "%Luftstrasse%" OR en_geographie like "%Luftstrasse%" OR en_suchtext_emo like "%Luftstrasse%" OR en_infos like "%Luftstrasse%" OR en_diskrete_infos like "%Luftstrasse%")<br />
 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%")<br />
 AND (CONCAT('fomov',id) like "%grönland%" OR suchtext like "%Grönland%" OR en_suchtext like "%Grönland%" OR geographie like "%Grönland%" OR suchtext_emo like "%Grönland%" OR jahreszeit like "%Grönland%" OR diskrete_infos like "%Grönland%" OR verwertungsrechte like "%Grönland%" OR en_geographie like "%Grönland%" OR en_suchtext_emo like "%Grönland%" OR en_infos like "%Grönland%" OR en_diskrete_infos like "%Grönland%")<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