Query failed 
    SELECT DISTINCT i.year,i.number,i.issue_id,a.submission_id,IF(IFNULL(aa.setting_value,'')='',s.setting_value,aa.setting_value) AS title,
	a.pages,doi.setting_value AS doi,
	IFNULL(edn.setting_value,'') AS edn,
	i.volume,
	SUBSTRING_INDEX(TRIM(IFNULL(ausf.setting_value,'')),' ',1) AS first_name,
	SUBSTRING_INDEX(TRIM(IFNULL(ausf.setting_value,'')),' ',-1) AS middle_name,
	
	IFNULL(ausl.setting_value,'') AS last_name,
	au.email AS email,
	s.setting_value AS rubric,
	 a2.setting_value AS abstract,ss.hide_title,ss.hide_author,a.hide_author AS ha,a.pages,
	 a.status, CONCAT(a.submission_id,'-',f.file_id,'-','1-PB.pdf') AS file_name,  (SELECT IF(x.file_stage<>7,CONCAT('s',original_file_name),CONCAT('p',original_file_name)) AS file_name 
			FROM (SELECT * FROM .submission_files AS f 
			WHERE f.submission_id=2160  ORDER BY f.file_stage DESC LIMIT 1) AS x ) AS ffile_name,  j.journal_id,j.setting_value AS journal_name,
	 aus.setting_value AS affiliation,aus2.setting_value AS biography,
     ausen.setting_value AS affiliation_en,aus2en.setting_value AS biography_en	,
   gal.assoc_id, role.setting_value AS role,role2.setting_value AS role2,jj.path    
	
	FROM .submissions AS a 
	INNER JOIN .`published_submissions`AS p ON p.submission_id=a.submission_id 
    INNER JOIN .issues AS i ON i.issue_id=p.issue_id AND i.published=1	
	INNER JOIN .journal_settings AS j ON j.journal_id=i.journal_id AND j.locale='ru_RU' AND j.setting_name='name' 
	INNER JOIN .journals AS jj ON jj.journal_id=j.journal_id
	LEFT OUTER JOIN .submission_files AS f ON f.submission_id=a.submission_id 
	
	INNER JOIN .section_settings AS s ON s.section_id=a.section_id AND s.locale='ru_RU' AND s.setting_name='title' 
	INNER JOIN .sections AS ss ON ss.section_id=a.section_id 
	INNER JOIN .submission_settings AS aa ON aa.submission_id=a.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' 
	INNER JOIN .submission_settings AS a2 ON a2.submission_id=a.submission_id AND a2.setting_name='abstract' AND a2.locale='ru_RU' 
	LEFT OUTER JOIN .submission_settings AS doi ON doi.submission_id=a.submission_id AND doi.setting_name='pub-id::doi' 
	LEFT OUTER JOIN .submission_settings AS edn ON edn.submission_id=a.submission_id AND edn.setting_name='coverage' AND edn.locale='ru_RU'
	INNER JOIN .authors AS au ON au.submission_id=aa.submission_id 
	LEFT OUTER JOIN .author_settings AS ausf ON ausf.author_id=au.author_id AND ausf.locale='ru_RU' AND ausf.setting_name='givenName'
	LEFT OUTER JOIN .author_settings AS ausl ON ausl.author_id=au.author_id AND ausl.locale='ru_RU' AND ausl.setting_name='familyName'
	INNER JOIN .user_group_settings AS role ON role.user_group_id=au.user_group_id AND role.setting_name='name' AND role.locale='ru_RU' 
	INNER JOIN .user_group_settings AS role2 ON role2.user_group_id=au.user_group_id AND role2.setting_name='abbrev' AND role2.locale='ru_RU' 
	INNER JOIN .author_settings AS aus ON aus.author_id=au.author_id AND aus.locale='ru_RU' AND aus.setting_name='affiliation'
	INNER JOIN .author_settings AS aus2 ON aus2.author_id=au.author_id AND aus2.locale='ru_RU' AND aus2.setting_name='biography'
	LEFT OUTER JOIN .author_settings AS ausen ON ausen.author_id=au.author_id AND ausen.locale='en_US' AND ausen.setting_name='affiliation'
	LEFT OUTER JOIN .author_settings AS aus2en ON aus2en.author_id=au.author_id AND aus2en.locale='en_US' AND aus2en.setting_name='biography'		LEFT OUTER JOIN .submission_files AS gal ON gal.submission_id=a.submission_id AND gal.file_stage=10  	WHERE a.submission_id=2160 ORDER BY au.seq