African Journal of Environmental Science and Technology
Subscribe to AJEST
Full Name*
Email Address*

Article Number - 9B914B465585


Vol.11(9), pp. 486-498 , September 2017
DOI: 10.5897/AJEST2016.2256
ISSN: 1996-0786



Full Length Research Paper

Spatial analysis of soil physical attributes from a degraded area under different types of management



Joseane Carina Borges de Carvalho
  • Joseane Carina Borges de Carvalho
  • Secretaria da Educação do Estado de São Paulo. Praça da República nº 53, 01045-903, sala 20 (térreo), São Paulo, Brasil.
  • Google Scholar
Carlos Roberto Espindola
  • Carlos Roberto Espindola
  • Instituto de Geociências, Universidade Estadual de Campinas (UNICAMP). Rua João Pandiá Calógeras, nº 51, 13083-870, Cidade Universitária, Campinas, Brasil.
  • Google Scholar
Marlene Cristina Alves
  • Marlene Cristina Alves
  • Departamento de Fitossanidade, Engenharia Rural e Solos, Universidade Estadual Paulista (UNESP). Rua Monção, nº 830, 15385-000, Ilha Solteira, Brasil.
  • Google Scholar
Célia Regina Grego
  • Célia Regina Grego
  • Embrapa Informática Agropecuária. Av. André Tosello, nº 209, Campus da Unicamp, Barão Geraldo, Campinas, Brasil.
  • Google Scholar
Sidney Rosa Vieira
  • Sidney Rosa Vieira
  • Instituto Agronômico de Campinas (IAC), Caixa Postal nº 28, 13012-970, Campinas, Brasil.
  • Google Scholar







 Received: 24 November 2016  Accepted: 26 July 2017  Published: 30 September 2017

Copyright © 2017 Author(s) retain the copyright of this article.
This article is published under the terms of the Creative Commons Attribution License 4.0


The objective of this work was to analyze the spatial variability of soil aggregates, porosity and density under five different land-uses and management conditions (degraded substrate - SD; degraded substrate with sewage sludge and Eucalyptus crop - SDLE; soil under pasture SP; capoeira under regeneration - SR; and soil under cerrado - SC). Total porosity (m3.m-3) and density (Mg m-3) of the soil; the mean weight diameter (MWD, mm) of the aggregates; and the percentage of aggregates resistant to rainfall were evaluated. The date of soil was analyzed with descriptive statistics for initial exploration and geostatistics, to analyze the spatial variability. There was spatial dependency and the parameter adjust range varied from 8 to 12 m under the treatments SD and SR for the aggregates and SR for macroporosity, total porosity and soil density. There was spatial dependency also under SP, for the aggregates, microporosity, and total porosity; under SC, for the aggregates; and under SDLE, for microporosity. Soil data with spatial dependence in the field were characterized both by high and low values in the same area. Therefore it is not adequate to consider these areas as homogeneous for future experiments and agricultural activities.

Key words: Spatial variability, soil aggregates, geostatistics.

Alves MC, Nascimento V, Souza ZM (2012). Recuperação em área de empréstimo usada para construção de usina hidrelétrica. Revista Brasileira de Engenharia Agrícola e Ambiental 16:887-89.
Crossref

 

Andrade ARS, Guerrini IA, Garcia CJB, Katez I, Guerra HOC (2005). Variabilidade espacial da densidade do solo sob manejo da irrigação. Ciência e Agrotecnologia 9:322-329.
Crossref

 
 

Baldock JA, Kay BD (1987). Influence of cropping history and chemical treatments on the waterstable aggregation of a silt loam soil. Can. J. Soil Sci. 67:501-511.
Crossref

 
 

Barbosa GM, Tavares Filho J, Fonseca ICB (2002). Avaliações de propriedades físicas de um Latossolo Vermelho Eutroférrico tratado com lodo de esgoto por dois anos consecutivos. Revista Técnica da Sanepar 17:94-101.

 
 

Benito Rueda E, Diaz-Fierros Viqueira F (1989). Estudio de los principales factores que intervienen la estabilidad estructural de los suelos de Galicia. Anales de Edafolgia y Agrobiologia, Madrid, 48:229-253.

 
 

