Pavel S. Yuriev



 
| +7 (495) 719-09-71




( )



  • () = 4
  • = 0

Curriculum Vitae

22-28 2015 ..


__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 > 2020 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 > 2020) 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 > 2020 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 > 2020) 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 > 2020 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 > 2020) 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 > 2020 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 > 2020) ORDER BY name,name2,seq
SQL Error: at /home/shef/test.fnisc.ru/html/dreamedit/includes/class.Persons.php line 207
Array
(
    [code] => 0
    [message] => 
    [query] => SELECT * FROM
							(SELECT DISTINCT '2' AS prnd_type,kurs.fio,kurs.name AS kursname,kurs.institute,kurs.type AS type,' 'AS doclad,' ' AS conferenc
							FROM inter2009.prnd_list_kurs_22 AS kurs WHERE fio=526 AND (kurs.type=15 OR kurs.type=23) AND year=2021
							UNION
							SELECT DISTINCT '1' AS prnd_type,conf.fio,' ',' ',IF((conf.type=9 OR conf.type=11),1,2) AS type,
							conf.name,conf.conferenc FROM inter2009.prnd_list_conf_22 AS conf
							WHERE fio=526 AND (conf.type=11 OR conf.type=9 OR conf.type=10 OR conf.type=12) AND year=2021) AS t
							ORDER BY t.prnd_type,t.type,t.kursname,t.doclad
							 
    [context] => /home/shef/test.fnisc.ru/html/dreamedit/includes/class.Persons.php line 207
)