Database on Performance of Low-Rise Reinforced Concrete Buildings in the 2015 Nepal Earthquake

By Prateek Shah1, Santiago Pujol1, Aishwarya Puranam1, Lucas Laughery2

1. Purdue University 2. Nagoya Institute of Technology

Category

Databases

Published on

Abstract


This database was last updated July 16, 2015.

Note: Data from more buildings will be added to this database in the near future.
Note: Data were also collected for 28 high rise reinforced concrete structures in Kathmandu, Nepal. A database with high-rise RC building data will be published at Performance of High-Rise Reinforced Concrete Buildings in the 2015 Nepal Earthquake


On April 25, 2015, a magnitude 7.8 earthquake occurred in Nepal. It caused more than 8500 casualties and left over 22,000 people injured. Another major earthquake of magnitude 7.3 occurred in Nepal on May 12, 2015. Thousands of buildings were destroyed and many more rendered unsafe.

image image image


Detailed surveys and inspections of reinforced concrete structures affected by the earthquakes in Nepal were conducted in a reconnaissance effort funded by The American Concrete Institute. The effort was concentrated on identification of buildings with structures similar to new and older reinforced concrete buildings in seismic areas in the U.S. The reconnaissance group consisted of 4 teams (A, B, C and D) with 3 or 4 people in each team. Data were collected between June 18, 2015 and July 01, 2015.

image




image This database contains information on 146 low-rise reinforced concrete buildings with and without masonry infill walls inspected in Kathmandu, Nepal. Building plans, dimensions, photographs and GPS coordinates were collected for buildings that were inspected.

Damage level is depicted on the map as follows: Severe Damage in Red, Moderate Damage in Yellow and Light Damage in Green. It was observed that damage concentrated towards the edge of the valley, along the foothills. Little to no damage to reinforced concrete structures was found in the middle of the valley.

The Google Earth (.kml) file for the map shown can be downloaded under the supporting documents tab.

image The following people are gratefully acknowledged for their help with data collection: Mukund Prasad Sah, Kamal Baral, Bishnu Paudel, Robin Guragain, Prakash Nepal, Ujjwal Karki, Amit Kumar Sah, Ajay Kumar Karna, Prakash Mishra, Sewak Pandit, Hari Krishna Dhamala, Tirtha Raj Timilsina, Bharat Budhathoki, Bipesh Shrestha, Shailesh Bhattarai, Radhey Shyam Chaudhary and Niranjan Shrestha.

Sincere thanks to the following for facilitating the data collection process:
  1. Ministry of Urban Planning, Government of Nepal
  2. Department of Urban Development and Building Construction, Government of Nepal
  3. Shah Consult International (P.) Ltd.
  4. Dr. Sanjiv Shah
  5. Poonam Shah

This database is presented as a spreadsheet with each row containing the following information for a building:
  1. Title: Title of the project, group of experiments, simulations or surveys
  2. Source: Names of the people who generated the data
  3. Keywords: Words describing the dataset
  4. Report(s): Related documentation
  5. Experiment or Case ID: ID assigned by the source to the sample, specimen, case, survey, site, experiment or simulation
  6. Latitude: Latitude of the location where data was collected, if applicable
  7. Longitude: Longitude of the location where data was collected, if applicable
  8. Parameters: Variables and parameters chosen by the researcher, compiler, professional or scientific organization to describe the data
  9. Drawings/Diagrams: Drawing and diagrams helpful to interpret the data
  10. Data: Data files generated through project. Tabular text format is preferred
  11. Photos, Videos, etc.: Media files including photos, videos, audio generated through project
  12. Compiled by: Names of the people who compiled the data
  13. Date: Date when the dataset was compiled


In addition, the following information is presented in the parameter column:
  1. Event
  2. Building ID
  3. Priority Index (Hassan Index, %):
      PI = WI + CI (where, WI = Wall Index, CI = Column Index)
  4. No. of Floors
  5. Ground Floor Area (m2)
  6. Total Floor Area (m2)
  7. Column Area (m2)
  8. Concrete Wall Area (NS) (m2)
  9. Concrete Wall Area (EW) (m2)
  10. Masonry Wall Area (NS) (m2)
  11. Masonry Wall Area (EW) (m2)
  12. Structural Damage - Four classes of damage
    a) Light: Hairline (crack width not exceeding approximate 0.13 mm) inclined and flexural cracks were observed in structural elements.
    b) Moderate: Wider cracks or spalling of concrete was observed.
    c) Severe: At least one element had a structural failure.
    d) Collapse: At least one floor slab or part of it lost its elevation.
  13. Masonry Wall Damage - Damage to infill walls classified as follows:
    a) Light: Hairline cracks occurred.
    b) Moderate: Wider cracks appeared or large pieces of plaster flaked off.
    c) Severe: The element collapsed or cracks wide enough to see through the wall appeared.
  14. Captive Columns: Are there captive columns?
  15. Column Index (%)
       CI = 0.5 Acol/Af *100%
      where,
      Acol: the sum of cross-sectional areas of all columns at ground floor.
      Af: total floor area above ground level
  16. Wall Index (NS) (%)
      WI = (Acw + 0.1Amw)/Af *100%
      where,
      Acw: the sum of cross-sectional areas of reinforced concrete walls in north-south direction at ground floor
      Amw: the sum of cross-sectional areas of infill masonry walls in north-south direction at ground floor
  17. Wall Index (EW) (%)
      WI = (Acw + 0.1Amw)/Af *100%
      where,
      Acw: the sum of cross-sectional areas of reinforced concrete walls in east-west direction at ground floor
      Amw: the sum of cross-sectional areas of infill masonry walls in east-west direction at ground floor
  18. Min WI (%)
      Minimum Wall Index
  19. Priority Index (Hassan Index, %)
      PI = WI + CI
      where, WI = Wall Index, CI = Column Index

