Список публикаций



Иванов Николай Борисович


__SELECT 'ojs' AS 'type', a.submission_id AS page_id,aa.setting_value AS name, CONCAT(' // ',j.setting_value,'. ',i.year,'. № ',number,'. С. ',IFNULL(a.pages,'')) AS name2, CONCAT(IFNULL(au1.setting_value,IFNULL(au.last_name,'')),' ',SUBSTRING(IFNULL(au2.setting_value,IFNULL(au.first_name,'')),1,1),'. ', SUBSTRING(IFNULL(au3.setting_value,IFNULL(au.middle_name,'')),1,1),'.') AS avtor,au.seq, i.year,'*' AS visible, '' AS lang ,doi.setting_value AS doi, CONCAT('http://jour.fnisc.ru/index.php/',jj.path,'/article/view/',a.submission_id,'/',gal.assoc_id) AS filename FROM ojs3.authors AS au LEFT OUTER JOIN ojs3.author_settings AS au1 ON au1.author_id=au.author_id AND au1.setting_name='lastName' AND au1.locale='ru_RU' LEFT OUTER JOIN ojs3.author_settings AS au2 ON au2.author_id=au.author_id AND au2.setting_name='firstName' AND au2.locale='ru_RU' LEFT OUTER JOIN ojs3.author_settings AS au3 ON au3.author_id=au.author_id AND au3.setting_name='middleName' AND au3.locale='ru_RU' INNER JOIN ojs3.submission_settings AS aa ON au.submission_id=aa.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3.submissions AS a ON aa.submission_id =a.submission_id INNER JOIN ojs3.`published_submissions`AS p ON p.submission_id=a.submission_id INNER JOIN ojs3.issues AS i ON i.issue_id=p.issue_id INNER JOIN ojs3.journal_settings AS j ON j.journal_id=i.journal_id AND j.setting_name='name' AND j.locale='ru_RU' AND j.journal_id<>7 INNER JOIN ojs3.journals AS jj ON jj.journal_id=j.journal_id LEFT OUTER JOIN ojs3.submission_settings AS doi ON doi.submission_id=a.submission_id AND doi.setting_name='pub-id::doi' LEFT OUTER JOIN ojs3.submission_files AS gal ON gal.submission_id=a.submission_id AND IFNULL(assoc_type,0)<>0 AND file_stage=10 WHERE a.status=3 AND year > 1900 AND a.submission_id IN (SELECT a.submission_id FROM ojs3.authors AS au INNER JOIN ojs3.author_settings AS au1 ON au1.author_id=au.author_id AND au1.setting_name='lastName' AND au1.locale='ru_RU' INNER JOIN ojs3.author_settings AS au2 ON au2.author_id=au.author_id AND au2.setting_name='firstName' AND au2.locale='ru_RU' INNER JOIN ojs3.author_settings AS au3 ON au3.author_id=au.author_id AND au3.setting_name='middleName' AND au3.locale='ru_RU' INNER JOIN ojs3.submission_settings AS aa ON au.submission_id=aa.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3.submissions AS a ON aa.submission_id =a.submission_id INNER JOIN ojs3.`published_submissions`AS p ON p.submission_id=a.submission_id WHERE a.status=3 AND IFNULL(au1.setting_value,au.last_name)='Иванов' AND IFNULL(au2.setting_value,au.first_name)='Николай' AND IFNULL(au3.setting_value,au.middle_name)='Борисович' AND year > 1900 ) UNION ALL SELECT 'ojs3_inter' AS 'type', a.submission_id AS page_id,aa.setting_value AS name, CONCAT(' // ',j.setting_value,'. ',i.year,'. № ',number,'. С. ',IFNULL(a.pages,'')) AS name2, CONCAT(IFNULL(au1.setting_value,IFNULL(au.last_name,'')),' ',SUBSTRING(IFNULL(au2.setting_value,IFNULL(au.first_name,'')),1,1),'. ', SUBSTRING(IFNULL(au3.setting_value,IFNULL(au.middle_name,'')),1,1),'.') AS avtor,au.seq, i.year,'*' AS visible, '' AS lang ,doi.setting_value AS doi, CONCAT('https://www.inter-fnisc.ru/index.php/',jj.path,'/article/view/',a.submission_id,'/',gal.assoc_id) AS filename FROM ojs3_inter.authors AS au LEFT OUTER JOIN ojs3_inter.author_settings AS au1 ON au1.author_id=au.author_id AND au1.setting_name='lastName' AND au1.locale='ru_RU' LEFT OUTER JOIN ojs3_inter.author_settings AS au2 ON au2.author_id=au.author_id AND au2.setting_name='firstName' AND au2.locale='ru_RU' LEFT OUTER JOIN ojs3_inter.author_settings AS au3 ON au3.author_id=au.author_id AND au3.setting_name='middleName' AND au3.locale='ru_RU' INNER JOIN ojs3_inter.submission_settings AS aa ON au.submission_id=aa.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3_inter.submissions AS a ON aa.submission_id =a.submission_id INNER JOIN ojs3_inter.`published_submissions`AS p ON p.submission_id=a.submission_id INNER JOIN ojs3_inter.issues AS i ON i.issue_id=p.issue_id INNER JOIN ojs3_inter.journal_settings AS j ON j.journal_id=i.journal_id AND j.setting_name='name' AND j.locale='ru_RU' AND j.journal_id= 7 INNER JOIN ojs3_inter.journals AS jj ON jj.journal_id=j.journal_id LEFT OUTER JOIN ojs3_inter.submission_settings AS doi ON doi.submission_id=a.submission_id AND doi.setting_name='pub-id::doi' LEFT OUTER JOIN ojs3_inter.submission_files AS gal ON gal.submission_id=a.submission_id AND IFNULL(assoc_type,0)<>0 AND file_stage=10 WHERE a.status=3 AND year > 1900 AND a.submission_id IN (SELECT a.submission_id FROM ojs3_inter.authors AS au INNER JOIN ojs3_inter.author_settings AS au1 ON au1.author_id=au.author_id AND au1.setting_name='lastName' AND au1.locale='ru_RU' INNER JOIN ojs3_inter.author_settings AS au2 ON au2.author_id=au.author_id AND au2.setting_name='firstName' AND au2.locale='ru_RU' INNER JOIN ojs3_inter.author_settings AS au3 ON au3.author_id=au.author_id AND au3.setting_name='middleName' AND au3.locale='ru_RU' INNER JOIN ojs3_inter.submission_settings AS aa ON au.submission_id=aa.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3_inter.submissions AS a ON aa.submission_id =a.submission_id INNER JOIN ojs3_inter.`published_submissions`AS p ON p.submission_id=a.submission_id WHERE a.status=3 AND IFNULL(au1.setting_value,au.last_name)='Иванов' AND IFNULL(au2.setting_value,au.first_name)='Николай' AND IFNULL(au3.setting_value,au.middle_name)='Борисович' AND year > 1900 ) UNION ALL SELECT 'ojs3_science' AS 'type', a.submission_id AS page_id,aa.setting_value AS name, CONCAT(' // ',j.setting_value,'. ',i.year,'. № ',number,'. С. ',IFNULL(a.pages,'')) AS name2, CONCAT(IFNULL(au1.setting_value,IFNULL(au.last_name,'')),' ',SUBSTRING(IFNULL(au2.setting_value,IFNULL(au.first_name,'')),1,1),'. ', SUBSTRING(IFNULL(au3.setting_value,IFNULL(au.middle_name,'')),1,1),'.') AS avtor,au.seq, i.year,'*' AS visible, '' AS lang ,doi.setting_value AS doi, CONCAT('https://www.inter-fnisc.ru/index.php/',jj.path,'/article/view/',a.submission_id,'/',gal.assoc_id) AS filename FROM ojs3_science.authors AS au LEFT OUTER JOIN ojs3_science.author_settings AS au1 ON au1.author_id=au.author_id AND au1.setting_name='lastName' AND au1.locale='ru_RU' LEFT OUTER JOIN ojs3_science.author_settings AS au2 ON au2.author_id=au.author_id AND au2.setting_name='firstName' AND au2.locale='ru_RU' LEFT OUTER JOIN ojs3_science.author_settings AS au3 ON au3.author_id=au.author_id AND au3.setting_name='middleName' AND au3.locale='ru_RU' INNER JOIN ojs3_science.submission_settings AS aa ON au.submission_id=aa.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3_science.submissions AS a ON aa.submission_id =a.submission_id INNER JOIN ojs3_science.`published_submissions`AS p ON p.submission_id=a.submission_id INNER JOIN ojs3_science.issues AS i ON i.issue_id=p.issue_id INNER JOIN ojs3_science.journal_settings AS j ON j.journal_id=i.journal_id AND j.setting_name='name' AND j.locale='ru_RU' AND j.journal_id= 9 INNER JOIN ojs3_science.journals AS jj ON jj.journal_id=j.journal_id LEFT OUTER JOIN ojs3_science.submission_settings AS doi ON doi.submission_id=a.submission_id AND doi.setting_name='pub-id::doi' LEFT OUTER JOIN ojs3_science.submission_files AS gal ON gal.submission_id=a.submission_id AND IFNULL(assoc_type,0)<>0 AND file_stage=10 WHERE a.status=3 AND year > 1900 AND a.submission_id IN (SELECT a.submission_id FROM ojs3_science.authors AS au INNER JOIN ojs3_science.author_settings AS au1 ON au1.author_id=au.author_id AND au1.setting_name='lastName' AND au1.locale='ru_RU' INNER JOIN ojs3_science.author_settings AS au2 ON au2.author_id=au.author_id AND au2.setting_name='firstName' AND au2.locale='ru_RU' INNER JOIN ojs3_science.author_settings AS au3 ON au3.author_id=au.author_id AND au3.setting_name='middleName' AND au3.locale='ru_RU' INNER JOIN ojs3_science.submission_settings AS aa ON au.submission_id=aa.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3_science.submissions AS a ON aa.submission_id =a.submission_id INNER JOIN ojs3_science.`published_submissions`AS p ON p.submission_id=a.submission_id WHERE a.status=3 AND IFNULL(au1.setting_value,au.last_name)='Иванов' AND IFNULL(au2.setting_value,au.first_name)='Николай' AND IFNULL(au3.setting_value,au.middle_name)='Борисович' AND year > 1900 ) UNION ALL SELECT 'ojs3_scs' AS 'type', a.submission_id AS page_id,aa.setting_value AS name, CONCAT(' // ',j.setting_value,'. ',i.year,'. № ',number,'. С. ',IFNULL(a.pages,'')) AS name2, CONCAT(IFNULL(au1.setting_value,IFNULL(au.last_name,'')),' ',SUBSTRING(IFNULL(au2.setting_value,IFNULL(au.first_name,'')),1,1),'. ', SUBSTRING(IFNULL(au3.setting_value,IFNULL(au.middle_name,'')),1,1),'.') AS avtor,au.seq, i.year,'*' AS visible, '' AS lang ,doi.setting_value AS doi, CONCAT('http://www.journal_scs.ru/index.php/',jj.path,'/article/view/',a.submission_id,'/',gal.assoc_id) AS filename FROM ojs3_scs.authors AS au LEFT OUTER JOIN ojs3_scs.author_settings AS au1 ON au1.author_id=au.author_id AND au1.setting_name='lastName' AND au1.locale='ru_RU' LEFT OUTER JOIN ojs3_scs.author_settings AS au2 ON au2.author_id=au.author_id AND au2.setting_name='firstName' AND au2.locale='ru_RU' LEFT OUTER JOIN ojs3_scs.author_settings AS au3 ON au3.author_id=au.author_id AND au3.setting_name='middleName' AND au3.locale='ru_RU' INNER JOIN ojs3_scs.submission_settings AS aa ON au.submission_id=aa.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3_scs.submissions AS a ON aa.submission_id =a.submission_id INNER JOIN ojs3_scs.`published_submissions`AS p ON p.submission_id=a.submission_id INNER JOIN ojs3_scs.issues AS i ON i.issue_id=p.issue_id INNER JOIN ojs3_scs.journal_settings AS j ON j.journal_id=i.journal_id AND j.setting_name='name' AND j.locale='ru_RU' AND j.journal_id= 12 INNER JOIN ojs3_scs.journals AS jj ON jj.journal_id=j.journal_id LEFT OUTER JOIN ojs3_scs.submission_settings AS doi ON doi.submission_id=a.submission_id AND doi.setting_name='pub-id::doi' LEFT OUTER JOIN ojs3_scs.submission_files AS gal ON gal.submission_id=a.submission_id AND IFNULL(assoc_type,0)<>0 AND file_stage=10 WHERE a.status=3 AND year > 1900 AND a.submission_id IN (SELECT a.submission_id FROM ojs3_scs.authors AS au INNER JOIN ojs3_scs.author_settings AS au1 ON au1.author_id=au.author_id AND au1.setting_name='lastName' AND au1.locale='ru_RU' INNER JOIN ojs3_scs.author_settings AS au2 ON au2.author_id=au.author_id AND au2.setting_name='firstName' AND au2.locale='ru_RU' INNER JOIN ojs3_scs.author_settings AS au3 ON au3.author_id=au.author_id AND au3.setting_name='middleName' AND au3.locale='ru_RU' INNER JOIN ojs3_scs.submission_settings AS aa ON au.submission_id=aa.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3_scs.submissions AS a ON aa.submission_id =a.submission_id INNER JOIN ojs3_scs.`published_submissions`AS p ON p.submission_id=a.submission_id WHERE a.status=3 AND IFNULL(au1.setting_value,au.last_name)='Иванов' AND IFNULL(au2.setting_value,au.first_name)='Николай' AND IFNULL(au3.setting_value,au.middle_name)='Борисович' AND year > 1900 ) ORDER BY name,name2,seq
Всего публикаций: 5

