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 "%blühen-1%" OR (suchtext like "%b_ühen-1%"  OR suchtext like "%bl_¼hen-1%"  OR suchtext like "%blÃ_hen-1%"  OR suchtext like "%blü_en-1%"  OR suchtext like "%blüh_n-1%"  OR suchtext like "%blühe_-1%"  OR suchtext like "%blühen_1%"  OR suchtext like "%blühen-_%" ) OR (en_suchtext like "%b_ühen-1%"  OR en_suchtext like "%bl_¼hen-1%"  OR en_suchtext like "%blÃ_hen-1%"  OR en_suchtext like "%blü_en-1%"  OR en_suchtext like "%blüh_n-1%"  OR en_suchtext like "%blühe_-1%"  OR en_suchtext like "%blühen_1%"  OR en_suchtext like "%blühen-_%" ) OR (geographie like "%b_ühen-1%"  OR geographie like "%bl_¼hen-1%"  OR geographie like "%blÃ_hen-1%"  OR geographie like "%blü_en-1%"  OR geographie like "%blüh_n-1%"  OR geographie like "%blühe_-1%"  OR geographie like "%blühen_1%"  OR geographie like "%blühen-_%" ) OR (suchtext_emo like "%b_ühen-1%"  OR suchtext_emo like "%bl_¼hen-1%"  OR suchtext_emo like "%blÃ_hen-1%"  OR suchtext_emo like "%blü_en-1%"  OR suchtext_emo like "%blüh_n-1%"  OR suchtext_emo like "%blühe_-1%"  OR suchtext_emo like "%blühen_1%"  OR suchtext_emo like "%blühen-_%" ) OR (jahreszeit like "%b_ühen-1%"  OR jahreszeit like "%bl_¼hen-1%"  OR jahreszeit like "%blÃ_hen-1%"  OR jahreszeit like "%blü_en-1%"  OR jahreszeit like "%blüh_n-1%"  OR jahreszeit like "%blühe_-1%"  OR jahreszeit like "%blühen_1%"  OR jahreszeit like "%blühen-_%" ) OR (diskrete_infos like "%b_ühen-1%"  OR diskrete_infos like "%bl_¼hen-1%"  OR diskrete_infos like "%blÃ_hen-1%"  OR diskrete_infos like "%blü_en-1%"  OR diskrete_infos like "%blüh_n-1%"  OR diskrete_infos like "%blühe_-1%"  OR diskrete_infos like "%blühen_1%"  OR diskrete_infos like "%blühen-_%" ) OR (verwertungsrechte like "%b_ühen-1%"  OR verwertungsrechte like "%bl_¼hen-1%"  OR verwertungsrechte like "%blÃ_hen-1%"  OR verwertungsrechte like "%blü_en-1%"  OR verwertungsrechte like "%blüh_n-1%"  OR verwertungsrechte like "%blühe_-1%"  OR verwertungsrechte like "%blühen_1%"  OR verwertungsrechte like "%blühen-_%" ) OR (en_geographie like "%b_ühen-1%"  OR en_geographie like "%bl_¼hen-1%"  OR en_geographie like "%blÃ_hen-1%"  OR en_geographie like "%blü_en-1%"  OR en_geographie like "%blüh_n-1%"  OR en_geographie like "%blühe_-1%"  OR en_geographie like "%blühen_1%"  OR en_geographie like "%blühen-_%" ) OR (en_suchtext_emo like "%b_ühen-1%"  OR en_suchtext_emo like "%bl_¼hen-1%"  OR en_suchtext_emo like "%blÃ_hen-1%"  OR en_suchtext_emo like "%blü_en-1%"  OR en_suchtext_emo like "%blüh_n-1%"  OR en_suchtext_emo like "%blühe_-1%"  OR en_suchtext_emo like "%blühen_1%"  OR en_suchtext_emo like "%blühen-_%" ) OR (en_infos like "%b_ühen-1%"  OR en_infos like "%bl_¼hen-1%"  OR en_infos like "%blÃ_hen-1%"  OR en_infos like "%blü_en-1%"  OR en_infos like "%blüh_n-1%"  OR en_infos like "%blühe_-1%"  OR en_infos like "%blühen_1%"  OR en_infos like "%blühen-_%" ) OR (en_diskrete_infos like "%b_ühen-1%"  OR en_diskrete_infos like "%bl_¼hen-1%"  OR en_diskrete_infos like "%blÃ_hen-1%"  OR en_diskrete_infos like "%blü_en-1%"  OR en_diskrete_infos like "%blüh_n-1%"  OR en_diskrete_infos like "%blühe_-1%"  OR en_diskrete_infos like "%blühen_1%"  OR en_diskrete_infos like "%blühen-_%" ))<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