Blake GR, Hartge KH (1986). Bulk density. In: Klute A, ed. Methods of soil analysis - Physical and mineralogical methods. Madison: ASA-SSS. pp. 363-375.

 
 

Bonini CSB, Alves MC (2011). Estabilidade de agregados de um Latossolo Vermelho degradado em recuperação com adubos verdes, calcário e gesso. Revista Brasileira de Ciência do Solo 35:1263-1270.
Crossref

 
 

Camargo AO, Moniz AC, Jorge J A, Valadares JMAS (2009). Métodos de análise química, mineralógica e física de solos do Instituto Agronômico de Campinas. Campinas: Instituto Agronômico (Boletim técnico, 106). 

View

 
 

Campos FS, Alves MC (2008). Uso de lodo de esgoto na reestruturação de solo degradado. Revista Brasileira de. Ciência do Solo 32:1389-1397.
Crossref

 
 

Carvalho JRP, Silveira PM, Vieira SR (2002). Geoestatística na determinação da variabilidade espacial de características químicas do solo sob diferentes preparos. Pesquisa Agropecuária Brasileira, 37:1151-1159.
Crossref

 
 

Carvalho JCB, Espindola CR, Alves MC, Figueiredo GC, Dechen SCF (2015). Recovery of an oxisol degraded by the construction of a hydroelectric power plant. Revista Brasileira de Ciência do Solo 39:1776-1785.
Crossref

 
 

Colodro G, Espindola CR (2006). Alterações na fertilidade de um Latossolo degradado em resposta à aplicação de lodo de esgoto. Acta Scientiarum. Agron. 28:1-15.
Crossref

 
 

Costa CDO, Alves MC, Sousa AP (2014). Aggregate Stability in Two Soils Under Different Uses and Managements. Int. J. Sci. 2:61-68.

 
 

Courtney FMS, Trudgill T (1984). The soil: An introduction to soil study. London: Edward Arnold.

 
 

Demattê JLI (1980). Levantamento detalhado dos solos do Campus Experimental de Ilha Solteira (SP). Departamento de Solos, Geologia e Fertilidade ESALQ/USP. Piracicaba, 131 p.

 
 

Galdos MV, Maria IC de, Camargo OA (2004). Atributos químicos e produção de milho em um Latossolo Vermelho Eutroférrico tratado com lodo de esgoto. Revista Brasileira de Ciência do Solo 28:569-557.
Crossref

 
 

García-Orenes F, Roldán A, Mataix-Solera J, Cerdà A, Campoy M, Arcenegui F, Caravaca F (2012). Soil structural stability and erosion rates influenced by agricultural management practices in a semi-arid Mediterranean agro-ecosystem. Soil Use Manage. 28:571-579.
Crossref

 
 

Golden Software. Surfer 7.0 (1999). Contouring and 3D surface mapping for scientist's engineers. User's Guide. New York, Golden Software. 619 p.

 
 

Grego CR, Vieira SR (2005). Variabilidade espacial de propriedades físicas de solo em uma parcela experimental. Revista Brasileira de Ciência do Solo, 29:169-177.
Crossref

 
 

Jorge JA, Camargo OA, Valadares JMAS (1991). Condições físicas de um Latossolo Vermelho-Escuro quatro anos após aplicação de lodo de esgoto e calcário. Revista Brasileira de Ciência do Solo (Impresso) 15:237-240.

 
 

Kemper WD, Chepil WS (1965). Size distribution of aggregates. In: Black CA, Evans DD, White JL, Ensminger LE, Clark FE (Eds.). Methods of soil analysis – physical and mineralogical properties, including statistics of measurement and sampling. Madison: Am. Soc. Agron. pp. 499-510.

 
 

Kemper WD, Rosenau RC (1986). Aggregate stability and size distribution. In: KLUTE, A (Ed.). Methods of soil analysis. Madison: Am. Soc. Agron. 1:425-441.

 
 

Kiehl EJ (1979). Manual de edafologia. São Paulo, Agronômica Ceres, 262 p.

 
 

Maria IC de, Kocssi MA, Dechen SCF (2007). Agregação do solo em área que recebeu lodo de esgoto. Bragantia 66:291-298.
Crossref

 
 

