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 "%massagemädchen%" OR (suchtext like "%M_ssageMädchen%"  OR suchtext like "%Ma_sageMädchen%"  OR suchtext like "%Mas_ageMädchen%"  OR suchtext like "%Mass_geMädchen%"  OR suchtext like "%Massa_eMädchen%"  OR suchtext like "%Massag_Mädchen%"  OR suchtext like "%Massage_ädchen%"  OR suchtext like "%MassageM_¤dchen%"  OR suchtext like "%MassageMÃ_dchen%"  OR suchtext like "%MassageMä_chen%"  OR suchtext like "%MassageMäd_hen%"  OR suchtext like "%MassageMädc_en%"  OR suchtext like "%MassageMädch_n%"  OR suchtext like "%MassageMädche_%" ) OR (en_suchtext like "%M_ssageMädchen%"  OR en_suchtext like "%Ma_sageMädchen%"  OR en_suchtext like "%Mas_ageMädchen%"  OR en_suchtext like "%Mass_geMädchen%"  OR en_suchtext like "%Massa_eMädchen%"  OR en_suchtext like "%Massag_Mädchen%"  OR en_suchtext like "%Massage_ädchen%"  OR en_suchtext like "%MassageM_¤dchen%"  OR en_suchtext like "%MassageMÃ_dchen%"  OR en_suchtext like "%MassageMä_chen%"  OR en_suchtext like "%MassageMäd_hen%"  OR en_suchtext like "%MassageMädc_en%"  OR en_suchtext like "%MassageMädch_n%"  OR en_suchtext like "%MassageMädche_%" ) OR (geographie like "%M_ssageMädchen%"  OR geographie like "%Ma_sageMädchen%"  OR geographie like "%Mas_ageMädchen%"  OR geographie like "%Mass_geMädchen%"  OR geographie like "%Massa_eMädchen%"  OR geographie like "%Massag_Mädchen%"  OR geographie like "%Massage_ädchen%"  OR geographie like "%MassageM_¤dchen%"  OR geographie like "%MassageMÃ_dchen%"  OR geographie like "%MassageMä_chen%"  OR geographie like "%MassageMäd_hen%"  OR geographie like "%MassageMädc_en%"  OR geographie like "%MassageMädch_n%"  OR geographie like "%MassageMädche_%" ) OR (suchtext_emo like "%M_ssageMädchen%"  OR suchtext_emo like "%Ma_sageMädchen%"  OR suchtext_emo like "%Mas_ageMädchen%"  OR suchtext_emo like "%Mass_geMädchen%"  OR suchtext_emo like "%Massa_eMädchen%"  OR suchtext_emo like "%Massag_Mädchen%"  OR suchtext_emo like "%Massage_ädchen%"  OR suchtext_emo like "%MassageM_¤dchen%"  OR suchtext_emo like "%MassageMÃ_dchen%"  OR suchtext_emo like "%MassageMä_chen%"  OR suchtext_emo like "%MassageMäd_hen%"  OR suchtext_emo like "%MassageMädc_en%"  OR suchtext_emo like "%MassageMädch_n%"  OR suchtext_emo like "%MassageMädche_%" ) OR (jahreszeit like "%M_ssageMädchen%"  OR jahreszeit like "%Ma_sageMädchen%"  OR jahreszeit like "%Mas_ageMädchen%"  OR jahreszeit like "%Mass_geMädchen%"  OR jahreszeit like "%Massa_eMädchen%"  OR jahreszeit like "%Massag_Mädchen%"  OR jahreszeit like "%Massage_ädchen%"  OR jahreszeit like "%MassageM_¤dchen%"  OR jahreszeit like "%MassageMÃ_dchen%"  OR jahreszeit like "%MassageMä_chen%"  OR jahreszeit like "%MassageMäd_hen%"  OR jahreszeit like "%MassageMädc_en%"  OR jahreszeit like "%MassageMädch_n%"  OR jahreszeit like "%MassageMädche_%" ) OR (diskrete_infos like "%M_ssageMädchen%"  OR diskrete_infos like "%Ma_sageMädchen%"  OR diskrete_infos like "%Mas_ageMädchen%"  OR diskrete_infos like "%Mass_geMädchen%"  OR diskrete_infos like "%Massa_eMädchen%"  OR diskrete_infos like "%Massag_Mädchen%"  OR diskrete_infos like "%Massage_ädchen%"  OR diskrete_infos like "%MassageM_¤dchen%"  OR diskrete_infos like "%MassageMÃ_dchen%"  OR diskrete_infos like "%MassageMä_chen%"  OR diskrete_infos like "%MassageMäd_hen%"  OR diskrete_infos like "%MassageMädc_en%"  OR diskrete_infos like "%MassageMädch_n%"  OR diskrete_infos like "%MassageMädche_%" ) OR (verwertungsrechte like "%M_ssageMädchen%"  OR verwertungsrechte like "%Ma_sageMädchen%"  OR verwertungsrechte like "%Mas_ageMädchen%"  OR verwertungsrechte like "%Mass_geMädchen%"  OR verwertungsrechte like "%Massa_eMädchen%"  OR verwertungsrechte like "%Massag_Mädchen%"  OR verwertungsrechte like "%Massage_ädchen%"  OR verwertungsrechte like "%MassageM_¤dchen%"  OR verwertungsrechte like "%MassageMÃ_dchen%"  OR verwertungsrechte like "%MassageMä_chen%"  OR verwertungsrechte like "%MassageMäd_hen%"  OR verwertungsrechte like "%MassageMädc_en%"  OR verwertungsrechte like "%MassageMädch_n%"  OR verwertungsrechte like "%MassageMädche_%" ) OR (en_geographie like "%M_ssageMädchen%"  OR en_geographie like "%Ma_sageMädchen%"  OR en_geographie like "%Mas_ageMädchen%"  OR en_geographie like "%Mass_geMädchen%"  OR en_geographie like "%Massa_eMädchen%"  OR en_geographie like "%Massag_Mädchen%"  OR en_geographie like "%Massage_ädchen%"  OR en_geographie like "%MassageM_¤dchen%"  OR en_geographie like "%MassageMÃ_dchen%"  OR en_geographie like "%MassageMä_chen%"  OR en_geographie like "%MassageMäd_hen%"  OR en_geographie like "%MassageMädc_en%"  OR en_geographie like "%MassageMädch_n%"  OR en_geographie like "%MassageMädche_%" ) OR (en_suchtext_emo like "%M_ssageMädchen%"  OR en_suchtext_emo like "%Ma_sageMädchen%"  OR en_suchtext_emo like "%Mas_ageMädchen%"  OR en_suchtext_emo like "%Mass_geMädchen%"  OR en_suchtext_emo like "%Massa_eMädchen%"  OR en_suchtext_emo like "%Massag_Mädchen%"  OR en_suchtext_emo like "%Massage_ädchen%"  OR en_suchtext_emo like "%MassageM_¤dchen%"  OR en_suchtext_emo like "%MassageMÃ_dchen%"  OR en_suchtext_emo like "%MassageMä_chen%"  OR en_suchtext_emo like "%MassageMäd_hen%"  OR en_suchtext_emo like "%MassageMädc_en%"  OR en_suchtext_emo like "%MassageMädch_n%"  OR en_suchtext_emo like "%MassageMädche_%" ) OR (en_infos like "%M_ssageMädchen%"  OR en_infos like "%Ma_sageMädchen%"  OR en_infos like "%Mas_ageMädchen%"  OR en_infos like "%Mass_geMädchen%"  OR en_infos like "%Massa_eMädchen%"  OR en_infos like "%Massag_Mädchen%"  OR en_infos like "%Massage_ädchen%"  OR en_infos like "%MassageM_¤dchen%"  OR en_infos like "%MassageMÃ_dchen%"  OR en_infos like "%MassageMä_chen%"  OR en_infos like "%MassageMäd_hen%"  OR en_infos like "%MassageMädc_en%"  OR en_infos like "%MassageMädch_n%"  OR en_infos like "%MassageMädche_%" ) OR (en_diskrete_infos like "%M_ssageMädchen%"  OR en_diskrete_infos like "%Ma_sageMädchen%"  OR en_diskrete_infos like "%Mas_ageMädchen%"  OR en_diskrete_infos like "%Mass_geMädchen%"  OR en_diskrete_infos like "%Massa_eMädchen%"  OR en_diskrete_infos like "%Massag_Mädchen%"  OR en_diskrete_infos like "%Massage_ädchen%"  OR en_diskrete_infos like "%MassageM_¤dchen%"  OR en_diskrete_infos like "%MassageMÃ_dchen%"  OR en_diskrete_infos like "%MassageMä_chen%"  OR en_diskrete_infos like "%MassageMäd_hen%"  OR en_diskrete_infos like "%MassageMädc_en%"  OR en_diskrete_infos like "%MassageMädch_n%"  OR en_diskrete_infos like "%MassageMädche_%" ))<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