African Journal of Business Management
Subscribe to AJBM
Full Name*
Email Address*

Article Number - 6A2270A65830


Vol.11(17), pp. 426-437 , September 2017
DOI: 10.5897/AJBM2017.8286
ISSN: 1993-8233



Full Length Research Paper

Development of market opportunities through post-harvest processing of the African indigenous vegetables in Tanzania



Richard Musebe
  • Richard Musebe
  • Centre for Agriculture and Biosciences International (CABI) Africa P.O. Box 633-00621 Nairobi-Kenya.
  • Google Scholar
Daniel Karanja
  • Daniel Karanja
  • Centre for Agriculture and Biosciences International (CABI) Africa P.O. Box 633-00621 Nairobi-Kenya.
  • Google Scholar
Srinivasulu Rajendran
  • Srinivasulu Rajendran
  • World Vegetable Center, Duluti, P. O. Box 10 Arusha-Tanzania.
  • Google Scholar
Radegunda Kessy
  • Radegunda Kessy
  • World Vegetable Center, Duluti, P. O. Box 10 Arusha-Tanzania.
  • Google Scholar
Monica Kansiime
  • Monica Kansiime
  • Centre for Agriculture and Biosciences International (CABI) Africa P.O. Box 633-00621 Nairobi-Kenya.
  • Google Scholar
Damas Marandu
  • Damas Marandu
  • Horticultural Research and Training Institute (HORTI) Tengeru P. O. BOX 1253, Arusha-Tanzania.
  • Google Scholar
Silivesta Samali
  • Silivesta Samali
  • Horticultural Research and Training Institute (HORTI) Tengeru P. O. BOX 1253, Arusha-Tanzania.
  • Google Scholar
Jacqueline Nicodemus
  • Jacqueline Nicodemus
  • INADES Formation P. O. Box 203 Dodoma-Tanzania.
  • Google Scholar
Ngoni Nenguwo
  • Ngoni Nenguwo
  • World Vegetable Center, Duluti, P. O. Box 10 Arusha-Tanzania.
  • Google Scholar
Ruth Chiwanga
  • Ruth Chiwanga
  • INADES Formation P. O. Box 203 Dodoma-Tanzania.
  • Google Scholar
Peter Makuya
  • Peter Makuya
  • INADES Formation P. O. Box 203 Dodoma-Tanzania.
  • Google Scholar







 Received: 02 March 2017  Accepted: 26 July 2017  Published: 14 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


African indigenous vegetables (AIVs) have gained prominence in the recent past due to nutritional and health benefits. The low requirement for high value inputs has enabled low resource farmers to practice AIVs production. There have been improvements in the production of high quality AIVs seeds as well as more production of the AIVs leaf and fruits. As a consequence, there are occasional gluts of the AIVs leaf and fruit especially during the main production season. This study examined the challenges associated with production of processed AIVs and possible market opportunities using data from 10 AIVs processing groups and 21 key informants that were purposively selected. Data were analysed using descriptive statistics and thematic analysis. It was established that processors did not have the necessary skills, knowledge and training required for processing of AIVs in more economically attractive ways. There was no diversity in the processing methods and processed products. Types and sources of packaging materials were restricted in various respects. Processors did not have special storage facilities for the AIVs. The share of processed AIVs in the total consumption of the vegetables was 25%. Sixty percent of those interviewed stated that the demand for all types of processed AIVs was increasing. Many institutions were supporting processing of AIVs. Quality of processed AIVs was perceived to be same as that of the fresh AIVs. Consumers were willing to pay more money for better quality processed AIVs. In order to increase sales of processed AIVs there should be informal agreements, partnerships or contracts depending on the degree of relationship between processors and consumers to guarantee target markets. Tanzania Bureau of Standard (TBS) and Tanzania Food and Drugs Authority (TFDA) need to create awareness regarding the specific quality requirements for processed AIVs. Training should be provided on different processing methods and the range of products that could be produced for different consumers. There should be financial support and/or linking of processors with the different credit institutions. It is necessary to provide processing infrastructure and training on marketing of the processed products. Specific requirements for the premises, processing rooms and standards should be explained to the processors to assure the requisite quality. Product branding has to be undertaken especially at two levels, which are indicating the key attributes of AIVs on the packages and certification by TBS and TFDA as well as having their labels on the containers of the packed products.

Key words: Vegetables, processors, quality, storage, demand, target markets.

