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



Сергеева Ольга Вячеславовна

Сергеева Ольга Вячеславовна


__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
Всего публикаций: 10

Профили автора:

  • В РИНЦ: (AuthorID: 433656)
  • В ORCID: (ORCID Id: 0000-0002-8093-609X)
  • В Web of Science (ResearcherId: C-2692-2016)
  • 2021



    Сергеева О. В., Мизиряк Н.А.
    Постапокалиптическая среда и ее переосмысление в игре Death Stranding // Вестник Санкт-Петербургского университета. Социология. 2021. Т. 14. Вып. 4. С. 330–343.


    Сергеева О. В.
    Становление социальных исследований инфраструктур (С. Л. Стар, Дж. Боукер, Б. Ларкин) // Петербургская социология сегодня. 2021. № 15. С. 54-70.

    2020



    Сергеева О. В., Мизиряк Н. А.
    Игровые компьютерные среды и меняющийся опыт городских коммуникаций // Logos et Praxis. 2020. Т. 19. № 4. С. 51-60.


    Сергеева О. В., Орех Е. А.
    (2020) Компьютерные игры и культурное потребление горожан. Журнал социологии и социальной антропологии, 23(1): 65–88.


    Sergeyeva O., Bogomiagkova E., Orekh E., Kolesnik N. (2020) Gamification of Civic Engagement in Smart Cities (New Russian Practices). In: Ben Ahmed M., Boudhir A., Santos D., El Aroussi M., Karas İ. (eds) Innovations in Smart Cities Applications Edition 3. SCA 2019. Lecture Notes in Intelligent Transportation and Infrastructure. Springer, Cham. Р. 53-62.

    2019



    Сергеева О. В., Лактюхина Е.Г.
    Социальные аспекты цифровизации детской городской мобильности // Журнал исследований социальной политики. 2019. Т. 17. № 4. С. 507-524.

    2018



    Sergeyeva O., Tsareva A., Zinoveva N., Kononova O. Social Skills Amongst MMORPG-Gamers: Empirical Study. SHS Web Conf., 50 (2018) 01008

    2017



    Сергеева О. В., Царева А.В., Мизиряк Н. А.
    Встретимся в дополненной реальности...: социальные компетенции игроков в многопользовательские онлайн-игры // Logos et Praxis. 2017. Т. 16. № 4. С. 51-63

    2010



    О. Сергеева Вопреки социальности модерна (с.60-64) // Власть. 2010. №4.

    2009



    О. Сергеева. Политическая институционализация воздействия российской власти на малый бизнес // Власть. 2009. №11.



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



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

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

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