Journal of Geography and Regional Planning
Subscribe to JGRP
Full Name*
Email Address*

Article Number - 5B5442D65909


Vol.10(10), pp. 266-277 , October 2017
DOI: 10.5897/JGRP2017.0648
ISSN: 2070-1845



Full Length Research Paper

Spatial suitability for urban sustainable densification in a borderland city



Erick Sánchez Flores
  • Erick Sánchez Flores
  • Department of Architecture, Universidad Autónoma de Ciudad Juárez, Av. Del Charro 450 N. Ciudad Juárez, Chih, 32310, Mexico.
  • Google Scholar
Marisol Rodríguez Sosa
  • Marisol Rodríguez Sosa
  • Department of Architecture, Universidad Autónoma de Ciudad Juárez, Av. Del Charro 450 N. Ciudad Juárez, Chih, 32310, Mexico.
  • Google Scholar







 Received: 03 June 2017  Accepted: 24 August 2017  Published: 31 October 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 traditional approach to pursuit of sustainable urban development involves an integrated, long-term planning process based on a series of environmental, economic, equity and livability societal values, for creating healthy and prosperous communities that not only meet the physical needs but also the aspirations of their residents. Urban land plays a central role as the material basis of this process; therefore, assessing its suitability for livable and sustainable conditions is critical in contemporary cities. The efficiency of different urban density and centralization patterns, making livable communities demands to avoid oppressively dense or overly scattered and fragmentary development was discussed. In this research, land suitability for urban densification in the border city of Ciudad Juárez, Chihuahua, based on a spatial multi criteria analysis (SMCA) of environment, economy, equity and livability variables were assessed. The result model for each group variables showed that suitable areas for densification are associated with the consolidated part of the city. The main variables affecting suitability distribution in an integrated model were distance of public transportation routes, location of poverty zones and land values. Selecting potential areas for densification derived from this analysis requires appropriate strategies for affordable, diverse and accessible housing provision, which contributes to the creation of livable sustainable communities.

Key words: Urban densification, spatial multi criteria analysis, land suitability.

Alexander C, Ishikawa S, Silverstein M (1977). A Pattern Language: Towns, Buildings, Construction, New York: Oxford University Press.

 

Allen J, Lu K (2003). Modeling and prediction of future urban growth in the Charleston region of South Carolina: a GIS-based integrated approach. Conserv. Ecol. 8(2):20. 
Crossref

 

American Library Association (2006). Three Dynamics of Sustainable Communities: Economy, Ecology, and Equity. 29 de November de 

View

 

Barnett J (2003). Redesigning cities. Principles, practice and implementation. Chicago: American Planning Association.

 

Berke PR., David R. Goldschalk E, Kaiser J, Rodriguez D (2006). Urban land use planning. 5th ed. Urbana/Chicago, Illinois: University of Illinois Press.

 

Bohl C (2002). Place making: Developing town centers, main streets, and urban villages. Washington, D.C.: Urban Land Institute.

 

Brendel P, Molnar J (2010). City plans commuter rail TOD. News, Jersey Village.

 

Brinkman J (2016). Congestion, agglomeration, and the structure of cities. J. Urb. Econ. 94:13-31. 
Crossref

 

Burchell R W, Lowenstein G, Dolphin WR, Galley CC, Downs A, Seskin S, Still KG, Moore T (2002). Costs of Sprawl - 2000. Transit Cooperative Research Program (TCRP), Washington: Transportation Research Board.

 

Burgess R (2002). The Compact City Debate: A Global Perspective. in Compact Cities: Sustainable Urban Forms for Developing Countries, by Burgess R, Jenks M, 22-37. London: Spoon Press. View

 

Burgess R, Jenks M (2000). Compact Cities: Sustainable Urban Forms for Developing Countries. London: Spoon Press. 

View

 

Burton E, Jenks M, Williams K (2004). The Compact City: A Sustainable Urban Form? New York: Taylor & Francis. 

View

 

Burton E, Jenks M, Williams K (2013). Achieving Sustainable Urban Form. London: Routledge.

View

 

Caicedo JF, (2015). Growing or filling the city? Taking the debate on densification South. School of Urban Affairs, Sciences Po Paris.

 

Carr, MH, Zwick PD (2007). Smart land-use analysis. The LUCIS model land-use conflict identification strategy. Redlands: ESRI. 
Crossref

 

Carruthers JI, Ulfarsson GF (2003). Urban Sprawl and the Cost of Public Services. Environ. Plan. B: Urb. Analyt. City Sci. 30(4):503-522. 

View

 

Comisión Federal de Electricidad (CFE) (2014). Derecho de vía, Norma de referecia NRF-014-CFE. Ciudad de México: Diario Oficial.

 

Chen J (2014). GIS-based multi-criteria analysis for land use suitability assessment in city of Regina. Environ Syst. Res. 3(13):1-10. 
Crossref

 

Comisión Reguladora de Energía (2001). Modificaciones la Norma Oficial Mexicana NOM-007-SECRE-199, Transporte de gas natural. Ciudad de México: Diario Oficial.

 

Curtis C, Renne LJ, Bertolini L (2009). Transit Oriented Development: Making it Happen. Burlington: Ashgate Publishing Company. 

View

 

Duany Plater-Zyberk & Company (DPZ) (n.d). Smart Code version 9.2. Center for Applied Transect Studies (CATS), The Town Paper Pub, 72 p.

 

Duany A, Speck J, Lydon M (2010). The Smart Growth Manual. New York: McGraw Hill.

 

Ewing R, Schmid T, Killingsworth R, Zlot A, Raudenbush S (2003). Relationship between Urban Sprawl and Physical Activity, Obesity, and Morbidity. Am. J. Health Prom. 18(1):47-57. 
Crossref

 

Fataar R (2016), Densification and the ambition for a democratic city. Our Future Cities NPO, Cape Town: ETH Zürich.

 

Frumkin H (2002). Urban sprawl and public health. Pub. Health Rep. 117(3):201-217. 
Crossref

 

Geddes P (1916). Cities in evolution. An Introduction to the Town Planning Movement and to the Study of Civics. London: Williams & Norgate. 

View

 

Godschalk DR (2004). Land Use Planning Challenges: Coping with Conflicts in Visions of Sustainable Development and Livable Communities. J. Am. Plan. Assoc. 70(1): 5-13. 
Crossref

 

Goodwill J, Hendricks SJ (2002). Building transit oriented development in established communities. Tampa, FL: Center for Urban Transportation and Research.

 

Gordon P, Richardson HW (1997). Are Compact Cities a Desirable Planning Goal?. J. Am. Plan. Assoc. 63(1):95-106. 
Crossref

 

Holmes J, Van Hemert J (2008). Transit oriented development. 

 

IMIP (2010). PDU Plan de Desarrollo Urbano. Ciudad Juárez 2010. Ciudad Juárez: Ayuntamiento de Juárez - Intituto Municipal de Investigación y Planeación.

 

IMIP (2009). Polígonos de probreza Ciudad Juárez. Instituto Municipal de Investigación y Planeación, Ciudad Juárez: H. Ayuntamiento de Juárez.

 

INEGI (2010). Censo Nacional de Población y Vivienda 2010.

 

INEGI (2016) Directorio Estadístico Nacional de Unidades Económicas (DENUE). (accessed 16 de 04 de 2016).

 

INEGI (2015). Estadística Mensual del Programa de la Industria Manufacturera, Maquiladora y de Servicios de Exportación. Aguascalientes, AGS.

 

Irwin EG, Bockstael NE (2004). Land use externalities, open space preservation, and urban sprawl. Reg. Sci. Urb. Econ. 34(6):705-725.
Crossref

 

Jafari S, Zaredar N (2010). Land Suitability Analysis using Multi Attribute Decision Making Approach. Int. J. Environ. Sci. Dev. 1(5):441.445. 
Crossref

 

Johnson MP (2001). Environmental Impacts of Urban Sprawl: A Survey of the Literature and Proposed Research Agenda. Environ. Plan A 33(4):717-735. 
Crossref

 

Kennedy C, Pincetl S, Bunje P (2011). The study of urban metabolism and its applications to urban planning and design. Environ. Pollution 167:184-185.
Crossref

 

Levy JM (2016). Contemporary urban planning. London and New York: Routledge.

 

Logan JR, Molotch H (2007). Urban Fortunes: The Political Economy of Place. Berkeley: The Uiniversity of California Press.

 

Malczewski J (2004). GIS-based land suitability analysis: A critical overview. Progr. Plan. 62(1):3-65. 
Crossref

 

McKendry C, Nick J (2015). Greening the industrial city: equity, environment, and economic growth in Seattle and Chicago. Int. Env. Agree: Poli. Law Econ. 15: 45-60. 
Crossref

 

Neuman M (2005). The Compact City Fallacy. J. Plan. Edu. Res. 21(1):11-26. 
Crossref

 

Sánchez Flores E, Maycotte Pansza E, Chávez J. (2016). Spatial patterns of social mobility perception derived from acess to scial housing in a Mexican border city. 11th CTV Back to the sense of the city. Cracow: UPC. 1326-1345. 

View

 

Samad RB, Morshed KM. (2016). GIS Based Analysis for Developing Residential Land Suitability. J. Settlem. Spatial Plan. 7(1):23-34. 

View

 

SEDATU-CONAVI (2015). Modelo geoestadístico para la actualización de los polígonos de conteción urbana 2015. Ciudad de México.

 

SEDESOL (2011). Atlas de riesgos de Ciudad Juárez, Chihuahua. Actualización 2010. Instituto Municipal de Investigación y Planeación, Ciudad Juárez.

 

Witten K, Exeter D, Field A (2003). The Quality of Urban Environments: Mapping Variation in Access to Community Resources. Urb. Stud. pp. 161-177. 
Crossref

 

Zhao P (2010). Sustainable urban expansion and transportation in a growing megacity: Consequences of urban sprawl for mobility on the urban fringe of Beijing. Hab. Int. 34(2):236-243. 
Crossref

 


APA Flores, E. S., & Sosa, M. R. (2017). Spatial suitability for urban sustainable densification in a borderland city. Journal of Geography and Regional Planning, 10(10), 266-277.
Chicago Erick S&anchez Flores and Marisol Rodr&iguez Sosa. "Spatial suitability for urban sustainable densification in a borderland city." Journal of Geography and Regional Planning 10, no. 10 (2017): 266-277.
MLA Erick S&anchez Flores and Marisol Rodr&iguez Sosa. "Spatial suitability for urban sustainable densification in a borderland city." Journal of Geography and Regional Planning 10.10 (2017): 266-277.
   
DOI 10.5897/JGRP2017.0648
URL http://www.academicjournals.org/journal/JGRP/article-abstract/5B5442D65909

Subscription Form

(default) 34 queries took 9129 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` = 'JGRP' 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` = (37)1151151
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` = (37)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` = (37)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` = 37 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` = 37 AND `JournalIssue`.`current_issue` = '1' ORDER BY `JournalIssue`.`created` DESC, `JournalIssue`.`month` DESC LIMIT 1111
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` = (9121)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` =37 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` = '5B5442D65909' 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` = (1009960241)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` = (1009960241)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` = (1009960241)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` = (1009960241)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` = 9121 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` = (9121)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` = 1009960241 AND `ArticleMetric`.`read_t` = 'article-abstract' AND `ArticleMetric`.`ip` = '54.225.39.142' AND DATE_FORMAT(`ArticleMetric`.`created`, '%Y-%m-%d') = '2017-09-20' LIMIT 1003680
18BEGIN003680
19INSERT INTO `admin_academic_journals`.`article_metrics` (`read_t`, `count`, `article_id`, `ip`, `country`, `region`, `continent`, `modified`, `created`) VALUES ('article-abstract', 1, 1009960241, '54.225.39.142', 'United States', 'Virginia', 'North America', '2017-09-20 05:13:12', '2017-09-20 05:13:12')11836
20COMMIT11836
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` = 9121 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` = 9121 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` = 37 LIMIT 1110