Historical Note
Main Fields of Research Activities
Directorate
Scientific Council
Leading Research Assistants
Services of institute
Contacts
Trade Union Committee
Laboratory of alkanotrophic microorganisms
Laboratory of microorganisms' adaptation
Laboratory of physiology and genetics of microorganisms
Laboratory of molecular microbiology and biotechnology
Laboratory of microorganisms' biochemical development
Laboratory of aquatic microbiology
Laboratory of ecological immunology
Laboratory of immunoregulation
Group of physical-chemical investigations
Regional collection of alkanotrophic microorganisms
Chair of microbiology and immunology
Search of Publications
2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 and earlier
Search of Developments
New materials
Ecology
Electrotechnology and material processing
Medicine
Search of Conferences
Planned and Past Conferences in 2020
Past Conferences in 2019
Past Conferences in 2018
Past Conferences in 2017
Past Conferences in 2016
Past Conferences in 2015
Past Conferences in 2014
Past Conferences in 2013
Past Conferences in 2012
Past Conferences in 2011
Past Conferences in 2010
Past Conferences in 2009
Past Conferences in 2008
Past Conferences in 2007
Past Conferences in 2006
Past Conferences in 2005
Past Conferences in 2004 and earlier
Papers of our Research Assictants
Library
Publishing Houses
Magazines
Other Libraries
Scientific Funds
Announcements
Specialities and Essential Elements
Documents
News 
About Us
Announcements
Competitions
Conferences
Links
Regulations
Specialities
Members
Documents of Competitors
Nearest Session
Contact Information
 
 Publications   Site Map     Language Switch to Russain Switch to English
 
Search of Publications
2020
2019
2018
2017
2016
2015
2014
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
1998
1997 and earlier


SELECT tbl238.FIO1_Name, tbl238.FIO1_ID,tbl239.FIO1_Name, tbl239.FIO1_ID,tbl240.FIO1_Name, tbl240.FIO1_ID,tbl241.FIO1_Name, tbl241.FIO1_ID,tbl242.FIO1_Name, tbl242.FIO1_ID,tbl243.FIO1_Name, tbl243.FIO1_ID,tbl244.FIO1_Name, tbl244.FIO1_ID,tbl245.FIO1_Name, tbl245.FIO1_ID,tbl246.FIO1_Name, tbl246.FIO1_ID,a.An1,a.Nazv,a.Izd,a.Mesto_p,a.Publ,a.Date, DATE_FORMAT(a.Date,'%Y'), DATE_FORMAT(a.Date,'%m'), DATE_FORMAT(a.Date,'%d'), DATE_FORMAT(a.Date,'%H'), DATE_FORMAT(a.Date,'%i'), DATE_FORMAT(a.Date,'%s'),a.Nn,a.Str,tbl290.Publ1_Name, tbl290.Publ1_ID,a.Doclad,a.TextPub,a.Description,a.Keywords,a.Url,a.Message_ID, a.User_ID, a.IP, a.UserAgent, a.LastUser_ID, a.LastIP, a.LastUserAgent, a.Priority, a.Checked, a.Created, a.LastUpdated, a.Keyword FROM (Message41 AS a ) LEFT JOIN Classificator_FIO1 AS tbl238 ON a.A1=tbl238.FIO1_ID LEFT JOIN Classificator_FIO1 AS tbl239 ON a.A2=tbl239.FIO1_ID LEFT JOIN Classificator_FIO1 AS tbl240 ON a.A3=tbl240.FIO1_ID LEFT JOIN Classificator_FIO1 AS tbl241 ON a.A4=tbl241.FIO1_ID LEFT JOIN Classificator_FIO1 AS tbl242 ON a.A5=tbl242.FIO1_ID LEFT JOIN Classificator_FIO1 AS tbl243 ON a.A6=tbl243.FIO1_ID LEFT JOIN Classificator_FIO1 AS tbl244 ON a.A7=tbl244.FIO1_ID LEFT JOIN Classificator_FIO1 AS tbl245 ON a.A8=tbl245.FIO1_ID LEFT JOIN Classificator_FIO1 AS tbl246 ON a.A9=tbl246.FIO1_ID LEFT JOIN Classificator_Publ1 AS tbl290 ON a.Type=tbl290.Publ1_ID LEFT JOIN Subdivision AS sub ON sub.Subdivision_ID=a.Subdivision_ID LEFT JOIN Sub_Class AS cc ON cc.Sub_Class_ID=a.Sub_Class_ID WHERE 1 AND a.Parent_Message_ID=0 AND a.Checked=1 ORDER BY Date DESC, Nazv LIMIT 0,20

Query failed (3): Error writing file '/var/tmp/MYiGQ9tU' (Errcode: 28)