Meester T, Jungerius PD (1978). The relationship between the soil erodibility factor K (Universal Soil Loss Equation), aggregate stability and micro - morphological properties of soils in the Hornos area, S. Spain. Earth Surface Processes, Wiley 3(4):379-391.
Crossref

 
 

Reichert JM, Suzuki LEAS, Reinert DJ (2007). Compactação do solo em sistemas agropecuários e florestais: identificação, efeitos, limites críticos e mitigação. In: Ceretta, CA, Silva, LS, Reichert, JM. Tópicos em Ciência do Solo, Viçosa: Sociedade Brasileira de Ciência do Solo 5:49-134.

 
 

Rosa PAL, Alves MC, Videira LML, Bonini CBS (2014). Recuperação de um solo de cerrado após 19 anos: ocorrência espontânea de espécies arbóreas. Revista de Agricultura Neotropical, 1:44-57.

 
 

Rodrigues GB, Maltoni KL, Cassiolato AMR (2007). Dinâmica da regeneração do subsolo de áreas degradadas dentro do bioma Cerrado. Revista Brasileira de Engenharia Agrícola e Ambiental, 11 (1):73-80.
Crossref

 
 

Roth CH (1985). A portable rainfall simulator for studying factors affecting runoff, infiltration and soil loss. Catena 12:79-85.
Crossref

 
 

Santos HG, Jacomine PKT, Anjos LHC, Oliveira VA, Lubreras JF, Coelho M R, Almeida JA, Cunha TJF, Oliveira JB (2013). Sistema brasileiro de classificação de solos. Brasília, Embrapa, 306p.

 
 

Silva IF, Mielniczuk J (1997). Ação do sistema radicular de planta na formação e estabilização de agregados do solo. Revista Brasileira de Ciência do Solo 21:113-117.

 
 

Soil Survey Staff (2010). Keys to soil taxonomy. 12th ed. Washington, DC: USDA-Natural Resources Conservation Service. 

 
 

Souza ZM De, Souza GS De, Marques Junior J, Pereira GT (2014). Número de amostras na análise geoestatística e na krigagem de mapas de atributos do solo. Ciência Rural 44:261-268.
Crossref

 
 

Spaccini R, Piccolo A, Mbagwu JSC, Zena Teshale A, Igwe CA (2002). Influence of the addition of organic residues on carbohydrate content and structural stability of some highland soils in Ethiopia. Soil Use Manage. 18:404-411.
Crossref

 
 

Vieira SR, Dechen SCF (2010). Spatial variability studies in São Paulo, Brazil along the last twenty five years. Bragantia 69:53-66.
Crossref

 
 

Vieira SR (2000). Geoestatística em estudos de variabilidade espacial do solo. In: Novais RF, Alvarez VH, Schaefer GR (Eds.). Tópicos em Ciência do solo. Viçosa: Sociedade Brasileira de Ciência do solo pp. 1-54.

 
 

Vieira SR, Millete J, Topp GC, Reynolds WD (2002). Handbook for geostatistical analysis of variability in soil and climate data. In: Alvarez VVH, Schaefer CEGR, Barros, NF, Mello, JWV, Costa, LM (Eds). Tópicos em Ciência do Solo. Viçosa: Sociedade Brasileira de Ciência do solo pp. 1-45.

 
 

Vieira SR, Xavier MA, Grego CR (2008). Aplicações de geoestatística em pesquisas com cana-de-açúcar. In: Dinardo-Miranda LL, Vasconcellos ACM, Landell MGA. (Eds). Instituto Agronômico, pp. 839-852.

 
 

Vieira SR, Grego CR, Topp GC, and Reynolds WD (2014). Spatial Relationships between Soil Water Content and Hydraulic Conductivity in a Highly Structured Clay Soils. In: Teixeira WG, Ceddia, MB, Ottoni, MV, Donnagema, KG (Eds.). Application of soil physics in environmental analyses: measuring, modelling and data integration. New York: Springer pp. 75-90.
Crossref

 
 

Warrick AW, Nielsen DR (1980). Spatial variability of soil physical properties in the field. In: Hillel D, (Ed.) Applications of soil physics. New York, Academic Press pp. 319-344.
Crossref

 
 

