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=0 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=0 ORDER BY au.seq