Journal of Plant Breeding and Crop Science
Subscribe to JPBCS
Full Name*
Email Address*

Article Number - AFCAE0D65721


Vol.9(9), pp. 151-159 , September 2017
DOI: 10.5897/JPBCS2017.0674
ISSN: 2006-9758



Full Length Research Paper

Evaluation of seventy six sugarcane families at early selection stages



Eid M. Mehareb
  • Eid M. Mehareb
  • Sugar Crops Research Institute, Agriculture Research Center, Egypt.
  • Google Scholar
Yang kun
  • Yang kun
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar
Zhao Jun
  • Zhao Jun
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar
Fouz F Aboelenen
  • Fouz F Aboelenen
  • Sugar Crops Research Institute, Agriculture Research Center, Egypt.
  • Google Scholar
Qing Wei
  • Qing Wei
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar
Zhan Fenggang
  • Zhan Fenggang
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar
Liu Jiayong
  • Liu Jiayong
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar
Xia Hongming
  • Xia Hongming
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar
Yao Li
  • Yao Li
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar
Zhao Peifang
  • Zhao Peifang
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar
Zhao Yong
  • Zhao Yong
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar
Wu Caiwen
  • Wu Caiwen
  • Sugarcane Research Institute, Yunnan Academy of Agriculture Science, China.
  • Google Scholar







 Received: 19 June 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


An experiment was conducted on sugarcane families belonging to the early selection stage of the Sugarcane Research Institute, Kaiyuan, Yunnan Academy, China, to evaluate them for the selection of superior families for the later stages of the breeding program. Seventy-six full-sib families and check variety were evaluated. The experiment was conducted during two growing seasons, corresponding to the plant cane and first ratoon, 2015/2016 and 2016/2017, respectively. The traits of cane yield (TCH) and juice quality were measured. Results indicate the use of the traits with high heritability as selection criteria together with sugar yield (TSH) could lead to genetic improvement in TSH.  The study indicated that high estimates of genotypic coefficient of variation (GCV) and phenotypic coefficient of variation (PCV) were recorded for stalks (21.12 and 25.10), TCH (22.85 and 27.74), TSH (22.66 and 28.08). The results also revealed that seven families viz., LC03-1137×YZ89-7, LC03-1137×PS45, YT93-159×YR11-95, YR05-346×YZ05-51, FN38×GT96-211, YR10-509×FR96-405 and YT03-373×YR08-1276  were the best families across all other bi-parental families for most studied traits at early selection stages suggesting the possibility of evaluation of a large number of clones of these families, followed by selection of superior clones within these families during the next selection stages.

 

Key words: Sugarcane, family selection, heritability, genotypic coefficient of variation (GCV), phenotypic coefficient of variation (PCV), plant cane, first ratoon.

Agrawal KB (2003). Estimates of variation and heritability of some quantitative characters in sugarcane. Ann. Agric. Res. 24(2):379-382.

 

Allard RW (1960). Principles of Plant Breeding. John Willey and Sons, New York. P 485.

 
 

Butterfield MK, Nuss KJ (2002). Prospects for new varieties in the medium to long term, the effects of current and future breeding strategy on variety characteristics.

 
 

Cox MC, Hogarth DM (1993). Progress and changes in the south Queensland variety development program. Proc. Int. Soc. Sugarcane Technol. 15:251-255.

 
 

Delvadia DR, Patel AD (2006). Genetic variability and heritability in sugarcane. Madras Agric. J. 93(7-12):165-168.

 
 

Freed R, Eisensmith SP, Goetz S, Reicosky D, Smail VW (1989). User's Guide to MSTAT-C. Dept. of Crop and Soil Sciences and Dept. of Agricultural Economics. Michigan State University.

 
 

Gomez KA, Gomez AA (1984). Statistical Procedures for Agricultural Researches.2nd Ed., John Wiley & Sons, New York U.S.A., pp. 97-107.

 
 

Gupta RK, Chatterjee A (2002). Study on some genetic parameters and its implication in selection of sugarcane (Saccharum officinarum). Cooper. Sugar 33(10):823-826.

 
 

Kimbeng CA, Cox MC (2003). Early generation selection of sugarcane families and clones in Australia. J. Am. Soc. Sugarcane Technol. 23:20-39.

 
 

Mahmoud EA, El-Hinnawy HH, Masri MI, Mohamed BD, Mehareb EM (2012). Performance and repeatability for some agronomic traits in sugarcane crosses at early selection stages. Egypt. J. Plant Breed. 16 (2):237-255
Crossref

 
 

Mehareb EM, Abou-Elwafa SF, Galal MOA (2015). Comparative Performance of sugarcane genotypes for ratoon ability in early clonal selection stages. J. Sugarcane Res. 5(2):11-21.

 
 

Mehareb EM, Abazied, SR (2017). Genetic Variability of Some Promising Sugarcane Varieties (Saccharum spp) under Harvesting Ages for Juice Quality Traits, Cane and TSH. Open Access J. Agric. Res. 2(2):1-14.

 
 

