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 "%what%" OR suchtext like "%What%" OR en_suchtext like "%What%" OR geographie like "%What%" OR suchtext_emo like "%What%" OR jahreszeit like "%What%" OR diskrete_infos like "%What%" OR verwertungsrechte like "%What%" OR en_geographie like "%What%" OR en_suchtext_emo like "%What%" OR en_infos like "%What%" OR en_diskrete_infos like "%What%")<br />
 AND (CONCAT('fomov',id) like "%is%" OR suchtext like "%is%" OR en_suchtext like "%is%" OR geographie like "%is%" OR suchtext_emo like "%is%" OR jahreszeit like "%is%" OR diskrete_infos like "%is%" OR verwertungsrechte like "%is%" OR en_geographie like "%is%" OR en_suchtext_emo like "%is%" OR en_infos like "%is%" OR en_diskrete_infos like "%is%")<br />
 AND (CONCAT('fomov',id) like "%the%" OR suchtext like "%the%" OR en_suchtext like "%the%" OR geographie like "%the%" OR suchtext_emo like "%the%" OR jahreszeit like "%the%" OR diskrete_infos like "%the%" OR verwertungsrechte like "%the%" OR en_geographie like "%the%" OR en_suchtext_emo like "%the%" OR en_infos like "%the%" OR en_diskrete_infos like "%the%")<br />
 AND (CONCAT('fomov',id) like "%main%" OR suchtext like "%main%" OR en_suchtext like "%main%" OR geographie like "%main%" OR suchtext_emo like "%main%" OR jahreszeit like "%main%" OR diskrete_infos like "%main%" OR verwertungsrechte like "%main%" OR en_geographie like "%main%" OR en_suchtext_emo like "%main%" OR en_infos like "%main%" OR en_diskrete_infos like "%main%")<br />
 AND (CONCAT('fomov',id) like "%object?%" OR suchtext like "%object?%" OR en_suchtext like "%object?%" OR geographie like "%object?%" OR suchtext_emo like "%object?%" OR jahreszeit like "%object?%" OR diskrete_infos like "%object?%" OR verwertungsrechte like "%object?%" OR en_geographie like "%object?%" OR en_suchtext_emo like "%object?%" OR en_infos like "%object?%" OR en_diskrete_infos like "%object?%")<br />
 AND (CONCAT('fomov',id) like "%%" OR suchtext like "%%" OR en_suchtext like "%%" OR geographie like "%%" OR suchtext_emo like "%%" OR jahreszeit like "%%" OR diskrete_infos like "%%" OR verwertungsrechte like "%%" OR en_geographie like "%%" OR en_suchtext_emo like "%%" OR en_infos like "%%" OR en_diskrete_infos like "%%")<br />
 AND (CONCAT('fomov',id) like "%scientific%" OR suchtext like "%Scientific%" OR en_suchtext like "%Scientific%" OR geographie like "%Scientific%" OR suchtext_emo like "%Scientific%" OR jahreszeit like "%Scientific%" OR diskrete_infos like "%Scientific%" OR verwertungsrechte like "%Scientific%" OR en_geographie like "%Scientific%" OR en_suchtext_emo like "%Scientific%" OR en_infos like "%Scientific%" OR en_diskrete_infos like "%Scientific%")<br />
 AND (CONCAT('fomov',id) like "%name.%" OR suchtext like "%name.%" OR en_suchtext like "%name.%" OR geographie like "%name.%" OR suchtext_emo like "%name.%" OR jahreszeit like "%name.%" OR diskrete_infos like "%name.%" OR verwertungsrechte like "%name.%" OR en_geographie like "%name.%" OR en_suchtext_emo like "%name.%" OR en_infos like "%name.%" OR en_diskrete_infos like "%name.%")<br />
 AND (CONCAT('fomov',id) like "%avoid%" OR suchtext like "%Avoid%" OR en_suchtext like "%Avoid%" OR geographie like "%Avoid%" OR suchtext_emo like "%Avoid%" OR jahreszeit like "%Avoid%" OR diskrete_infos like "%Avoid%" OR verwertungsrechte like "%Avoid%" OR en_geographie like "%Avoid%" OR en_suchtext_emo like "%Avoid%" OR en_infos like "%Avoid%" OR en_diskrete_infos like "%Avoid%")<br />
 AND (CONCAT('fomov',id) like "%common%" OR suchtext like "%common%" OR en_suchtext like "%common%" OR geographie like "%common%" OR suchtext_emo like "%common%" OR jahreszeit like "%common%" OR diskrete_infos like "%common%" OR verwertungsrechte like "%common%" OR en_geographie like "%common%" OR en_suchtext_emo like "%common%" OR en_infos like "%common%" OR en_diskrete_infos like "%common%")<br />
 AND (CONCAT('fomov',id) like "%words%" OR suchtext like "%words%" OR en_suchtext like "%words%" OR geographie like "%words%" OR suchtext_emo like "%words%" OR jahreszeit like "%words%" OR diskrete_infos like "%words%" OR verwertungsrechte like "%words%" OR en_geographie like "%words%" OR en_suchtext_emo like "%words%" OR en_infos like "%words%" OR en_diskrete_infos like "%words%")<br />
 AND (CONCAT('fomov',id) like "%like%" OR suchtext like "%like%" OR en_suchtext like "%like%" OR geographie like "%like%" OR suchtext_emo like "%like%" OR jahreszeit like "%like%" OR diskrete_infos like "%like%" OR verwertungsrechte like "%like%" OR en_geographie like "%like%" OR en_suchtext_emo like "%like%" OR en_infos like "%like%" OR en_diskrete_infos like "%like%")<br />
 AND (CONCAT('fomov',id) like "%„sunny“%" OR suchtext like "%„sunny“%" OR en_suchtext like "%„sunny“%" OR geographie like "%„sunny“%" OR suchtext_emo like "%„sunny“%" OR jahreszeit like "%„sunny“%" OR diskrete_infos like "%„sunny“%" OR verwertungsrechte like "%„sunny“%" OR en_geographie like "%„sunny“%" OR en_suchtext_emo like "%„sunny“%" OR en_infos like "%„sunny“%" OR en_diskrete_infos like "%„sunny“%")<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