Институт социологии
Российской академии наук

Власть. 2016. Том 24. № 7

SQL Error: at /home/shef/isras.ru/html/site_template/cmpl_tmp/ojs.html.php line 139
Array
(
    [code] => 0
    [message] => 
    [query] => SELECT DISTINCT i.year,i.number,i.issue_id,a.pages,IFNULL(ausf.setting_value,au.first_name) AS first_name,au.middle_name,
	CONCAT('
DOI: ','', 'https://doi.org/',adoi.setting_value,'') AS doi, CONCAT('
DOI: ','',' https://doi.org/',idoi.setting_value,'') AS idoi, IFNULL(ausl.setting_value,au.last_name) AS last_name, s.setting_value AS rubric, SUBSTRING_INDEX(SUBSTRING_INDEX(a.pages,'-',1),'. ',-1) AS sss, ss.hide_title,IFNULL(ss.hide_author,0) AS hide_author,IFNULL(a.hide_author,1) AS ha,a.pages,a.article_id AS article_id, IF (IFNULL(aa.setting_value,'')='',s.setting_value, aa.setting_value) AS title, IFNULL(per.id,0) AS persona_id , ausf.setting_value,au.submission_id, a.status FROM ojs.issues AS i LEFT OUTER JOIN ojs.issue_settings AS idoi ON idoi.issue_id=i.issue_id AND idoi.setting_name='pub-id::doi' INNER JOIN ojs.`published_articles`AS p ON p.issue_id=i.issue_id INNER JOIN ojs.articles AS a ON a.article_id=p.article_id INNER JOIN ojs.section_settings AS s ON s.section_id=a.section_id AND s.locale='ru_RU' AND s.setting_name='title' INNER JOIN ojs.sections AS ss ON ss.section_id=a.section_id INNER JOIN ojs.article_settings AS aa ON aa.article_id=p.article_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs.article_settings AS a2 ON a2.article_id=p.article_id AND a2.setting_name='abstract' AND a2.locale='ru_RU' INNER JOIN ojs.article_settings AS a3 ON a3.article_id=p.article_id AND a3.setting_name='subject' AND a3.locale='ru_RU' INNER JOIN ojs.authors AS au ON au.submission_id=a.article_id LEFT OUTER JOIN ojs.author_settings AS ausf ON ausf.author_id=au.author_id AND ausf.locale='ru_RU' AND ausf.setting_name='first_name' LEFT OUTER JOIN ojs.author_settings AS ausm ON ausm.author_id=au.author_id AND ausm.locale='ru_RU' AND ausm.setting_name='middle_name' LEFT OUTER JOIN ojs.author_settings AS ausl ON ausl.author_id=au.author_id AND ausl.locale='ru_RU' AND ausl.setting_name='last_name' LEFT OUTER JOIN isras2015.persona AS per ON per.surname=IFNULL(ausl.setting_value,au.last_name) AND per.fname=IFNULL(ausm.setting_value,au.middle_name) AND per.name=IFNULL(ausf.setting_value,au.first_name) AND per.id_podr<>329 LEFT OUTER JOIN ojs.article_files AS f ON f.file_id=a.submission_file_id LEFT OUTER JOIN ojs.article_settings AS adoi ON adoi.article_id=a.article_id AND adoi.setting_name='pub-id::doi' WHERE a.status=3 AND i.year=2016 AND i.number=7 AND i.journal_id=2 ORDER BY CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(a.pages,'-',1),'. ',-1) AS SIGNED) ASC ,p.article_id,au.seq ASC [context] => /home/shef/isras.ru/html/site_template/cmpl_tmp/ojs.html.php line 139 )