Oliveira RAD, Daros E, Bespalhok FJC, Zambon JLC, Ido OT, Weber H, Resende, MDVD and Neto HZ (2009). Selection of sugarcane families by mixed models. Sci. Agrar. 9(3):269-274.

 
 

Patel KC, Mali SC, Patel DU, Vashi RD (2006). Variability, correlation and path analysis in sugarcane (Saccharum spp.). Crop Res. (Hisar) 32(2):213-218.

 
 

Robinson HF, Comstock RE, Harvey PH (1949). Estimates of heritability and the degree of dominance in corn. Agron. J. 41:353-359.
Crossref

 
 

Shanthi RM, Bhagyalakshmi KV, Hemaprabha G, Alarmelu S, Nagarajan R (2008). Relative performance of the sugarcane families in early selection stages. Sugar Technol. 10(2):114-118.
Crossref

 
 

Shivasubramanian S, Menon M (1973). Heterosis and inbreeding depression in rice. Madras Agric. J. 60:1139.

 
 

Silva MA, Landell MGA, Goncalves PS, Martins ALM (2002). Yield components in sugarcane families at four locations in the state of Sao Paulo, Brazil. Crop Breed. Appl. Biotechnol. 2(1):97-106.
Crossref

 
 

Singh R, Sangwan RS (1980). Studies on genetic variability for stalk characters in sugarcane. Ind. Sugar 30:409-412.

 
 

Skinner JC, Hogarth DM, Wu KK (1987). Selection Methods Criteria and Indices. In: Heinz, D. J. ed Sugarcane Improvement through Breeding. Amsterdam: Elsevier. pp 409-453.
Crossref

 
 

Skinner JC (1982). Efficiency of bunch planted and single planted "seedlings" for selection of superior families in sugarcane. Euphytica 31:523-537.
Crossref

 
 

Stringer JK, Cox MC, Atkin FC, Wei X, Hogarth DM (2010). Family selection improves the efficiency and effectiveness of selecting original seedlings and parents. Proc. Int. Soc. Sugarcane Technol. 27:1-9.

 
 

Tahir M, Khalil IH, McCord PH, Glaz B, Todd J (2014). Phenotypic selection of sugarcane (Saccharum spp.) genotypes using best linear unbiased predictors. J. Am. Soc. Sugar Cane Technol. 34:44-56.

 
 

Vidya KL, Oommen SK, Vijayaraghava K (2002). Genetic variability and heritability of yield and related characters in yard-long bean. J. Trop. Agric. 40:11-13.

 
 

Wu C, Wang Y, Xia H, Li F, Yang K, Hou C, Liu J, Zhao J, Zhao P (2009). Research on Heritability and Combing Ability of Creation Parents in Yunnan Sugarcane. Southwest China J. Agric. Sci. 122(15):1274-1278.

 

 


APA Mehareb, E. M., kun, Y., Jun, Z., Aboelenen, F. F., Wei, Q., Fenggang, Z., Jiayong, L., Hongming, X., Li, Y., Peifang, Z., Yong, Z., & Caiwen, W. (2017). Evaluation of seventy six sugarcane families at early selection stages. Journal of Plant Breeding and Crop Science, 9(9), 151-159.
Chicago Eid M. Mehareb, Yang kun, Zhao Jun, Fouz  F Aboelenen, Qing Wei, Zhan Fenggang, Liu Jiayong,  Xia Hongming, Yao Li, Zhao Peifang, Zhao Yong and Wu Caiwen. "Evaluation of seventy six sugarcane families at early selection stages." Journal of Plant Breeding and Crop Science 9, no. 9 (2017): 151-159.
MLA Eid M. Mehareb, et al. "Evaluation of seventy six sugarcane families at early selection stages." Journal of Plant Breeding and Crop Science 9.9 (2017): 151-159.
   
DOI 10.5897/JPBCS2017.0674
URL http://www.academicjournals.org/journal/JPBCS/article-abstract/AFCAE0D65721

Subscription Form

(default) 34 queries took 7350 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` = 'JPBCS' 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` = (106)1051050
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` = (106)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` = (106)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` = 106 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` = 106 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` = (9082)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` =106 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` = 'AFCAE0D65721' LIMIT 11192
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` = (1009960051)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` = (1009960051)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` = (1009960051)12120
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` = (1009960051)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` = 9082 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` = (9082)330
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` = 1009960051 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 1003629
18BEGIN003629
19INSERT INTO `admin_academic_journals`.`article_metrics` (`read_t`, `count`, `article_id`, `ip`, `country`, `region`, `continent`, `modified`, `created`) VALUES ('article-abstract', 1, 1009960051, '54.159.113.182', 'United States', 'Virginia', 'North America', '2017-09-20 01:43:01', '2017-09-20 01:43:01')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` = 9082 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` = 9082 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` = 106 LIMIT 1110