Abukutsa-Onyango MO, Tushaboomwe K, Onyango JC, Macha SE (2006). Improved community land use for sustainable production and utilization of African indigenous vegetables in the Lake Victoria region. In: Proceedings of the Fifth Workshop on Sustainable Horticultural Production in the Tropics, 23rd-26th November 2005, ARC, Egerton University, Njoro. pp. 167-179

 

Ambrose-Oji B (2012). Urban Food Systems and African Indigenous Vegetables in Urban and Per-urban Agriculture. In: Shackleton, C.M., Pasquin, M.W. and Drescher, A.W. (Eds.) African Indigenous Vegetables in urban Agriculture. London: Earthscan. pp. 1-34.

 

Bawden R, Sterns PA, Harris S, Berdegue J (2002). Increasing Rural Household Incomes in Kenya through Horticulture. A Design Proposal. A Report Prepared for USAID Kenya.

 

ESRF (Economic and social research foundation. (2010). Strengthening micro-enterprises in Tanzania: The case of small-scale vegetable farmers in Arusha. Economic and Social Research Foundation (ESRF). Final Report, April 2010.

 

Edmond R, Johan MM, Gema N (2008). Dried Fruit and Vegetables for Urban and Export Markets Sub Sector and Value Chain Analysis Tanzania. Final Rep. 47 p.

 

Gilbert M, Ralph LR, Chris W, Mwangi S (2011). African indigenous vegetable enterprises and market access for small-scale farmers in East Africa. Int. J. Agr. Sustain. 9(1):194-202.
Crossref

 

Habwe FO, Walingo KM, Onyango MOA (2008). Food Processing and Preparation Technologies for Sustainable Utilization of African Indigenous Vegetables for Nutrition Security and Wealth Creation in Kenya. In: Robertson, G.L. & Lupien, J.R. (Eds.), Using Food Science and Technology to Improve Nutrition and Promote National Development (Chapter 13) International Union of Food Science & Technology.

 

Hassan SW, Umar RA, Maishanu HM, Matazu IK, Faruk UZ, Sani AA (2007). The effects of drying method on nutrients and non-nutrients composition of leaves of Gynandropsis gynandra (Capparaceae). Asian J. Biochem. 2(5):349-353
Crossref

 

James A, Matemu A (2016). Solar-Drying of Vegetables for Micronutrients Retention and Product Diversification. Am. J. Res. Commun. 4(8):1-13.

 

Karanja D, Okoko N, Kiptarus E, Okongo P, Samali S, Katunzi A, Mtwaenzi H, Mwakitwange F, Afari- Sefa V, Musebe R, Kimani M, Kimenye L (2011). Promoting farmer-led seed enterprises of African indigenous vegetables to boost household incomes and nutrition in Kenya and Tanzania.

 

Karanja DD, Kansiime M, Nicodemus J, Kessy RF, Afari-sefa V, Marandu D, Samali S, Swarbrick P, Romney D (2014). Good seed for quality produce: Indigenous vegetables boost farmer incomes and livelihoods in Tanzania. CABI Impact Case Study No. 17, 8 p.

 

Lotter DW, Marshall MI, Welle S, Mugisha A (2014). African Indigenous and traditional Vegetables in Tanzania: Production, Post-Harvest Management and Marketing. Afr. Crop Sci. J. 22(3):181-189.

 

Marg L, Peniel U, Henri van der L (2008). High value and fresh vegetables for Local market sub sector analysis, Tanzania. Study commissioned by small and medium enterprise competitiveness facility and conducted by match maker associates limited (MMA). January 2008, final draft, 55p.

 

Ngugi IK, Gitau R, Nyoro J (2007). Access to high value markets by smallholder farmers of African indigenous vegetables in Kenya, Regoverning Markets Innovative Practice series, IIED: London.

 

Okado M (2000). Background Paper on Kenya Off-Season and Specialty Fresh Vegetables and Fruits: Lessons of experience from the Kenyan Horticultural Industry. United Nations Conference in Trade and Development.

 

Osano ZS (2010). Market Chain Analysis of African Indigenous Vegetables (AIVs) in Tanzania: A Case Study of African Eggplant (Solanum Aethiopicum) In Kahama District, Tanzania. A Dissertation Submitted in Partial Fulfilment of the Requirements for the Degree of Master of Art in Rural Development of Sokoine University of Agriculture, Morogoro, Tanzania.

 

Putter H, Koesveld MJ, de Visser CLM (2007).Overview of the vegetable sector in Tanzania. Indian J. Agric. Econ. 56(4):668-680.

 

Rajendran S, Afari-Sefa V, Karanja DK, Musebe R, Romney D, Makaranga MA, Samali S, Kessy RF (2015). Technical efficiency of traditional African vegetable production: A case study of smallholders in Tanzania. J. Dev. Agric. Econ. 7(3):92-99.
Crossref

 

Rajendran S, Afari-Sefa V, Karanja D.K., Musebe R, Romney D, Makaranga MA, Samali S, Kessy RF (2016). Farmer-led Seed Enterprise Initiatives to Access Certified Seed for Traditional African Vegetables and its Effect on Incomes in Tanzania. Int. Food Agribusiness Manage. Rev. 19(1):1-24.

 

Scott GJ (1995). Prices, Products and People: Analyzing Agricultural Markets in Developing Countries. Lynne Reinner Publishers: Boulder, London.

 

Shazia K, Anwar FC, Dilawar K, Bushra K (2007). Estimation of demand for processed fruit and vegetable products in Hayatabad, Peshawar. Sarhad J. Agric. 23(4):1273-1278.

 

Shiundu KM, Oniang'o RK (2007). Marketing African Leafy Vegetables: Challenges and Opportunities in the Kenyan Context. Afr. J. Food Agric. Nutr. Dev. 7(4):1-17

 

Takemore C, Victor AS, Raul P (2014). Value Chain Analysis of Traditional Vegetables from Malawi and Mozambique. Int. Food Agribus. Manage. Rev. 17(4):57-84.

 

Ukegbu PO, Okereke CJ (2013). Effect of solar and sun drying methods on the nutrient composition and microbial load in selected vegetables, African spinach (Amaranthus hybridus), fluted pumpkin (Telferia occidentalis), and okra (Hibiscus esculentus). Sky J. Food Sci. 2(5):35-40.

 

Van den Berge M, Boomsma M, Cucco I, Cuna L, Janssen N, Moustier P, Prota L, Purcell T, Smith D, van Wijk S (2005). Making Value Chain Work Better for the Poor. A Toolbook for Practitioners of Value Chain Analysis. 

View

 

Vivian FB, Bismark A, Abdul- Halim A, Osei BY (2016). Do marketing margins determine local leafy vegetables marketing in the Tamale Metropolis? Afr. J. Bus. Manage.10 (5):98-108.
Crossref

 

Wiley RC (1994). Preservation methods for minimally processed refrigerated fruits and vegetables. In: Wiley R C. (eds.); minimally processed refrigerated fruits and vegetables. Chapman & Hall, NewYork, USA, pp. 66-134.
Crossref

 


APA Musebe, R., Karanja, D., Rajendran, S., Kessy, R., Kansiime, M., Marandu, D., Samali, S., Nicodemus, J., Nenguwo, N., Chiwanga, R., & Makuya, P. (2017). Development of market opportunities through post-harvest processing of the African indigenous vegetables in Tanzania. African Journal of Business Management, 11(17), 426-437.
Chicago Richard Musebe, Daniel Karanja, Srinivasulu Rajendran, Radegunda Kessy, Monica Kansiime, Damas Marandu, Silivesta Samali, Jacqueline Nicodemus, Ngoni Nenguwo, Ruth Chiwanga and Peter Makuya. "Development of market opportunities through post-harvest processing of the African indigenous vegetables in Tanzania." African Journal of Business Management 11, no. 17 (2017): 426-437.
MLA Richard Musebe, et al. "Development of market opportunities through post-harvest processing of the African indigenous vegetables in Tanzania." African Journal of Business Management 11.17 (2017): 426-437.
   
DOI 10.5897/AJBM2017.8286
URL http://www.academicjournals.org/journal/AJBM/article-abstract/6A2270A65830

Subscription Form

(default) 34 queries took 13619 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` = 'AJBM' 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` = (41)2722720
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` = (41)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` = (41)110
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` = 41 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` = 41 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` = (9103)440
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` =41 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` = '6A2270A65830' 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` = (1009960162)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` = (1009960162)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` = (1009960162)11110
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` = (1009960162)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` = 9103 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` = (9103)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` = 1009960162 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 1006763
18BEGIN006763
19INSERT INTO `admin_academic_journals`.`article_metrics` (`read_t`, `count`, `article_id`, `ip`, `country`, `region`, `continent`, `modified`, `created`) VALUES ('article-abstract', 1, 1009960162, '54.159.113.182', 'United States', 'Virginia', 'North America', '2017-09-20 01:44:55', '2017-09-20 01:44:55')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` = 9103 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` = 9103 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` = 41 LIMIT 1110