Wohlenberg EV, Reichert JM, Reinert DJ, Blume E (2004). Dinâmica da agregação de um solo franco-arenoso em cinco sistemas de culturas em rotação e em sucessão. Revista Brasileira de Ciência do Solo 28:891-900.
Crossref

 
 

Zimback CRL (2001). Análise espacial de atributos químicos de solos para fins de mapeamento da fertilidade do solo. Tese (Livre-Docência em Levantamento do solo e Fotopedologia) - Universidade Estadual Paulista, Botucatu,114.

 

 


APA de Carvalho, J. C. B., Espindola, C. R., Alves, M. C., Grego, C. R., & Vieira, S. R. (2017). Spatial analysis of soil physical attributes from a degraded area under different types of management. African Journal of Environmental Science and Technology , 11(9), 486-498.
Chicago Joseane Carina Borges de Carvalho, Carlos Roberto Espindola, Marlene Cristina Alves, C&elia Regina Grego and Sidney Rosa Vieira. "Spatial analysis of soil physical attributes from a degraded area under different types of management." African Journal of Environmental Science and Technology 11, no. 9 (2017): 486-498.
MLA Joseane Carina Borges de Carvalho, et al. "Spatial analysis of soil physical attributes from a degraded area under different types of management." African Journal of Environmental Science and Technology 11.9 (2017): 486-498.
   
DOI 10.5897/AJEST2016.2256
URL http://www.academicjournals.org/journal/AJEST/article-abstract/9B914B465585

Subscription Form

