Tags: Structural Walls

All Categories (1-9 of 9)

  1. Hybrid Masonry Seismic Structural Systems (NEES-2010-0917)

    25 Sep 2017 | Contributor(s):: Daniel Abrams, Ian Robertson, David Biggs, Ilinca Stanciulescu

    Title: Hybrid Masonry Seismic Structural Systems (NEES-2010-0917)Year Of Curation: 2013Description: The research will enable a new technology for earthquake resistant design of buildings, known as hybrid masonry. This innovative concept for improved seismic performance of low to mid-rise...

  2. Seismic Performance of 5 RC Buildings w Structural Walls at Tohoku Univ. during the Tohoku EQ of 2011 (NEES-2012-1122

    31 Aug 2017 | Contributor(s):: Santiago Pujol, Mete Sozen

    Title: Seismic Performance of Five Reinforced Concrete Buildings with Structural Walls at Tohoku University during the Tohoku, Japan, Earthquake of 2011 (NEES-2012-1122)Year Of Curation: 2014Description: The objective of this Rapid Research Response (RAPID) award was to investigate the...

  3. RAPID: Mapping of Earthquake Damage in Precast Buildings in Christchurch, New Zealand (NEES-2011-1046)

    29 Aug 2017 | Contributor(s):: Jose Restrepo, Robert Fleischman

    Title: RAPID: Mapping of Earthquake Damage in Precast Buildings in Christchurch, New Zealand (NEES-2011-1046)Year Of Curation: 2013Description: Following powerful earthquakes between September 2010 and June 2011 near Christchurch, New Zealand, an expedition to document damage in precast concrete...

  4. Inelastic Web Crushing Performance Limits of High-Strength-Concrete Structural Walls (NEES-2005-0078)

    07 Aug 2017 | Contributor(s):: Rigoberto Burgueno, Eric Hines

    Title: Inelastic Web Crushing Performance Limits of High-Strength-Concrete Structural Walls (NEES-2011-0078)Year Of Curation: 2011Description: Recent research findings indicate that the design of high-capacity shear walls with stable ductile behavior is possible if rational failure modes that can...

  5. Lateral Load Behavior and Modeling of Shear-Dominant RC Walls for Performance-Based Design (NEES-2012-1131)

    07 Aug 2017 | Contributor(s):: John Wallace

    Title: Lateral Load Behavior and Modeling of Shear-Dominant RC Walls for Performance-Based Design (NEES-2012-1131)Year Of Curation: 2014Description: The goals of the research are to develop and validate new modeling approaches appropriate for combined gravity and earthquake loads for buildings...

  6. Experimental Study of Frame-Wall Interaction in RC Structures Subjected to Strong Earthquake Motions (NEES-2011-1019)

    03 Aug 2017 | Contributor(s):: Daniel Abrams, Mete Sozen

    Title: Experimental Study of Frame-Wall Interaction in Reinforced Concrete Structures Subjected to Strong Earthquake Motions (NEES-2011-1019)Year Of Curation: 2012Description: The objective of the experimental study was to develop a better understanding of the response of frame-wall structures to...

  7. NEES: Shear Wall Database

    02 Aug 2017 |

    AuthorsThis database was assembled by researchers at Tongji University. The database was published at NEEShub on December 05 2010 and has been reproduced here to preserve the data and ensure continued access. Databasedoi: 10.4231/D38C9R416This structural performance database contains material and...

  8. ACI 445B Shear Wall Database

    26 Aug 2015 | | Contributor(s):: Cheng Song, Ying Wang, Aishwarya Puranam, Santiago Pujol, ACI Subcommittee 445B, Merve Usta

    This structural wall performance database is being compiled and vetted several times per year by ACI Subcommittee 445B.It contains material and geometric properties, experimental results, and references for tests of reinforced concrete structural walls. Data from 521...

  9. Experimental and Analytical Investigation of Non-rectangular Walls under Multidirectional Loads

    24 Mar 2015 | | Contributor(s):: Catherine Ellen French, Ricardo Rafael Lopez, Sri Sritharan, Beth Brueggen, Benton Johnson

    Experimental and Analytical Investigation of Non-rectangular Walls under Multidirectional Loads

Debug Console

Close23 MBRequestSessionTimelineDatabase88Events30
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( MANPATH => /opt/remi/php56/root/usr/share/man:/opt/puppetlabs/puppet/share/man, HOSTNA... Array(
MANPATH => /opt/remi/php56/root/usr/share/man:/opt/puppetlabs/puppet/share/man,
HOSTNAME => hz01-p-web01.hz01.internal,
SHELL => /bin/bash,
TERM => xterm-256color,
HISTSIZE => 1000,
SSH_TTY => /dev/pts/1,
NO_PROXY => .s2.internal,
http_proxy => http://10.8.63.5:3128,
USER => apache,
LD_LIBRARY_PATH => /opt/remi/php56/root/usr/lib64,
LS_COLORS => rs=0:di=38;5;27:ln=38;5;51:mh=44;38;5;15:pi=40;38;5;11:so=38;5;13:do=38;5;5:bd=48;5;232;38;5;11:cd=48;5;232;38;5;3:or=48;5;232;38;5;9:mi=05;48;5;232;38;5;15:su=48;5;196;38;5;15:sg=48;5;11;38;5;16:ca=48;5;196;38;5;226:tw=48;5;10;38;5;16:ow=48;5;10;38;5;21:st=48;5;21;38;5;15:ex=38;5;34:*.tar=38;5;9:*.tgz=38;5;9:*.arj=38;5;9:*.taz=38;5;9:*.lzh=38;5;9:*.lzma=38;5;9:*.tlz=38;5;9:*.txz=38;5;9:*.zip=38;5;9:*.z=38;5;9:*.Z=38;5;9:*.dz=38;5;9:*.gz=38;5;9:*.lz=38;5;9:*.xz=38;5;9:*.bz2=38;5;9:*.tbz=38;5;9:*.tbz2=38;5;9:*.bz=38;5;9:*.tz=38;5;9:*.deb=38;5;9:*.rpm=38;5;9:*.jar=38;5;9:*.rar=38;5;9:*.ace=38;5;9:*.zoo=38;5;9:*.cpio=38;5;9:*.7z=38;5;9:*.rz=38;5;9:*.jpg=38;5;13:*.jpeg=38;5;13:*.gif=38;5;13:*.bmp=38;5;13:*.pbm=38;5;13:*.pgm=38;5;13:*.ppm=38;5;13:*.tga=38;5;13:*.xbm=38;5;13:*.xpm=38;5;13:*.tif=38;5;13:*.tiff=38;5;13:*.png=38;5;13:*.svg=38;5;13:*.svgz=38;5;13:*.mng=38;5;13:*.pcx=38;5;13:*.mov=38;5;13:*.mpg=38;5;13:*.mpeg=38;5;13:*.m2v=38;5;13:*.mkv=38;5;13:*.ogm=38;5;13:*.mp4=38;5;13:*.m4v=38;5;13:*.mp4v=38;5;13:*.vob=38;5;13:*.qt=38;5;13:*.nuv=38;5;13:*.wmv=38;5;13:*.asf=38;5;13:*.rm=38;5;13:*.rmvb=38;5;13:*.flc=38;5;13:*.avi=38;5;13:*.fli=38;5;13:*.flv=38;5;13:*.gl=38;5;13:*.dl=38;5;13:*.xcf=38;5;13:*.xwd=38;5;13:*.yuv=38;5;13:*.cgm=38;5;13:*.emf=38;5;13:*.axv=38;5;13:*.anx=38;5;13:*.ogv=38;5;13:*.ogx=38;5;13:*.aac=38;5;45:*.au=38;5;45:*.flac=38;5;45:*.mid=38;5;45:*.midi=38;5;45:*.mka=38;5;45:*.mp3=38;5;45:*.mpc=38;5;45:*.ogg=38;5;45:*.ra=38;5;45:*.wav=38;5;45:*.axa=38;5;45:*.oga=38;5;45:*.spx=38;5;45:*.xspf=38;5;45:,
SUDO_USER => su-ehuebner,
SUDO_UID => 602,
USERNAME => root,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
MAIL => /var/spool/mail/su-ehuebner,
PWD => /var/home,
LANG => en_US.UTF-8,
MODULEPATH => /usr/share/Modules/modulefiles:/etc/modulefiles,
LOADEDMODULES => ,
https_proxy => http://10.8.63.5:3128,
ENVIRON_CONFIG_DIRS => /etc/environ.d ,
SHLVL => 3,
SUDO_COMMAND => /bin/su,
HOME => /var/www,
LOGNAME => root,
CVS_RSH => ssh,
MODULESHOME => /usr/share/Modules,
LESSOPEN => ||/usr/bin/lesspipe.sh %s,
SUDO_GID => 800,
G_BROKEN_FILENAMES => 1,
BASH_FUNC_module() => () { eval `/usr/bin/modulecmd bash $*`
}
,
_ => /opt/remi/php56/root/usr/sbin/php-fpm,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /tags/structuralwalls,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/tags/structuralwalls,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /tags/structuralwalls,
SCRIPT_URI => https://datacenterhub.org/tags/structuralwalls,
HTTPS => on,
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 => 10.111.11.10,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 12123,
REDIRECT_URL => /tags/structuralwalls,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /tags/structuralwalls,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1590709935.7976,
REQUEST_TIME => 1590709935,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 144f24b0276d487993862a7001f0780b
tracker.ssid 144f24b0276d487993862a7001f0780b
tracker.rsid 144f24b0276d487993862a7001f0780b
  • site 0.050 seconds (+0.050); 12.25 MB (+12.250) - afterInitialise
  • site 0.072 seconds (+0.022); 13.50 MB (+1.250) - afterRoute
  • site 0.257 seconds (+0.185); 22.25 MB (+8.750) - afterDispatch
  • site 0.266 seconds (+0.010); 22.50 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.268 seconds (+0.002); 22.50 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.269 seconds (+0.000); 22.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.285 seconds (+0.016); 23.00 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.290 seconds (+0.005); 23.00 MB (0.000) - onAfterRender
  • site 0.292 seconds (+0.002); 23.00 MB (0.000) - sessionStore
23 MB

88 Queries Logged: 0.039962768554688 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '1ac7f04bf412a0bc6a40f928877b2fff'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '1ac7f04bf412a0bc6a40f928877b2fff'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '144f24b0276d487993862a7001f0780b'
  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` = '144f24b0276d487993862a7001f0780b'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('144f24b0276d487993862a7001f0780b','0','1590709935','10.111.11.10')
  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_tags'
  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 *
      FROM `jos_tags`
      WHERE `jos_tags`.`tag` = 'structuralwalls'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  17. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  18. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  19. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=68
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  20. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=76
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  21. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=73
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  22. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=6
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  23. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=72
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  24. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=9
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  25. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=69
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  26. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=66
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  27. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=67
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  28. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=10
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  29. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=3
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  30. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=1
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  31. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=31
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  32. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=39
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  33. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=7
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  34. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=77
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  35. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      AND r.type=2
      GROUP BY r.id
      HAVING uniques=1 ) AS f
  36. SELECT COUNT(f.id)
      FROM (SELECT v.page_id AS id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_wiki_pages AS w
      INNER JOIN jos_wiki_versions AS v
      ON v.id=w.version_id
      LEFT JOIN `jos_xgroups` xg
      ON xg.gidNumber = w.scope_id
      AND w.scope='
      group'
      LEFT JOIN `jos_projects` xp
      ON xp.id = w.scope_id
      AND w.scope='project', jos_tags_object AS t
      WHERE w.id=v.page_id
      AND v.approved=1
      AND w.state < 2
      AND (xg.gidNumber IS NULL OR (xg.plugins LIKE '%wiki=anyone%'))
      AND w.id=t.objectid
      AND t.tbl='wiki'
      AND t.tagid IN (38)
      GROUP BY page_id
      HAVING uniques=1 ) AS f
  37. SELECT COUNT(f.id)
      FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_users AS a
      LEFT JOIN jos_user_profiles AS b
      ON a.id=b.user_id
      AND b.profile_key='bio', jos_tags_object AS t
      WHERE a.access IN (1,1,4)
      AND a.block=0
      AND a.activation > 0
      AND a.id=t.objectid
      AND t.tbl='xprofiles'
      AND t.tagid IN (38)
      GROUP BY a.id, b.profile_value
      HAVING uniques=1) AS f
  38. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_events AS e, jos_tags_object AS t
      WHERE e.state=1
      AND t.objectid=e.id
      AND t.tbl='events'
      AND t.tagid IN (38)
      GROUP BY e.id
      HAVING uniques=1) AS f
  39. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  40. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_groups'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  41. SELECT COUNT(f.gidNumber)
      FROM (SELECT a.gidNumber, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
      ON m.gidNumber=a.gidNumber
      AND m.uidNumber=0 JOIN jos_tags_object AS t
      WHERE (a.type=1 OR a.type=3)
      AND a.discoverability=0
      AND a.gidNumber=t.objectid
      AND t.tbl='groups'
      AND t.tagid IN (38)
      GROUP BY a.gidNumber
      HAVING uniques=1) AS f
  42. SELECT COUNT(f.id)
      FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_answers_questions` AS a, `jos_tags_object` AS t
      WHERE a.id=t.objectid
      AND t.tbl='answers'
      AND t.tagid IN (38)
      AND a.state!=2
      GROUP BY a.id
      HAVING uniques=1) AS f
  43. SELECT DISTINCT gidNumber
      FROM `jos_xgroups_members`
      WHERE uidNumber=0
  44. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_forum'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  45. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_forum_posts AS e
      LEFT JOIN jos_forum_categories c
      ON c.id = e.category_id
      LEFT JOIN jos_forum_sections s
      ON s.id = c.section_id
      LEFT JOIN jos_xgroups g
      ON g.gidNumber = e.scope_id
      LEFT JOIN jos_tags_object AS t
      ON t.objectid=e.id
      AND t.tbl='forum'
      AND t.tagid IN (38)
      WHERE e.state=1
      AND e.parent=0
      AND e.scope_id IN (0)
      GROUP BY e.id
      HAVING uniques=1) AS f
  46. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_blog_entries AS e, jos_tags_object AS t, jos_users AS u
      WHERE e.created_by=u.id
      AND t.objectid=e.id
      AND t.tbl='blog'
      AND t.tagid IN (38)
      AND e.state=1
      AND (e.publish_up IS NULL OR e.publish_up <= '2020-05-28 23:52:15')
      AND (e.publish_down IS NULL OR e.publish_down >= '2020-05-28 23:52:15')
      GROUP BY e.id
      HAVING uniques=1) AS f
  47. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_citations` AS e, `jos_tags_object` AS t
      WHERE t.objectid=e.id
      AND t.tbl='citations'
      AND t.tagid IN (38)
      AND e.published=1
      AND e.id!=''
      GROUP BY e.id
      HAVING uniques=1) AS f
  48. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_kb_articles` AS e
      LEFT JOIN `jos_categories` AS cc
      ON cc.id = e.category
      LEFT JOIN `jos_tags_object` AS t
      ON t.objectid=e.id
      AND t.tbl='kb'
      AND t.tagid IN (38)
      WHERE e.state=1
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  49. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  50. SELECT *
      FROM jos_publication_categories as C
      WHERE C.state=1
      ORDER BY C.name ASC
  51. SHOW FULL COLUMNS
      FROM `jos_publications`
  52. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  53. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (38)
      AND r.category=1
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  54. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (38)
      AND r.category=3
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  55. SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (38)
      AND r.category=7
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1 ) AS f
  56. SELECT COUNT(f.id)
      FROM (SELECT p.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_collections_posts AS p
      INNER JOIN jos_collections AS c
      ON c.id=p.collection_id
      INNER JOIN jos_collections_items AS i
      ON p.item_id=i.id
      INNER JOIN jos_tags_object AS t
      WHERE i.state=1
      AND c.state=1
      AND t.objectid=p.item_id
      AND t.tbl='bulletinboard'
      AND t.tagid IN (38)
      AND i.access=0
      AND c.access=0
      GROUP BY p.id
      HAVING uniques=1) AS f
  57. SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_courses` AS e, `jos_tags_object` AS t, `jos_users` AS u
      WHERE e.created_by=u.id
      AND e.state=1
      AND t.objectid=e.id
      AND t.tbl='courses'
      AND t.tagid IN (38)
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) AS f
  58. (SELECT DISTINCT r.id, r.title, r.alias, r.introtext AS itext, r.fulltxt AS ftext, r.published AS state, r.created, r.created_by, r.modified, r.publish_up, r.publish_down, CONCAT('index.php?option=com_resources&id=', r.id) AS href, 'resources' AS section , COUNT(DISTINCT t.tagid) AS uniques , r.params, r.rating AS rcount, r.type AS data1, r.access AS data2, r.ranking data3
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
      WHERE r.standalone=1
      AND r.published=1
      AND r.access<4
      AND t.objectid=r.id
      AND t.tbl='resources'
      AND t.tagid IN (38)
      GROUP BY r.id
      HAVING uniques=1
      ORDER BY publish_up DESC) UNION (SELECT v.page_id AS id, w.title, w.pagename AS alias, v.pagetext AS itext, v.pagehtml AS ftext, w.state, v.created, v.created_by, v.created AS modified, v.created AS publish_up, NULL AS publish_down,
      CASE WHEN w.scope = 'project' THEN concat('index.php?option=com_projects&alias=', xp.alias, '&active=notes&pagename=', w.path, '/', w.pagename) WHEN w.scope = '
      group' THEN CONCAT('index.php?option=com_groups&cn=', xg.cn, '&active=wiki&pagename=', w.path, '/', w.pagename) ELSE CONCAT('index.php?option=com_wiki&pagename=', w.pagename) END AS href, 'wiki' AS section , COUNT(DISTINCT t.tagid) AS uniques , w.params, NULL AS rcount, w.scope AS data1, NULL AS data2, NULL AS data3
      FROM jos_wiki_pages AS w
      INNER JOIN jos_wiki_versions AS v
      ON v.id=w.version_id
      LEFT JOIN `jos_xgroups` xg
      ON xg.gidNumber = w.scope_id
      AND w.scope='
      group'
      LEFT JOIN `jos_projects` xp
      ON xp.id = w.scope_id
      AND w.scope='project', jos_tags_object AS t
      WHERE w.id=v.page_id
      AND v.approved=1
      AND w.state < 2
      AND (xg.gidNumber IS NULL OR (xg.plugins LIKE '%wiki=anyone%'))
      AND w.id=t.objectid
      AND t.tbl='wiki'
      AND t.tagid IN (38)
      GROUP BY page_id
      HAVING uniques=1
      ORDER BY created DESC) UNION (SELECT a.id, a.name AS title, a.username as alias, NULL AS itext, b.profile_value AS ftext, a.activation AS state, a.registerDate AS created, a.id AS created_by, NULL AS modified, a.registerDate AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_members&id=', a.id) AS href, 'members' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.params, NULL AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
      FROM jos_users AS a
      LEFT JOIN jos_user_profiles AS b
      ON a.id=b.user_id
      AND b.profile_key='bio', jos_tags_object AS t
      WHERE a.access IN (1,1,4)
      AND a.block=0
      AND a.activation > 0
      AND a.id=t.objectid
      AND t.tbl='xprofiles'
      AND t.tagid IN (38)
      GROUP BY a.id, b.profile_value
      HAVING uniques=1) UNION (SELECT e.id, e.title, NULL AS alias, NULL AS itext, e.content AS ftext, e.state, e.created, e.created_by, NULL AS modified, e.publish_up, e.publish_down, CONCAT('index.php?option=com_events&task=details&id=', e.id) AS href, 'events' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, NULL AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
      FROM jos_events AS e, jos_tags_object AS t
      WHERE e.state=1
      AND t.objectid=e.id
      AND t.tbl='events'
      AND t.tagid IN (38)
      GROUP BY e.id
      HAVING uniques=1) UNION (SELECT a.gidNumber AS id, a.description AS title, a.cn AS alias, NULL AS itext, a.public_desc AS ftext, a.type AS state, a.created, a.created_by, NULL AS modified, NULL AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_groups&cn=', a.cn) AS href, 'groups' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.params, NULL AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
      FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
      ON m.gidNumber=a.gidNumber
      AND m.uidNumber=0 JOIN jos_tags_object AS t
      WHERE (a.type=1 OR a.type=3)
      AND a.discoverability=0
      AND a.gidNumber=t.objectid
      AND t.tbl='groups'
      AND t.tagid IN (38)
      GROUP BY a.gidNumber
      HAVING uniques=1) UNION (SELECT a.id, a.subject AS title, NULL AS alias, NULL AS itext, a.question AS ftext, a.state, a.created, a.created_by, NULL AS modified, a.created AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_answers&task=question&id=', a.id) AS href, 'answers' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.anonymous AS params, (SELECT COUNT(*)
      FROM `jos_answers_responses` AS r
      WHERE r.question_id=a.id) AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
      FROM `jos_answers_questions` AS a, `jos_tags_object` AS t
      WHERE a.id=t.objectid
      AND t.tbl='answers'
      AND t.tagid IN (38)
      AND a.state!=2
      GROUP BY a.id
      HAVING uniques=1) UNION (SELECT e.id, e.title, e.id AS alias, e.comment AS itext, e.comment AS ftext, e.state, e.created, e.created_by, e.modified, e.created AS publish_up, NULL AS publish_down, (
      CASE WHEN e.scope_id > 0
      AND e.scope='
      group' THEN concat('/groups/', g.cn, concat('/forum/', coalesce(concat(s.alias, '/', coalesce(concat(c.alias, '/'), ''))),
      CASE WHEN e.parent > 0 THEN e.parent ELSE e.id END)) ELSE concat('/forum/', coalesce(concat(s.alias, '/', coalesce(concat(c.alias, '/'), ''))),
      CASE WHEN e.parent > 0 THEN e.parent ELSE e.id END) END) AS href, 'forum' AS section, COUNT(DISTINCT t.tagid) AS uniques, CONCAT(e.thread, ':', e.parent) AS params, e.scope AS rcount, c.alias AS data1, s.alias AS data2, e.scope_id AS data3
      FROM jos_forum_posts AS e
      LEFT JOIN jos_forum_categories c
      ON c.id = e.category_id
      LEFT JOIN jos_forum_sections s
      ON s.id = c.section_id
      LEFT JOIN jos_xgroups g
      ON g.gidNumber = e.scope_id
      LEFT JOIN jos_tags_object AS t
      ON t.objectid=e.id
      AND t.tbl='forum'
      AND t.tagid IN (38)
      WHERE e.state=1
      AND e.parent=0
      AND e.scope_id IN (0)
      GROUP BY e.id
      HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, NULL AS itext, e.content AS ftext, e.state, e.created, e.created_by, NULL AS modified, e.publish_up, e.publish_down, CONCAT('index.php?option=com_blog&task=view&id=', e.id) AS href, 'blogs' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, e.scope AS rcount, u.name AS data1, e.scope_id AS data2, NULL AS data3
      FROM jos_blog_entries AS e, jos_tags_object AS t, jos_users AS u
      WHERE e.created_by=u.id
      AND t.objectid=e.id
      AND t.tbl='blog'
      AND t.tagid IN (38)
      AND e.state=1
      AND (e.publish_up IS NULL OR e.publish_up <= '2020-05-28 23:52:15')
      AND (e.publish_down IS NULL OR e.publish_down >= '2020-05-28 23:52:15')
      GROUP BY e.id
      HAVING uniques=1) UNION (SELECT e.id, e.title, e.author, e.booktitle, e.doi, e.published, e.created, e.year, e.month, e.isbn, e.journal, e.url as href, 'citations' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.volume, e.number, e.type, e.pages, e.publisher
      FROM `jos_citations` AS e, `jos_tags_object` AS t
      WHERE t.objectid=e.id
      AND t.tbl='citations'
      AND t.tagid IN (38)
      AND e.published=1
      AND e.id!=''
      GROUP BY e.id
      HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, e.fulltxt AS itext, e.fulltxt AS ftext, e.state, e.created, e.created_by, e.modified, e.created AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_kb&category=&alias=', e.alias) AS href, 'kb' AS section, COUNT(DISTINCT t.tagid) AS uniques, NULL AS params, e.helpful AS rcount, cc.alias AS data1, NULL AS data2, NULL AS data3
      FROM `jos_kb_articles` AS e
      LEFT JOIN `jos_categories` AS cc
      ON cc.id = e.category
      LEFT JOIN `jos_tags_object` AS t
      ON t.objectid=e.id
      AND t.tbl='kb'
      AND t.tagid IN (38)
      WHERE e.state=1
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1) UNION (SELECT DISTINCT r.id, V.title, V.version_number as alias, V.abstract as itext, V.id as ftext, V.state AS state, V.created, V.created_by, V.modified, V.published_up as publish_up, V.published_down as publish_down, CONCAT('index.php?option=com_publications&id=', r.id) AS href, 'publications' AS section , COUNT(DISTINCT t.tagid) AS uniques , V.params, r.rating AS rcount, r.category AS data1, rt.name AS data2, r.ranking data3
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
      WHERE V.publication_id=r.id
      AND V.state=1
      AND V.main = 1
      AND t.objectid=V.id
      AND t.tbl='publications'
      AND t.tagid IN (38)
      GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
      HAVING uniques=1
      ORDER BY publish_up DESC) UNION (SELECT p.id, i.title, c.alias, NULL AS itext,
      CASE WHEN (p.description!=''
      AND p.description IS NOT NULL) THEN p.description ELSE i.description END AS ftext, i.state, p.created, p.created_by, NULL AS modified, p.created AS publish_up, NULL AS publish_down, concat('index.php?option=com_collections&controller=posts&post=', p.id) AS href, 'collections' AS section, COUNT(DISTINCT t.tagid) AS uniques, c.object_type AS params, c.object_id AS rcount, i.type AS data1, i.object_id AS data2, NULL AS data3
      FROM jos_collections_posts AS p
      INNER JOIN jos_collections AS c
      ON c.id=p.collection_id
      INNER JOIN jos_collections_items AS i
      ON p.item_id=i.id
      INNER JOIN jos_tags_object AS t
      WHERE i.state=1
      AND c.state=1
      AND t.objectid=p.item_id
      AND t.tbl='bulletinboard'
      AND t.tagid IN (38)
      AND i.access=0
      AND c.access=0
      GROUP BY p.id
      HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, e.blurb AS itext, e.description AS ftext, e.state, e.created, e.created_by, NULL AS modified, NULL AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_courses&gid=', e.alias) AS href, 'courses' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, 0 AS rcount, u.name AS data1, NULL AS data2, NULL AS data3
      FROM `jos_courses` AS e, `jos_tags_object` AS t, `jos_users` AS u
      WHERE e.created_by=u.id
      AND e.state=1
      AND t.objectid=e.id
      AND t.tbl='courses'
      AND t.tagid IN (38)
      AND e.access IN (1,1,4)
      GROUP BY e.id
      HAVING uniques=1)
      ORDER BY publish_up DESC, title
      LIMIT 0,20
  59. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = NULL
  60. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tools'
  61. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14680'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  62. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14680'
      AND `jos_author_assoc`.`subtable` = 'resources'
  63. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14646'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  64. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14646'
      AND `jos_author_assoc`.`subtable` = 'resources'
  65. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14624'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  66. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14624'
      AND `jos_author_assoc`.`subtable` = 'resources'
  67. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14496'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  68. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14496'
      AND `jos_author_assoc`.`subtable` = 'resources'
  69. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14526'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  70. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14526'
      AND `jos_author_assoc`.`subtable` = 'resources'
  71. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14466'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  72. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14466'
      AND `jos_author_assoc`.`subtable` = 'resources'
  73. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '260'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  74. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '260'
      AND `jos_author_assoc`.`subtable` = 'resources'
  75. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '142'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  76. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '142'
      AND `jos_author_assoc`.`subtable` = 'resources'
  77. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '138'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  78. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '138'
      AND `jos_author_assoc`.`subtable` = 'resources'
  79. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  80. 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-05-28 23:52:16' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-05-28 23:52:16' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '89' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  81. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  82. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  83. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  84. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  85. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  86. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  87. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  88. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590709935;s:18:\"session.timer.last\";i:1590709935;s:17:\"session.timer.now\";i:1590709935;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\":1:{s:6:\"Models\";O:8:\"stdClass\":2:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}}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:\"144f24b0276d487993862a7001f0780b\";s:12:\"tracker.ssid\";s:32:\"144f24b0276d487993862a7001f0780b\";s:12:\"tracker.rsid\";s:32:\"144f24b0276d487993862a7001f0780b\";}',`time` = '1590709936',`ip` = '10.111.11.10'
      WHERE `session_id` = '144f24b0276d487993862a7001f0780b'

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 18 × SELECT *
      FROM `jos_author_assoc`
  2. 17 × SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
  3. 14 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  4. 3 × SELECT count(f.id)
      FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_publication_versions as V, jos_publications AS r
      LEFT JOIN jos_publication_categories AS rt
      ON r.category=rt.id, jos_tags_object AS t
  5. 2 × SELECT *
      FROM `jos_resource_types`
  6. 2 × SELECT data
      FROM `jos_session`
  7. 2 × SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  8. 1 × SELECT DISTINCT gidNumber
      FROM `jos_xgroups_members`
  9. 1 × SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_blog_entries AS e, jos_tags_object AS t, jos_users AS u
  10. 1 × SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_forum_posts AS e
      LEFT JOIN jos_forum_categories c
      ON c.id = e.category_id
      LEFT JOIN jos_forum_sections s
      ON s.id = c.section_id
      LEFT JOIN jos_xgroups g
      ON g.gidNumber = e.scope_id
      LEFT JOIN jos_tags_object AS t
      ON t.objectid=e.id
      AND t.tbl='forum'
      AND t.tagid IN (38)
  11. 1 × SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_citations` AS e, `jos_tags_object` AS t
  12. 1 × SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_kb_articles` AS e
      LEFT JOIN `jos_categories` AS cc
      ON cc.id = e.category
      LEFT JOIN `jos_tags_object` AS t
      ON t.objectid=e.id
      AND t.tbl='kb'
      AND t.tagid IN (38)
  13. 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
  14. 1 × SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_courses` AS e, `jos_tags_object` AS t, `jos_users` AS u
  15. 1 × SELECT COUNT(f.id)
      FROM (SELECT p.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_collections_posts AS p
      INNER JOIN jos_collections AS c
      ON c.id=p.collection_id
      INNER JOIN jos_collections_items AS i
      ON p.item_id=i.id
      INNER JOIN jos_tags_object AS t
  16. 1 × SELECT *
      FROM jos_publication_categories as C
  17. 1 × SELECT COUNT(f.id)
      FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM `jos_answers_questions` AS a, `jos_tags_object` AS t
  18. 1 × SELECT a.rules
      FROM `jos_assets` AS `a`
  19. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  20. 1 × SELECT *
      FROM `jos_viewlevels
  21. 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
  22. 1 × SELECT session_id
      FROM `jos_session`
  23. 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
  24. 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
  25. 1 × SELECT COUNT(f.id)
      FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_events AS e, jos_tags_object AS t
  26. 1 × SELECT COUNT(f.id)
      FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_users AS a
      LEFT JOIN jos_user_profiles AS b
      ON a.id=b.user_id
      AND b.profile_key='bio', jos_tags_object AS t
  27. 1 × SELECT COUNT(f.id)
      FROM (SELECT v.page_id AS id, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_wiki_pages AS w
      INNER JOIN jos_wiki_versions AS v
      ON v.id=w.version_id
      LEFT JOIN `jos_xgroups` xg
      ON xg.gidNumber = w.scope_id
      AND w.scope='
      group'
      LEFT JOIN `jos_projects` xp
      ON xp.id = w.scope_id
      AND w.scope='project', jos_tags_object AS t
  28. 1 × SELECT *
      FROM `jos_tags`
  29. 1 × SELECT COUNT(f.gidNumber)
      FROM (SELECT a.gidNumber, COUNT(DISTINCT t.tagid) AS uniques
      FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
      ON m.gidNumber=a.gidNumber
      AND m.uidNumber=0 JOIN jos_tags_object AS t
OTHER Tables:
  1. 2 × ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
  2. 1 × (SELECT DISTINCT r.id, r.title, r.alias, r.introtext AS itext, r.fulltxt AS ftext, r.published AS state, r.created, r.created_by, r.modified, r.publish_up, r.publish_down, CONCAT('index.php?option=com_resources&id=', r.id) AS href, 'resources' AS section , COUNT(DISTINCT t.tagid) AS uniques , r.params, r.rating AS rcount, r.type AS data1, r.access AS data2, r.ranking data3
      FROM `jos_resources` AS r
      LEFT JOIN jos_resource_types AS rt
      ON r.type=rt.id , `jos_tags_object` AS t
  3. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590709935;s:18:\"session.timer.last\";i:1590709935;s:17:\"session.timer.now\";i:1590709935;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\":1:{s:6:\"Models\";O:8:\"stdClass\":2:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}}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:\"144f24b0276d487993862a7001f0780b\";s:12:\"tracker.ssid\";s:32:\"144f24b0276d487993862a7001f0780b\";s:12:\"tracker.rsid\";s:32:\"144f24b0276d487993862a7001f0780b\";}',`time` = '1590709936',`ip` = '10.111.11.10'
  4. 1 × SHOW FULL COLUMNS
      FROM `jos_publications
  5. 1 × SHOW FULL COLUMNS
      FROM `jos_publication_categories
  6. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('144f24b0276d487993862a7001f0780b','0','1590709935','10.111.11.10'
  7. 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
  • onTagView Method plgTagsResources::onTagView /core/plugins/tags/resources/resources.php:47
  • onTagView Method plgTagsWiki::onTagView /core/plugins/tags/wiki/wiki.php:33
  • onTagView Method plgTagsMembers::onTagView /core/plugins/tags/members/members.php:33
  • onTagView Method plgTagsEvents::onTagView /core/plugins/tags/events/events.php:33
  • onTagView Method plgTagsGroups::onTagView /core/plugins/tags/groups/groups.php:33
  • onTagView Method plgTagsAnswers::onTagView /core/plugins/tags/answers/answers.php:33
  • onTagView Method plgTagsForum::onTagView /core/plugins/tags/forum/forum.php:48
  • onTagView Method plgTagsBlogs::onTagView /core/plugins/tags/blogs/blogs.php:33
  • onTagView Method plgTagsCitations::onTagView /core/plugins/tags/citations/citations.php:33
  • onTagView Method plgTagsKb::onTagView /core/plugins/tags/kb/kb.php:33
  • onTagView Method plgTagsPublications::onTagView /core/plugins/tags/publications/publications.php:48
  • onTagView Method plgTagsCollections::onTagView /core/plugins/tags/collections/collections.php:33
  • onTagView Method plgTagsCourses::onTagView /core/plugins/tags/courses/courses.php:33
  • onGetMultiEntry Method plgHubzeroAutocompleter::onGetMultiEntry /core/plugins/hubzero/autocompleter/autocompleter.php:139
  • onResourcesList Method plgResourcesCoins::onResourcesList /core/plugins/resources/coins/coins.php:57
  • 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