International Journal of Library and Information Science
Subscribe to IJLIS
Full Name*
Email Address*

Article Number - B8E9DF065829


Vol.9(8), pp. 66-77 , September 2017
DOI: 10.5897/IJLIS2017.0786
ISSN: 2141-2537



Full Length Research Paper

Research growth and citation impact of Tanzanian scholars: A 24 year’s scientometric study



Raphael Z. Sangeda
  • Raphael Z. Sangeda
  • Department of Pharmaceutical Microbiology, Muhimbili University of Health and Allied Sciences (MUHAS), P. O. Box 65013, Dar es Salaam, Tanzania.
  • Google Scholar
Edda Tandi Lwoga
  • Edda Tandi Lwoga
  • Directorate of Library Services, Muhimbili University of Health and Allied Sciences (MUHAS, P. O. Box 65001, Dar es Salaam, Tanzania.
  • Google Scholar







 Received: 24 May 2017  Accepted: 01 August 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


A scientometric analysis was conducted to map the research growth and citation impact of Tanzania scholars over a period of 24 years starting from 1991 to 2015. We analyzed data for research publications of all Tanzania scholars obtained from the SCOPUS database. The study analyzed the year-wise distribution of publications, subject-wise distribution of publications, the authorship pattern, degree of collaboration, and the citation impact. A total of 12,379 articles were published from 34 academic and research institutions. The top three universities with high cumulative number of publications were Muhimbili University of Health and Allied Sciences, University of Dar es salaam and Sokoine University of Agriculture. The top subject was medicine. The maximum number of citations received in a single publication was 1914. Publications metrics scores varied a lot based on indices chosen to rank the Tanzanian scholars. The study findings call for a need for scholars to collaborate with external partners within and outside the country, and publish in journals with a higher impact.

Key words: Scientometrics, research growth, research performance, research publications, citation impact, Tanzania.

Abrahams JL, Burke M, Mouton J (2009). Research Productivity-Visibility-Accessibility and Scholarly Communication in Southern African Universities. Afr. J. Inf. Commun. pp. 20-36.

 

Bornmann L, Daniel HD (2008). What do citation counts measure? A review of studies on citing behavior. J. Doc. 64:45-80.
Crossref

 
 

Boshoff N (2010). South–South research collaboration of countries in the Southern African Development Community (SADC). Scientometrics 84:481-503.
Crossref

 
 

Braun T, Glänzel W, Schubert A (2006). A Hirsch-type index for Journals. Scientometrics 69:169-173.
Crossref

 
 

Breugelmans JG, Makanga MM, Cardoso ALV, Mathewson SB, Sheridan-Jones BR, Gurney KA, Mgone CS (2015). Bibliometric Assessment of European and Sub-Saharan African Research Output on Poverty-Related and Neglected Infectious Diseases from 2003 to2011. PLoS Negl. Trop. Dis. 9: e0003997.
Crossref

 
 

Confraria H, Godinho MM (2015). The impact of African science: a bibliometric analysis. Scientometrics 102:1241-1268.
Crossref

 
 

Egghe L (2006). Theory and practice of the g-index. Scientometrics 69:131-152.
Crossref

 
 

Elsevier BV (2016). Scopus. The largest database of peer-reviewed literature.

 
 

Fari SA, Ocholla DN (2016). Nature, patterns and trends of research collaboration among academics in Nigeria and South Africa. Mousaion 34:1-22.

 
 

Gondwe M (2010). Global research report on Africa. Malawi Med. J. 22:9.

 
 

Gorraiz J, Schloegl C (2008). A bibliometric analysis of pharmacology and pharmacy journals: Scopus versus Web of Science. J. Inf. Sci. 34:715-725.
Crossref

 
 

Guindon GE, Lavis JN, Becerra-Posada F, Malek AH, Shi G, Yesudian CAK, Hoffman SJ (2010). Bridging the gaps between research, policy and practice in low- and middle-income countries: a survey of health care providers. CMAJ 182:E362-372.
Crossref

 
 

Hirsch JE (2005). An index to quantify an individual's scientific research output. Proc. Natl. Acad. Sci. U. S. A. 102(46):16569.
Crossref

 
 

Inglesi-Lotz R, Pouris A (2013). The influence of scientific research output of academics on economic growth in South Africa: An autoregressive distributed lag (ARDL) application. Scientometrics 95:129-139.
Crossref

 
 

Kotecha P, Walwyn D, Pinto C (2011). Deepening Research Capacity and Collaboration across Universities in SADC: A Southern African Universities Regional Research and Development Fund. Southern African Regional Universities Association (SARUA), Johannesburg.

 
 

Lavis JN, Guindon GE, Cameron D, Boupha B, Dejman M, Osei Eric JA, Sadana R (2010). Bridging the gaps between research, policy and practice in low- and middle-income countries: a survey of researchers. CMAJ 182:E350-61. https://www.ncbi.nlm.nih.gov/pubmed/20439449
Crossref

 
 

Van Leeuwen TN, Visser MS, Moed HF, Nederhof TJ, Anthony FJVR (2003). The holy grail of science policy: Exploring and combining bibliometric tools in search of scientific excellence. Scientometrics 57:257-280.
Crossref

 
 

Lwoga ET, Sife AS (2013). Mapping the Research Productivity and Scholarly Impact of the Traditional Medicine Scholars in Tanzania : A Scientometric Analysis. Intl. J. Digit. Libr. Serv. 3:38-52.

 
 

Lwoga ET, Sife AS (2014). Research productivity and Web Visibility of Dental Faculty in Tanzania: A scientometric analysis. In: 2nd MUHAS Scientific Conference 14th-15th May 2014, Dar es Salaam, Tanzania.

 
 

Mongeon P, Paul-Hus A (2016). The journal coverage of Web of Science and Scopus: a comparative analysis. Scientometrics 106:213-228.
Crossref

 
 

Nature (2015). Africa. Nature 522:S28–S29. http://www.nature.com/nature/journal/v522/n7556_supp/full/522S28a.html?foxtrotcallback=true

 
 

Onyancha OB (2016). Open Research Data in Sub-Saharan Africa: A Bibliometric Study Using the Data Citation Index. Publ. Res. Q. 32:227-246.
Crossref

 
 

Onyancha OB, Maluleka JR (2011). Knowledge production through collaborative research in sub-Saharan Africa: How much do countries contribute to each other's knowledge output and citation impact? Scientometrics 87:315-336.
Crossref

 
 

Onyancha OB, Ocholla DN (2009). Assessing researchers' performance in developing countries: Is google scholar an alternative? Mousaion 27:43-64.

 
 

Perron BE, Victor BG, Hodge DR, Salas-Wright CP, Vaughn MG, Taylor RJ (2016). Laying the Foundations for Scientometric Research: A Data Science Approach. Res. Soc. Work Pract. 
Crossref

 
 

Pouris A (2010). A scientometric assessment of the Southern Africa Development Community: science in the tip of Africa. Scientometrics 85:145-154.
Crossref

 
 

Pouris A (2012). Scientometric research in South Africa and successful policy instruments. Scientometrics 91:317-325.
Crossref

 
 

Pouris A (2015). An assessment of South Africa's research journals: Impact factors, Eigenfactors and structure of editorial boards. S. Afr. J. Sci. 111:1-8.
Crossref

 
 

Pouris A, Ho Yuh-Shan (2014). Research emphasis and collaboration in Africa. Scientometrics 98:2169-2184.
Crossref

 
 

Ramkumar S, Narayanasamy, N, Nageswara RP (2016). Collaboration trend in speech, language and hearing sciences: A scientometric study based on select journals. Intl. J. Educ. Multidiscip. Stud. 3(3):2455-2526.
Crossref

 
 

Ranking web of Universities United Republic of Tanzania (2016). November 03rd. Retrieved from 

View

 
 

Schemm Y (2013). Africa doubles research output over past decade, moves towards a knowledge-based economy. Res. Trends pp. 11-12.

 
 

Sidiropoulos A, Katsaros D, Manolopoulos Y (2007). Generalized Hirsch h-index for disclosing latent facts in citation networks. Scientometrics 72:253-280.
Crossref

 
 

Sife A, Bernard RB (2016). Scientometric Portrait of Prof. Rudovick R. Kazwala: A Public Health Veterinarian. Intl. J. Libr. Inf. Stud. 6:63-76.

 
 

Sife ASAS, Bernard R, Ernest EE, Benard R (2013). Research productivity and scholarly impact of forestry researchers at Sokoine University of Agriculture: A bibliometric Analysis. J. Contin. Educ. Ext. 4:261-278.

 
 

Sife AS, Lwoga ET, Said SA, Tandi LE (2014). Publication productivity and scholarly impact of academic librarians in Tanzania. New Libr. World 115:527-541.
Crossref

 
 

Smith D, Katz JS (2000). Collaborative Approaches to Research. A report to the Higher Education Funding Council for England. Centre for Policy Studies in Education, University of Leeds. ISBN 085316: 214.

 
 

The Citizen Magazine (2016). Industrial policy execution Tanzania's big challenge. Retrieved from 

View.

 
 

The United Republic of Tanzania (2010). The National Research and Development Policy. 

View

 
 

Toivanen H, Ponomariov B (2011). African regional innovation systems: Bibliometric analysis of research collaboration patterns 2005-2009. Scientometrics 88:471-493.
Crossref

 
 

United Nations (2015). Sustainable development goals. Retrieved from 

View

 

 


APA Sangeda, R. Z., & Lwoga, E. T. (2017). Research growth and citation impact of Tanzanian scholars: A 24 year’s scientometric study. International Journal of Library and Information Science, 9(8), 66-77.
Chicago Raphael Z. Sangeda and Edda Tandi Lwoga. "Research growth and citation impact of Tanzanian scholars: A 24 year’s scientometric study." International Journal of Library and Information Science 9, no. 8 (2017): 66-77.
MLA Raphael Z. Sangeda and Edda Tandi Lwoga. "Research growth and citation impact of Tanzanian scholars: A 24 year’s scientometric study." International Journal of Library and Information Science 9.8 (2017): 66-77.
   
DOI 10.5897/IJLIS2017.0786
URL http://www.academicjournals.org/journal/IJLIS/article-abstract/B8E9DF065829

Subscription Form

(default) 34 queries took 7403 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` = 'IJLIS' LIMIT 1111
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` = (69)75750
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` = (69)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` = (69)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` = 69 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` = 69 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` = (9102)220
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` =69 AND `Article`.`published` = 1111
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` = 'B8E9DF065829' 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` = (1009960161)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` = (1009960161)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` = (1009960161)220
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` = (1009960161)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` = 9102 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` = (9102)220
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` = 1009960161 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 1003654
18BEGIN003654
19INSERT INTO `admin_academic_journals`.`article_metrics` (`read_t`, `count`, `article_id`, `ip`, `country`, `region`, `continent`, `modified`, `created`) VALUES ('article-abstract', 1, 1009960161, '54.159.113.182', 'United States', 'Virginia', 'North America', '2017-09-20 01:39:06', '2017-09-20 01:39:06')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` = 9102 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` = 9102 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` = 69 LIMIT 1110