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



Магранов Алексей Сергеевич


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

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

  • В РИНЦ: (AuthorID: 671150)
  • В ORCID: (ORCID Id: 0000-0002-5138-0950)
  • В Web of Science (ResearcherId: AFR-7213-2022)



  • 2022



    Представления о роли государства и отношение к закону молодежи Юга России // Гуманитарий Юга России. 2022. № 1. С. 134-149

    2021



    Адаптация учебных мигрантов в российских вузах: современные научные подходы и мнения иностранных студентов // Гуманитарий Юга России. 2021. № 6. С. 174-185


    Филоненко В. И., Магранов А. С.
    Образ Великой Отечественной войны в представлениях современного российского студенчества // Социологические исследования. 2021. № 5, C. 148-149


    Магранов А. С., Печкуров И. В., Чжао Дань
    Образ России в представлениях учебных мигрантов как фактор их адаптации к новой социокультурной среде (на примере иностранных студентов ЮФУ) // Вестник Южно-Российского государственного технического университета. Серия: Социально-экономические науки. 2021. Т. 14, № 6. С. 94–103.


    Особенности выбора страны и вуза учебными мигрантами (на примере иностранных студентов ЮФУ) // Гуманитарий Юга России. 2021. № 5. С. 109-121


    Патриотическая самоидентификация и отношение к протестной активности в сознании студенческой молодежи Ростовской области // Власть. 2021. № 3. С. 175-180


    Представления современных студентов о роли СССР в победе в Великой Отечественной войне: опыт социологического исследования // Власть. 2021. № 6. С. 218-222

    2020



    Влияние качества аудиовизуальной среды города на формирование ценностных установок молодежи. Часть 2 // Власть. 2020. № 1. С. 139-144

    2019



    Влияние качества аудиовизуальной среды города на формирование ценностных установок молодежи. Часть 1 // Власть. 2019. № 6. С. 238-243


    Филоненко В. И., Магранов А. С., Киенко Т. С.
    Образ жизни и отношение к здоровью российских студентов // Социологические исследования. 2019. № 8, C. 164-166


    Роль школы в формировании гражданской активности студенческой молодежи вузов Дона // Власть. 2019. № 1. С. 96-103

    2018



    Магранов А. С., Деточенко Л. С.
    Гражданская идентичность современной студенческой молодежи: особенности и факторы трансформации // Социологические исследования. 2018. № 8, C. 108-116


    Филоненко В. И., Магранов А. С.
    К вопросу о гражданско-патриотическом воспитании молодежи // Социологические исследования. 2018. № 11, C. 162-165

    2017



    Общественно-политическая активность студентов вузов Ростовской области // Власть. 2017. № 6. С. 24-32


    Особенности и противоречия профессиональной социализации современной студенческой молодежи: итоги межрегионального социологического исследования // Власть. 2017. № 5. С. 18-28


    Социально-экономическая ситуация в России: мнения и оценки современного студенчества // Власть. 2017. № 10. С. 72-82

    2015



    Филоненко В. И., Магранов А. С., Понеделков А. В.
    Демографическая политика России в оценках населения и экспертов Ростовской области // Социологические исследования. 2015. № 9, C. 74-79



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



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

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

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