Cite this work

Researchers should cite this work as follows:

  • Prateek Shah; Santiago Pujol; Aishwarya Puranam; Lucas Laughery (2015), "Database on Performance of Low-Rise Reinforced Concrete Buildings in the 2015 Nepal Earthquake," https://datacenterhub.org/resources/238.

    BibTex | EndNote

Tags

Debug Console

Close26 MBRequestSessionTimelineDatabase53Events52
$_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/238/about,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/resources/238/about,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /resources/238/about,
SCRIPT_URI => https://datacenterhub.org/resources/238/about,
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_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.107.209,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 53442,
REDIRECT_URL => /resources/238/about,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /resources/238/about,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1597202515.9146,
REQUEST_TIME => 1597202515,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid a93213f52754ec1a1e88d9cd35e2d3e2
tracker.ssid a93213f52754ec1a1e88d9cd35e2d3e2
tracker.rsid a93213f52754ec1a1e88d9cd35e2d3e2
  • site 0.048 seconds (+0.048); 12.25 MB (+12.250) - afterInitialise
  • site 0.071 seconds (+0.023); 13.50 MB (+1.250) - afterRoute
  • site 0.217 seconds (+0.146); 25.00 MB (+11.500) - afterDispatch
  • site 0.221 seconds (+0.005); 25.25 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.223 seconds (+0.002); 25.25 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.223 seconds (+0.000); 25.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.240 seconds (+0.016); 25.75 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.245 seconds (+0.005); 26.00 MB (+0.250) - onAfterRender
  • site 0.248 seconds (+0.003); 26.00 MB (0.000) - sessionStore
26 MB

53 Queries Logged: 0.016627311706543 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '3ffae9abcc5dca74688ce056ec581671'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '3ffae9abcc5dca74688ce056ec581671'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'a93213f52754ec1a1e88d9cd35e2d3e2'
  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` = 'a93213f52754ec1a1e88d9cd35e2d3e2'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('a93213f52754ec1a1e88d9cd35e2d3e2','0','1597202515','3.235.107.209')
  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` = '238'
  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` = '238'
      AND `jos_tags`.`admin` = '0'
  19. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '238'
      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` = '238'
      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` = '238'
      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 ('resource238')
      AND `jos_answers_questions`.`state` < '2'
  26. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '-48'
  27. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1017'
  28. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '-51'
  29. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1034'
  30. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1034'
  31. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = '1034'
  32. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1034'
  33. SHOW FULL COLUMNS
      FROM `jos_resource_assoc`
  34. 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` = '238'
      AND `jos_resources`.`standalone` = '0'
      AND `jos_resources`.`published` = '1'
      ORDER BY `ordering` ASC
  35. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '0'
  36. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '12'
  37. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '13'
  38. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '38'
  39. SELECT *
      FROM `jos_resource_licenses`
      WHERE `jos_resource_licenses`.`name` = 'cc30-by-sa'
      LIMIT 1
  40. 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='238'
      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='238'
      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
  41. SELECT *
      FROM `jos_resource_sponsors`
      WHERE `jos_resource_sponsors`.`state` = '1'
  42. 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` = '238'
      GROUP BY jos_tags_object.label,jos_tags.id
  43. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '72'
  44. 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-08-12 03:21:56' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-08-12 03:21:56' )
      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
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  47. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  48. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  49. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  50. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  51. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  52. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  53. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1597202515;s:18:\"session.timer.last\";i:1597202515;s:17:\"session.timer.now\";i:1597202515;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:\"a93213f52754ec1a1e88d9cd35e2d3e2\";s:12:\"tracker.ssid\";s:32:\"a93213f52754ec1a1e88d9cd35e2d3e2\";s:12:\"tracker.rsid\";s:32:\"a93213f52754ec1a1e88d9cd35e2d3e2\";}',`time` = '1597202516',`ip` = '3.235.107.209'
      WHERE `session_id` = 'a93213f52754ec1a1e88d9cd35e2d3e2'

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. 6 × SELECT *
      FROM `jos_resource_types`
  3. 6 × 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:1597202515;s:18:\"session.timer.last\";i:1597202515;s:17:\"session.timer.now\";i:1597202515;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:\"a93213f52754ec1a1e88d9cd35e2d3e2\";s:12:\"tracker.ssid\";s:32:\"a93213f52754ec1a1e88d9cd35e2d3e2\";s:12:\"tracker.rsid\";s:32:\"a93213f52754ec1a1e88d9cd35e2d3e2\";}',`time` = '1597202516',`ip` = '3.235.107.209'
  2. 1 × SHOW FULL COLUMNS
      FROM `jos_resource_assoc
  3. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('a93213f52754ec1a1e88d9cd35e2d3e2','0','1597202515','3.235.107.209'
  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