(default) 34 queries took 13239 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
2SELECT `Journal`.`id`, `Journal`.`journal_category_id`, `Journal`.`name`, `Journal`.`issn`, `Journal`.`abbrev`, `Journal`.`pub_abbrev`, `Journal`.`banner`, `Journal`.`colour`, `Journal`.`email`, `Journal`.`password`, `Journal`.`instruction_for_author_file`, `Journal`.`reviewers_guide_file`, `Journal`.`about_text`, `Journal`.`submit_manuscript`, `Journal`.`instructions_for_authors`, `Journal`.`pub_ethics`, `Journal`.`abstracting`, `Journal`.`call_for_papers`, `Journal`.`faculty_1000`, `Journal`.`editors`, `Journal`.`journal_issue_count`, `Journal`.`journ_handling_fee`, `Journal`.`founding_editor`, `Journal`.`founding_editor_address`, `Journal`.`created`, `Journal`.`modified`, `Journal`.`subdomain`, `JournalCategory`.`id`, `JournalCategory`.`name`, `JournalCategory`.`journal_count`, `JournalCategory`.`description`, `JournalCategory`.`created`, `JournalCategory`.`modified` FROM `admin_academic_journals`.`journals` AS `Journal` LEFT JOIN `admin_academic_journals`.`journal_categories` AS `JournalCategory` ON (`Journal`.`journal_category_id` = `JournalCategory`.`id`) WHERE `Journal`.`abbrev` = 'AJEST' LIMIT 1110
3SELECT `JournalIssue`.`id`, `JournalIssue`.`journal_id`, `JournalIssue`.`archive_id`, `JournalIssue`.`volume_number`, `JournalIssue`.`issue_number`, `JournalIssue`.`page_range`, `JournalIssue`.`edition`, `JournalIssue`.`month`, `JournalIssue`.`picture`, `JournalIssue`.`home_issue`, `JournalIssue`.`current_issue`, `JournalIssue`.`articles_count`, `JournalIssue`.`e-book`, `JournalIssue`.`issuu_embed`, `JournalIssue`.`subject`, `JournalIssue`.`created`, `JournalIssue`.`modified` FROM `admin_academic_journals`.`journal_issues` AS `JournalIssue` WHERE `JournalIssue`.`journal_id` = (88)1251250
4SELECT `JournalStat`.`id`, `JournalStat`.`journal_id`, `JournalStat`.`name`, `JournalStat`.`value`, `JournalStat`.`ref_link`, `JournalStat`.`description`, `JournalStat`.`created`, `JournalStat`.`modified` FROM `admin_academic_journals`.`journal_stats` AS `JournalStat` WHERE `JournalStat`.`journal_id` = (88)110
5SELECT `JournalSection`.`id`, `JournalSection`.`name`, `JournalSection`.`journal_id`, `JournalSection`.`description`, `JournalSection`.`created`, `JournalSection`.`modified` FROM `admin_academic_journals`.`journal_sections` AS `JournalSection` WHERE `JournalSection`.`journal_id` = (88)000
6SELECT `JournalStat`.`id`, `JournalStat`.`journal_id`, `JournalStat`.`name`, `JournalStat`.`value`, `JournalStat`.`ref_link`, `JournalStat`.`description`, `JournalStat`.`created`, `JournalStat`.`modified` FROM `admin_academic_journals`.`journal_stats` AS `JournalStat` WHERE `JournalStat`.`journal_id` = 88 AND `JournalStat`.`value` <> ''110
7SELECT `JournalIssue`.`id`, `JournalIssue`.`journal_id`, `JournalIssue`.`archive_id`, `JournalIssue`.`volume_number`, `JournalIssue`.`issue_number`, `JournalIssue`.`page_range`, `JournalIssue`.`edition`, `JournalIssue`.`month`, `JournalIssue`.`picture`, `JournalIssue`.`home_issue`, `JournalIssue`.`current_issue`, `JournalIssue`.`articles_count`, `JournalIssue`.`e-book`, `JournalIssue`.`issuu_embed`, `JournalIssue`.`subject`, `JournalIssue`.`created`, `JournalIssue`.`modified`, `Journal`.`id`, `Journal`.`journal_category_id`, `Journal`.`name`, `Journal`.`issn`, `Journal`.`abbrev`, `Journal`.`pub_abbrev`, `Journal`.`banner`, `Journal`.`colour`, `Journal`.`email`, `Journal`.`password`, `Journal`.`instruction_for_author_file`, `Journal`.`reviewers_guide_file`, `Journal`.`about_text`, `Journal`.`submit_manuscript`, `Journal`.`instructions_for_authors`, `Journal`.`pub_ethics`, `Journal`.`abstracting`, `Journal`.`call_for_papers`, `Journal`.`faculty_1000`, `Journal`.`editors`, `Journal`.`journal_issue_count`, `Journal`.`journ_handling_fee`, `Journal`.`founding_editor`, `Journal`.`founding_editor_address`, `Journal`.`created`, `Journal`.`modified`, `Journal`.`subdomain`, `Archive`.`id`, `Archive`.`month`, `Archive`.`year`, `Archive`.`created`, `Archive`.`modified` FROM `admin_academic_journals`.`journal_issues` AS `JournalIssue` LEFT JOIN `admin_academic_journals`.`journals` AS `Journal` ON (`JournalIssue`.`journal_id` = `Journal`.`id`) LEFT JOIN `admin_academic_journals`.`archives` AS `Archive` ON (`JournalIssue`.`archive_id` = `Archive`.`id`) WHERE `JournalIssue`.`journal_id` = 88 AND `JournalIssue`.`current_issue` = '1' ORDER BY `JournalIssue`.`created` DESC, `JournalIssue`.`month` DESC LIMIT 1110
8SELECT `Article`.`id`, `Article`.`journal_section_id`, `Article`.`journal_issue_id`, `Article`.`article_number`, `Article`.`article_type`, `Article`.`title`, `Article`.`accepted_date`, `Article`.`received_date`, `Article`.`abstract`, `Article`.`abbrev`, `Article`.`full_text`, `Article`.`pages`, `Article`.`doi`, `Article`.`authors_for_citation`, `Article`.`authors`, `Article`.`email`, `Article`.`phone`, `Article`.`address`, `Article`.`has_full_text`, `Article`.`has_reference`, `Article`.`pdf_file`, `Article`.`published`, `Article`.`published_date`, `Article`.`status`, `Article`.`author_id`, `Article`.`created`, `Article`.`modified`, `Article`.`read_count`, `Article`.`shared_count`, `Article`.`download_count`, `Article`.`other_links`, `Article`.`references` FROM `admin_academic_journals`.`articles` AS `Article` WHERE `Article`.`journal_issue_id` = (9123)330
9SELECT COUNT(*) AS `count` FROM `admin_academic_journals`.`articles` AS `Article` LEFT JOIN `admin_academic_journals`.`journal_issues` AS `JournalIssue` ON (`Article`.`journal_issue_id` = `JournalIssue`.`id`) LEFT JOIN `admin_academic_journals`.`journal_sections` AS `JournalSection` ON (`Article`.`journal_section_id` = `JournalSection`.`id`) LEFT JOIN `admin_academic_journals`.`authors` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) WHERE `JournalIssue`.`journal_id` =88 AND `Article`.`published` = 1110
10SELECT `Article`.`id`, `Article`.`journal_section_id`, `Article`.`journal_issue_id`, `Article`.`article_number`, `Article`.`article_type`, `Article`.`title`, `Article`.`accepted_date`, `Article`.`received_date`, `Article`.`abstract`, `Article`.`abbrev`, `Article`.`full_text`, `Article`.`pages`, `Article`.`doi`, `Article`.`authors_for_citation`, `Article`.`authors`, `Article`.`email`, `Article`.`phone`, `Article`.`address`, `Article`.`has_full_text`, `Article`.`has_reference`, `Article`.`pdf_file`, `Article`.`published`, `Article`.`published_date`, `Article`.`status`, `Article`.`author_id`, `Article`.`created`, `Article`.`modified`, `Article`.`read_count`, `Article`.`shared_count`, `Article`.`download_count`, `Article`.`other_links`, `Article`.`references`, `JournalIssue`.`id`, `JournalIssue`.`journal_id`, `JournalIssue`.`archive_id`, `JournalIssue`.`volume_number`, `JournalIssue`.`issue_number`, `JournalIssue`.`page_range`, `JournalIssue`.`edition`, `JournalIssue`.`month`, `JournalIssue`.`picture`, `JournalIssue`.`home_issue`, `JournalIssue`.`current_issue`, `JournalIssue`.`articles_count`, `JournalIssue`.`e-book`, `JournalIssue`.`issuu_embed`, `JournalIssue`.`subject`, `JournalIssue`.`created`, `JournalIssue`.`modified`, `JournalSection`.`id`, `JournalSection`.`name`, `JournalSection`.`journal_id`, `JournalSection`.`description`, `JournalSection`.`created`, `JournalSection`.`modified`, `Author`.`id`, `Author`.`surname`, `Author`.`other_names`, `Author`.`email`, `Author`.`phone`, `Author`.`sex`, `Author`.`institution`, `Author`.`address`, `Author`.`specialization`, `Author`.`country`, `Author`.`password`, `Author`.`last_login`, `Author`.`created`, `Author`.`title`, `Author`.`affiliation`, `Author`.`blacklist_id` FROM `admin_academic_journals`.`articles` AS `Article` LEFT JOIN `admin_academic_journals`.`journal_issues` AS `JournalIssue` ON (`Article`.`journal_issue_id` = `JournalIssue`.`id`) LEFT JOIN `admin_academic_journals`.`journal_sections` AS `JournalSection` ON (`Article`.`journal_section_id` = `JournalSection`.`id`) LEFT JOIN `admin_academic_journals`.`authors` AS `Author` ON (`Article`.`author_id` = `Author`.`id`) WHERE `Article`.`article_number` = '9B914B465585' LIMIT 11193
11SELECT `AbstractTranslation`.`id`, `AbstractTranslation`.`article_id`, `AbstractTranslation`.`language`, `AbstractTranslation`.`abstract`, `AbstractTranslation`.`published`, `AbstractTranslation`.`created`, `AbstractTranslation`.`modified` FROM `admin_academic_journals`.`abstract_translations` AS `AbstractTranslation` WHERE `AbstractTranslation`.`article_id` = (1009959913)000
12SELECT `ArticleTranslation`.`id`, `ArticleTranslation`.`article_id`, `ArticleTranslation`.`name`, `ArticleTranslation`.`url`, `ArticleTranslation`.`translator`, `ArticleTranslation`.`translator_url`, `ArticleTranslation`.`created`, `ArticleTranslation`.`modified` FROM `admin_academic_journals`.`article_translations` AS `ArticleTranslation` WHERE `ArticleTranslation`.`article_id` = (1009959913)000
13SELECT `ArticleAuthor`.`id`, `ArticleAuthor`.`name`, `ArticleAuthor`.`article_id`, `ArticleAuthor`.`email`, `ArticleAuthor`.`phone`, `ArticleAuthor`.`department`, `ArticleAuthor`.`affiliation`, `ArticleAuthor`.`country`, `ArticleAuthor`.`created`, `ArticleAuthor`.`modified` FROM `admin_academic_journals`.`article_authors` AS `ArticleAuthor` WHERE `ArticleAuthor`.`article_id` = (1009959913)550
14SELECT `ArticleReference`.`id`, `ArticleReference`.`title`, `ArticleReference`.`article_id`, `ArticleReference`.`authors`, `ArticleReference`.`year`, `ArticleReference`.`volume`, `ArticleReference`.`pages`, `ArticleReference`.`journal_title`, `ArticleReference`.`google_scholar`, `ArticleReference`.`pub_med`, `ArticleReference`.`url`, `ArticleReference`.`created`, `ArticleReference`.`modified` FROM `admin_academic_journals`.`article_references` AS `ArticleReference` WHERE `ArticleReference`.`article_id` = (1009959913)000
15SELECT `JournalIssue`.`id`, `JournalIssue`.`journal_id`, `JournalIssue`.`archive_id`, `JournalIssue`.`volume_number`, `JournalIssue`.`issue_number`, `JournalIssue`.`page_range`, `JournalIssue`.`edition`, `JournalIssue`.`month`, `JournalIssue`.`picture`, `JournalIssue`.`home_issue`, `JournalIssue`.`current_issue`, `JournalIssue`.`articles_count`, `JournalIssue`.`e-book`, `JournalIssue`.`issuu_embed`, `JournalIssue`.`subject`, `JournalIssue`.`created`, `JournalIssue`.`modified`, `Journal`.`id`, `Journal`.`journal_category_id`, `Journal`.`name`, `Journal`.`issn`, `Journal`.`abbrev`, `Journal`.`pub_abbrev`, `Journal`.`banner`, `Journal`.`colour`, `Journal`.`email`, `Journal`.`password`, `Journal`.`instruction_for_author_file`, `Journal`.`reviewers_guide_file`, `Journal`.`about_text`, `Journal`.`submit_manuscript`, `Journal`.`instructions_for_authors`, `Journal`.`pub_ethics`, `Journal`.`abstracting`, `Journal`.`call_for_papers`, `Journal`.`faculty_1000`, `Journal`.`editors`, `Journal`.`journal_issue_count`, `Journal`.`journ_handling_fee`, `Journal`.`founding_editor`, `Journal`.`founding_editor_address`, `Journal`.`created`, `Journal`.`modified`, `Journal`.`subdomain`, `Archive`.`id`, `Archive`.`month`, `Archive`.`year`, `Archive`.`created`, `Archive`.`modified` FROM `admin_academic_journals`.`journal_issues` AS `JournalIssue` LEFT JOIN `admin_academic_journals`.`journals` AS `Journal` ON (`JournalIssue`.`journal_id` = `Journal`.`id`) LEFT JOIN `admin_academic_journals`.`archives` AS `Archive` ON (`JournalIssue`.`archive_id` = `Archive`.`id`) WHERE `JournalIssue`.`id` = 9047 LIMIT 1110
16SELECT `Article`.`id`, `Article`.`journal_section_id`, `Article`.`journal_issue_id`, `Article`.`article_number`, `Article`.`article_type`, `Article`.`title`, `Article`.`accepted_date`, `Article`.`received_date`, `Article`.`abstract`, `Article`.`abbrev`, `Article`.`full_text`, `Article`.`pages`, `Article`.`doi`, `Article`.`authors_for_citation`, `Article`.`authors`, `Article`.`email`, `Article`.`phone`, `Article`.`address`, `Article`.`has_full_text`, `Article`.`has_reference`, `Article`.`pdf_file`, `Article`.`published`, `Article`.`published_date`, `Article`.`status`, `Article`.`author_id`, `Article`.`created`, `Article`.`modified`, `Article`.`read_count`, `Article`.`shared_count`, `Article`.`download_count`, `Article`.`other_links`, `Article`.`references` FROM `admin_academic_journals`.`articles` AS `Article` WHERE `Article`.`journal_issue_id` = (9047)440
17SELECT `ArticleMetric`.`id`, `ArticleMetric`.`article_id`, `ArticleMetric`.`ip`, `ArticleMetric`.`read_t`, `ArticleMetric`.`count`, `ArticleMetric`.`country`, `ArticleMetric`.`region`, `ArticleMetric`.`continent`, `ArticleMetric`.`created`, `ArticleMetric`.`modified` FROM `admin_academic_journals`.`article_metrics` AS `ArticleMetric` WHERE `ArticleMetric`.`article_id` = 1009959913 AND `ArticleMetric`.`read_t` = 'article-abstract' AND `ArticleMetric`.`ip` = '54.159.113.182' AND DATE_FORMAT(`ArticleMetric`.`created`, '%Y-%m-%d') = '2017-09-20' LIMIT 1006573
18BEGIN006573
19INSERT INTO `admin_academic_journals`.`article_metrics` (`read_t`, `count`, `article_id`, `ip`, `country`, `region`, `continent`, `modified`, `created`) VALUES ('article-abstract', 1, 1009959913, '54.159.113.182', 'United States', 'Virginia', 'North America', '2017-09-20 01:39:20', '2017-09-20 01:39:20')110
20COMMIT110
21SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
22SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
23SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
24SELECT `JournalIssue`.`id`, `JournalIssue`.`journal_id`, `JournalIssue`.`archive_id`, `JournalIssue`.`volume_number`, `JournalIssue`.`issue_number`, `JournalIssue`.`page_range`, `JournalIssue`.`edition`, `JournalIssue`.`month`, `JournalIssue`.`picture`, `JournalIssue`.`home_issue`, `JournalIssue`.`current_issue`, `JournalIssue`.`articles_count`, `JournalIssue`.`e-book`, `JournalIssue`.`issuu_embed`, `JournalIssue`.`subject`, `JournalIssue`.`created`, `JournalIssue`.`modified` FROM `admin_academic_journals`.`journal_issues` AS `JournalIssue` WHERE `JournalIssue`.`id` = 9047 LIMIT 1110
25SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
26SELECT `JournalIssue`.`id`, `JournalIssue`.`journal_id`, `JournalIssue`.`archive_id`, `JournalIssue`.`volume_number`, `JournalIssue`.`issue_number`, `JournalIssue`.`page_range`, `JournalIssue`.`edition`, `JournalIssue`.`month`, `JournalIssue`.`picture`, `JournalIssue`.`home_issue`, `JournalIssue`.`current_issue`, `JournalIssue`.`articles_count`, `JournalIssue`.`e-book`, `JournalIssue`.`issuu_embed`, `JournalIssue`.`subject`, `JournalIssue`.`created`, `JournalIssue`.`modified` FROM `admin_academic_journals`.`journal_issues` AS `JournalIssue` WHERE `JournalIssue`.`id` = 9047 LIMIT 1110
27SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
28SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
29SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
30SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
31SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
32SELECT `Logo`.`id`, `Logo`.`name`, `Logo`.`banner`, `Logo`.`description`, `Logo`.`created`, `Logo`.`modified` FROM `admin_academic_journals`.`logos` AS `Logo` WHERE `Logo`.`id` = 1 LIMIT 1110
33SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `admin_academic_journals`.`settings` AS `Setting` WHERE 1 = 1660
34SELECT `Journal`.`id`, `Journal`.`journal_category_id`, `Journal`.`name`, `Journal`.`issn`, `Journal`.`abbrev`, `Journal`.`pub_abbrev`, `Journal`.`banner`, `Journal`.`colour`, `Journal`.`email`, `Journal`.`password`, `Journal`.`instruction_for_author_file`, `Journal`.`reviewers_guide_file`, `Journal`.`about_text`, `Journal`.`submit_manuscript`, `Journal`.`instructions_for_authors`, `Journal`.`pub_ethics`, `Journal`.`abstracting`, `Journal`.`call_for_papers`, `Journal`.`faculty_1000`, `Journal`.`editors`, `Journal`.`journal_issue_count`, `Journal`.`journ_handling_fee`, `Journal`.`founding_editor`, `Journal`.`founding_editor_address`, `Journal`.`created`, `Journal`.`modified`, `Journal`.`subdomain` FROM `admin_academic_journals`.`journals` AS `Journal` WHERE `Journal`.`id` = 88 LIMIT 1110