2021



Иванов Н. Б., Малинов А. В., Ноговицин О. Н.
Русский логос – 2: Модерн – границы контроля (Обзор международной философской конференции) // Вопросы философии. 2021. № 1. С. 203–208.


Иванов Н. Б.
Язык идей и язык вещей: к особенности русского перевода // Византия, Европа, Россия: социальные практики и взаимосвязь духовных традиций. Архив конференции. Выпуск 1: материалы международной научной конференции (Санкт-Петербург, 1–2 октября 2021 г.) / Отв. ред. О.Н. Ноговицин; ФНИСЦ РАН; РХГА. — СПб.: Издательство РХГА, 2021. — С. 64-73.

2019



Иванов Н. Б., Ноговицин О. Н.
Рецензия на книгу: А.Г. Погоняйло Мышление и созерцание: материалы к лекциям по истории философии // Вопросы философии. 2019. № 1. С. 212-216.

2013



В.Н. Иванов Современная Россия: взгляд экспертов и поэта. М., 2012. Рец. Дмитриев А.В.; Yakovlev A. Roots of Terrorism in India (Social, Religious and Political). New Delhi, 2011. Рец. Сухарев А.И.) с.151 // Социологические исследования. 2013. №4

2003



В.Н. Иванов и А.С. Закалин; Пациорковский В.В., Петрова А.И., Пациорковская В.В. Использование SPSS в социологии. Учебное пособие в 3-х частях. М., 1998, 2000, 2002. Рец. О.В. Крухмалева, Н.Е. Савина) // Социологические исследования. 2003. №5



КОММЕНТАРИИ К ЭТОЙ СТРАНИЦЕ



rss подписаться на RSS ленту комментариев к этой странице

ОСТАВИТЬ КОММЕНТАРИЙ

Комментарии. Всего [0]: