NEES: A Database for Seismic Retrofit Construction Cost of Concrete and Steel Framed Schools in Iran

By Reza Jafarzadeh, Jason M. Ingham and Suzanne Wilkinson

View Data

Licensed under

Category

Databases

Published on

Abstract

 

Authors

The authors of this database are Reza Jafarzadeh (University of Auckland), Jason M. Ingham (University of Auckland) and Suzanne Wilkinson (University of Auckland). The database was published at NEEShub on December 09 2013 and has been reproduced here to preserve the data and ensure continued access.


Database

doi: 10.4231/D3959C774

Seismic retrofitting of existing structures is a key issue in any earthquake-prone region when considering the extensive damage and severe economic loss caused by previous strong ground motions (Nuti and Vanzi, 2003). Promoting and enhancing building owners' decisions to adopt earthquake risk preparedness measures are essential activities to reduce fatalities, damage to properties, and economic and social disruption in a seismic disaster (Egbelakin et al., 2011).

A report published by the California Seismic Safety Commission (1999) emphasized how seismic retrofit programs can greatly abate the potential devastating effects of earthquakes. Nevertheless, requiring improvements in a community's existing building stock is a difficult public policy decision, requiring careful engineering and economic analysis along with societal considerations (United States Government Accountability Office (GAO), 2007). People in geographic regions subject to seismic hazards are frequently faced with the decision of whether or not to retrofit existing structures in order to lower their potential losses due to earthquakes.

The cost of seismic retrofit is one of the key factors having a crucial role in making such a decision (FEMA 227, 1992). The database presented herein is a response to the need for a greater amount of reliable data when developing cost estimation models. Using a semi-structured questionnaire, a meticulous data collection effort in Iran led to the development of a large cost database comprised of information from 158 seismic retrofit projects. Each project pertained to a particular earthquake-prone public school building having a framed structure constructed of either reinforced concrete or structural steel. The comprehensive and reliability of the database is well described elsewhere that readers are encouraged to refer to for detailed information (e.g., Jafarzadeh, 2012).

Cost Data and its Determinants

The cost targeted in the database is the seismic retrofit net construction cost (RNCC) which is, by definition, the basic amount to be paid to a contractor(s) for executing seismic retrofit construction work. This amount was calculated by dividing the total seismic retrofit construction cost (SRCC) by cost coefficients considered for construction tender pricing. The RNCC is composed of two components, being the structural cost (SC) and the cover-up cost (CC). The SC arises from seismic retrofitting of elements which together constitute the seismic resisting system of a building (e.g., beams, columns, diaphragms, foundations), whereas the CC is associated with clean-up and construction finishing works. The database also includes the information for fourteen variables which are identified to have an impact on the prediction of the RNCC.

These variables are

  1. total plan area,
  2. number of stories,
  3. age,
  4. weight,
  5. compliancy with minimum seismic provisions as prescribed in the first in-place Iranian seismic design code,
  6. seismicity in terms of the design base acceleration (DBA) of an earthquake with a 475-year return period,
  7. soil type as determined by the average value of the shear wave velocity (Vs) in the top 30 meters of the site soil profile,
  8. building plan configuration, (9) building elevation configuration,
  9. seismic retrofit technique designed to increase seismic resistance,
  10. structural type in terms of presence or absence of a lateral-force-resisting system in an existing building,
  11. foundation type,
  12. floor and roof diaphragm type, and finally
  13. whether the retrofit solution was extended to the case of non-structural components, particularly infill walls.


For a given school, the data on the RNCC and its constituents, together with the fourteen identified cost governing variables were carefully extracted from the final documents developed by engineering consultants and enacted by the State Organization of School Renovation, Development and Mobilization (SOSRDM) through the seismic retrofit study of that particular school. The cost values in the research database were normalized to the base year 2008 and were expressed in U.S. dollars, using an exchange rate of U.S$1=10,000 Rials.

Database Significance

The importance of the database posted here is more pronounced by recognizing that, in comparison to other construction disciplines, less effort has been devoted in the literature to develop trustworthy seismic retrofit construction cost models on the basis of real historical data. This database was used as the backbone of two recent studies performed by Jafarzadeh et al. (2013a and b) in which parametric and non-parametric seismic retrofit construction cost models were developed using multi-linear regression analysis and artificial neural network technique, respectively. The database will provide value to those attempting to determine key variables that influence seismic retrofit cost, or to those comparing seismic retrofit practices and costs in different areas of the world.

Acknowledgement

The authors acknowledge the participation of companies and organizations permitting access to the records of school seismic retrofit projects that they have been involved with. With great gratitude, the first author would additionally like to acknowledge the financial support provided by Farasaz Industrial Group Ltd during the full term of this study.

References

  • California Seismic Safety Commission., 1999. >it>Earthquake Risk Management: Mitigation Success Stories.>/it> (SSC Report 99-05). Proposition 122 Seismic Retrofit Practices Improvement Program, Product 2.2 Earthquake Risk Management Tools for Decision-Makers, Prepared by EQE International, Inc. for the California Seismic Safety Commission, Oakland, California, United States.
  • Egbelakin, T., Wilkinson, S., Potangaroa, R., Ingham, J. M., 2011. Enhancing Seismic Risk Mitigation Decisions: A Motivational Approach. Construction Management and Economics, 29(10), 1003-1016.
  • Federal Emergency Management Agency (FEMA)., 1992. A Benefit-Cost Model for the Seismic Rehabilitation of Hazardous Buildings, Volume I: A User Manual (FEMA 227). Prepared by the VSP Associates, Inc. for FEMA, Washington, D.C., United States.
  • Jafarzadeh, R., 2012. Seismic Retrofit Cost Modelling of Existing Structures. Ph.D. Dissertation, The University of Auckland, Auckland, New Zealand.
  • Jafarzadeh, R., Ingham, J. M., Wilkinson, S., Gonzalez, V., and Aghakouchak, A. A., 2013a. Application of Artificial Neural Network Mrthodology for Predicting Seismic Retrofit Construction Cost. Journal of Construction Engineering and Management, DOI: 10.1061/(ASCE)CO.1943-7862.0000725.
  • Jafarzadeh, R., Wilkinson, S., Gonzalez, V., Ingham, J. M., and Ghodrati Amiri, G. R., 2013b. Predicting Seismic Retrofit Construction Cost for Buildings with Framed Structures Using Multi-Linear Regression Analysis. Journal of Construction Engineering and Management, DOI: 10.1061/(ASCE)CO.1943-7862.0000750.
  • Nuti, C., Vanzi, I., 2003. To Retrofit or Not to Retrofit? Engineering Structures, 25(6), 701-711.


United States Government Accountability Office., 2007. Natural Hazard Mitigation: Various Mitigation Efforts Exist, but Federal Efforts Do Not Provide a Comprehensive Strategic Framework. (Report GAO-07-403). Washington, D.C.: Government Accountability Office (GAO) (Available: http://www.gao.gov/new.items/d07403.pdf

Cite this work

Researchers should cite this work as follows:

  • Reza Jafarzadeh, Jason M. Ingham and Suzanne Wilkinson (2015), "NEES: A Database for Seismic Retrofit Construction Cost of Concrete and Steel Framed Schools in Iran," https://datacenterhub.org/resources/252.

    BibTex | EndNote

Tags

Debug Console

Close26 MBRequestSessionTimelineDatabase48Events52
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
LD_LIBRARY_PATH => /usr/local/lib:/usr/lib64/:/opt/rh/rh-python36/root/usr/lib64/:/opt/remi/php56/root/usr/lib64,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /resources/252,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/resources/252,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /resources/252,
SCRIPT_URI => https://datacenterhub.org/resources/252,
HTTPS => on,
SSL_TLS_SNI => datacenterhub.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_IF_MODIFIED_SINCE => Tue, 07 Apr 2020 06:29:10 CEST,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => datacenterhub.org,
HTTP_CONNECTION => Keep-Alive,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache,
SERVER_NAME => datacenterhub.org,
SERVER_ADDR => 10.111.11.100,
SERVER_PORT => 443,
REMOTE_ADDR => 3.235.62.151,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 59570,
REDIRECT_URL => /resources/252,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /resources/252,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1594017491.1053,
REQUEST_TIME => 1594017491,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 1c7c0c15ebd5c0942f9163eaab0bb1e1
tracker.ssid 1c7c0c15ebd5c0942f9163eaab0bb1e1
tracker.rsid 1c7c0c15ebd5c0942f9163eaab0bb1e1
  • site 0.044 seconds (+0.044); 12.25 MB (+12.250) - afterInitialise
  • site 0.062 seconds (+0.018); 13.50 MB (+1.250) - afterRoute
  • site 0.191 seconds (+0.129); 24.75 MB (+11.250) - afterDispatch
  • site 0.196 seconds (+0.005); 25.00 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.197 seconds (+0.002); 25.00 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.197 seconds (+0.000); 25.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.215 seconds (+0.017); 25.50 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.220 seconds (+0.005); 25.50 MB (0.000) - onAfterRender
  • site 0.223 seconds (+0.003); 25.75 MB (+0.250) - sessionStore
26 MB

48 Queries Logged: 0.013958215713501 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '239be63b989472abb4cafdbd4bd85f89'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '239be63b989472abb4cafdbd4bd85f89'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '1c7c0c15ebd5c0942f9163eaab0bb1e1'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '1c7c0c15ebd5c0942f9163eaab0bb1e1'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('1c7c0c15ebd5c0942f9163eaab0bb1e1','0','1594017491','3.235.62.151')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  13. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tools'
  16. SELECT *
      FROM `jos_resources`
      WHERE `jos_resources`.`id` = '252'
  17. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '72'
  18. SELECT jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags.id = jos_tags_object.tagid
      WHERE `jos_tags_object`.`label` != 'badge'
      AND `jos_tags_object`.`tbl` = 'resources'
      AND `jos_tags_object`.`objectid` = '252'
      AND `jos_tags`.`admin` = '0'
  19. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '252'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  20. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  21. SELECT *
      FROM `jos_resource_ratings`
      WHERE `jos_resource_ratings`.`resource_id` = '252'
      AND `jos_resource_ratings`.`state` IN ('1','3')
      ORDER BY `created` DESC
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  23. SELECT *
      FROM `jos_citations`
      INNER JOIN jos_citations_assoc
      ON jos_citations_assoc.cid = jos_citations.id
      WHERE `jos_citations`.`published` = '1'
      AND `jos_citations_assoc`.`tbl` = 'resource'
      AND `jos_citations_assoc`.`oid` = '252'
      ORDER BY `jos_citations`.`affiliated` ASC,`jos_citations`.`year` DESC
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  25. SELECT jos_answers_questions.*
      FROM `jos_answers_questions`
      INNER JOIN jos_tags_object
      ON jos_tags_object.objectid = jos_answers_questions.id
      INNER JOIN jos_tags
      ON jos_tags.id = jos_tags_object.tagid
      WHERE `jos_tags_object`.`tbl` = 'answers'
      AND `jos_tags`.`tag` IN ('resource252')
      AND `jos_answers_questions`.`state` < '2'
  26. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '-58'
  27. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '0'
  28. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = NULL
  29. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '-58'
  30. SHOW FULL COLUMNS
      FROM `jos_resource_assoc`
  31. SELECT jos_resources.*,parent_id,jos_resource_assoc.ordering AS associative_ordering,jos_resource_assoc.grouping AS associative_grouping
      FROM `jos_resources`
      INNER JOIN jos_resource_assoc
      ON jos_resources.id = child_id
      WHERE `jos_resource_assoc`.`parent_id` = '252'
      AND `jos_resources`.`standalone` = '0'
      AND `jos_resources`.`published` = '1'
      ORDER BY `ordering` ASC
  32. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '0'
  33. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '11'
  34. SELECT *
      FROM `jos_resource_licenses`
      WHERE `jos_resource_licenses`.`name` = NULL
      LIMIT 1
  35. SELECT k.*
      FROM ((SELECT DISTINCT w.id, w.title, w.pagename AS alias, v.pagetext AS introtext, NULL AS type, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'Topic' AS section
      FROM `jos_wiki_pages` AS w
      INNER JOIN `jos_wiki_versions` AS v
      ON w.version_id=v.id
      INNER JOIN `jos_wiki_links` AS wl
      ON wl.page_id=w.id
      WHERE v.approved=1
      AND wl.scope='resource'
      AND wl.scope_id='252'
      AND w.access!=1
      GROUP BY w.id, v.pagetext
      ORDER BY ranking DESC, title
      LIMIT 10) UNION (SELECT DISTINCT r.id, r.title, r.alias, r.introtext, r.type, r.published, r.publish_up, NULL AS scope, r.rating, r.times_rated, r.ranking, rt.type AS section
      FROM `jos_resource_types` AS rt, `jos_resources` AS r JOIN `jos_resource_assoc` AS a
      ON r.id=a.parent_id
      LEFT JOIN `jos_resource_types` AS t
      ON r.logical_type=t.id
      WHERE r.published=1
      AND a.child_id='252'
      AND r.type=rt.id
      AND r.type!=8
      AND r.access=0
      ORDER BY r.ranking
      LIMIT 10)) AS k
      ORDER BY ranking DESC
      LIMIT 10
  36. SELECT *
      FROM `jos_resource_sponsors`
      WHERE `jos_resource_sponsors`.`state` = '1'
  37. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'resources'
      AND `jos_tags_object`.`objectid` = '252'
      GROUP BY jos_tags_object.label,jos_tags.id
  38. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '72'
  39. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2020-07-06 06:38:11' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-07-06 06:38:11' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '88' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  40. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  41. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  44. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  47. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  48. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1594017491;s:18:\"session.timer.last\";i:1594017491;s:17:\"session.timer.now\";i:1594017491;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":2:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}s:7:\"Reviews\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Review\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:4:\"desc\";}}}}}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"1c7c0c15ebd5c0942f9163eaab0bb1e1\";s:12:\"tracker.ssid\";s:32:\"1c7c0c15ebd5c0942f9163eaab0bb1e1\";s:12:\"tracker.rsid\";s:32:\"1c7c0c15ebd5c0942f9163eaab0bb1e1\";}',`time` = '1594017491',`ip` = '3.235.62.151'
      WHERE `session_id` = '1c7c0c15ebd5c0942f9163eaab0bb1e1'

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 16 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 4 × SELECT *
      FROM `jos_resource_types`
  3. 3 × SELECT *
      FROM `jos_users`
  4. 2 × SELECT data
      FROM `jos_session`
  5. 1 × SELECT *
      FROM `jos_user_profiles`
  6. 1 × SELECT jos_answers_questions.*
      FROM `jos_answers_questions`
      INNER JOIN jos_tags_object
      ON jos_tags_object.objectid = jos_answers_questions.id
      INNER JOIN jos_tags
      ON jos_tags.id = jos_tags_object.tagid
  7. 1 × SELECT jos_resources.*,parent_id,jos_resource_assoc.ordering AS associative_ordering,jos_resource_assoc.grouping AS associative_grouping
      FROM `jos_resources`
      INNER JOIN jos_resource_assoc
      ON jos_resources.id = child_id
  8. 1 × SELECT *
      FROM `jos_resource_licenses`
  9. 1 × SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  10. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  11. 1 × SELECT *
      FROM `jos_resource_sponsors`
  12. 1 × SELECT k.*
      FROM ((SELECT DISTINCT w.id, w.title, w.pagename AS alias, v.pagetext AS introtext, NULL AS type, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'Topic' AS section
      FROM `jos_wiki_pages` AS w
      INNER JOIN `jos_wiki_versions` AS v
      ON w.version_id=v.id
      INNER JOIN `jos_wiki_links` AS wl
      ON wl.page_id=w.id
  13. 1 × SELECT *
      FROM `jos_citations`
      INNER JOIN jos_citations_assoc
      ON jos_citations_assoc.cid = jos_citations.id
  14. 1 × SELECT *
      FROM `jos_author_assoc`
  15. 1 × SELECT *
      FROM `jos_viewlevels
  16. 1 × SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  17. 1 × SELECT session_id
      FROM `jos_session`
  18. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  19. 1 × SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
  20. 1 × SELECT jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags.id = jos_tags_object.tagid
  21. 1 × SELECT *
      FROM `jos_resources`
  22. 1 × SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
  23. 1 × SELECT *
      FROM `jos_resource_ratings`
OTHER Tables:
  1. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1594017491;s:18:\"session.timer.last\";i:1594017491;s:17:\"session.timer.now\";i:1594017491;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":2:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}s:7:\"Reviews\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Review\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:4:\"desc\";}}}}}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"1c7c0c15ebd5c0942f9163eaab0bb1e1\";s:12:\"tracker.ssid\";s:32:\"1c7c0c15ebd5c0942f9163eaab0bb1e1\";s:12:\"tracker.rsid\";s:32:\"1c7c0c15ebd5c0942f9163eaab0bb1e1\";}',`time` = '1594017491',`ip` = '3.235.62.151'
  2. 1 × SHOW FULL COLUMNS
      FROM `jos_resource_assoc
  3. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('1c7c0c15ebd5c0942f9163eaab0bb1e1','0','1594017491','3.235.62.151'
  4. 1 × DELETE
      FROM `jos_session`
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:20
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:21
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onResourcesAreas Method plgResourcesAbout::onResourcesAreas /core/plugins/resources/about/about.php:32
  • onResourcesAreas Method plgResourcesReviews::onResourcesAreas /core/plugins/resources/reviews/reviews.php:43
  • onResourcesAreas Method plgResourcesUsage::onResourcesAreas /core/plugins/resources/usage/usage.php:29
  • onResourcesAreas Method plgResourcesVersions::onResourcesAreas /core/plugins/resources/versions/versions.php:29
  • onResourcesAreas Method plgResourcesShare::onResourcesAreas /core/plugins/resources/share/share.php:29
  • onResourcesAreas Method plgResourcesCitations::onResourcesAreas /core/plugins/resources/citations/citations.php:29
  • onResourcesAreas Method plgResourcesQuestions::onResourcesAreas /core/plugins/resources/questions/questions.php:29
  • onResourcesAreas Method plgResourcesSupportingDocs::onResourcesAreas /core/plugins/resources/supportingdocs/supportingdocs.php:30
  • onResourcesAreas Method plgResourcesWishlist::onResourcesAreas /core/plugins/resources/wishlist/wishlist.php:29
  • onResourcesAreas Method plgResourcesFindThisText::onResourcesAreas /core/plugins/resources/findthistext/findthistext.php:29
  • onResourcesAreas Method plgResourcesWindowstools::onResourcesAreas /core/plugins/resources/windowstools/windowstools.php:214
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • onResources Method plgResourcesAbout::onResources /core/plugins/resources/about/about.php:54
  • onResources Method plgResourcesReviews::onResources /core/plugins/resources/reviews/reviews.php:91
  • onResources Method plgResourcesUsage::onResources /core/plugins/resources/usage/usage.php:51
  • onResources Method plgResourcesVersions::onResources /core/plugins/resources/versions/versions.php:50
  • onResources Method plgResourcesShare::onResources /core/plugins/resources/share/share.php:50
  • onResources Method plgResourcesCitations::onResources /core/plugins/resources/citations/citations.php:51
  • onResources Method plgResourcesQuestions::onResources /core/plugins/resources/questions/questions.php:60
  • onResources Method plgResourcesSupportingDocs::onResources /core/plugins/resources/supportingdocs/supportingdocs.php:52
  • onResources Method plgResourcesWishlist::onResources /core/plugins/resources/wishlist/wishlist.php:50
  • onResources Method plgResourcesFindThisText::onResources /core/plugins/resources/findthistext/findthistext.php:51
  • onResources Method plgResourcesWindowstools::onResources /core/plugins/resources/windowstools/windowstools.php:235
  • onResources Method plgResourcesGooglescholar::onResources /core/plugins/resources/googlescholar/googlescholar.php:25
  • onResources Method plgResourcesOpengraph::onResources /core/plugins/resources/opengraph/opengraph.php:25
  • onResources Method plgResourcesDublincore::onResources /core/plugins/resources/dublincore/dublincore.php:25
  • onResources Method plgResourcesCoins::onResources /core/plugins/resources/coins/coins.php:25
  • onResourcesSub Method plgResourcesGroups::onResourcesSub /core/plugins/resources/groups/groups.php:45
  • onResourcesSub Method plgResourcesRelated::onResourcesSub /core/plugins/resources/related/related.php:45
  • onResourcesSub Method plgResourcesSponsors::onResourcesSub /core/plugins/resources/sponsors/sponsors.php:45
  • onResourcesSub Method plgResourcesWatch::onResourcesSub /core/plugins/resources/watch/watch.php:46
  • onResourcesSub Method plgResourcesCollections::onResourcesSub /core/plugins/resources/collections/collections.php:31
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:60
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:25
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:21