ASPHO’s election recently ended, and the following members will assume positions on the Board of Trustees and Nominating Committee following the upcoming 2019 ASPHO Conference.
At-Large Trustees: Betty Pace, MD, Augusta University Maria Velez, MD, Louisiana State University Health Sciences Center/Children's Hospital of New Orleans
Nominating Committee: Glen Lew, MD, Aflac Cancer and Blood Disorders Center Taizo Nakano, MD, Children’s Hospital Colorado
ASPHO would like to thank outgoing Board members Leo Mascarenhas, MD and Akiko Shimamura, MD PhD, as well as outgoing Nominating Committee members Jeff Hord, MD and Char Witmer, MD, for their hard work and dedication.
SELECT `data`
FROM `v311_session`
WHERE `session_id` = '2bgf5dcsbje6igh5unbokcjgq5'
SELECT extension_id AS id, element AS "option", params, enabled
FROMv311_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT folder AS type, element AS name, params
FROMv311_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,5)
ORDERBY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROMv311_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT params FROMv311_modules WHERE module = 'mod_egdamcsso';
CREATETABLEIFNOTEXISTS `v311_egd_impexiumsso` (
`id` int(11) NOTNULL auto_increment,
`customer_token` text NOTNULL,
`customer_id` text NOTNULL,
`sso_return_url` text NOTNULL,
`day` date NOTNULL,
PRIMARYKEY (`id`)
) ENGINE=MyISAM DEFAULTCHARSET=utf8 AUTO_INCREMENT=173;
SELECT `params` FROMv311_extensions WHERE `element`='com_sh404sef' AND `type`='component';
SELECT* FROMv311_languages WHERE published=1
ORDERBY ordering ASC
SELECT id,oldurl,newurl FROM `v311_sh404sef_urls` WHERE oldurl = 'http://306847.minerockhongkong.tech/2019-board- and-nominating-committee-members' AND rank = 0;
SELECT* FROM `v311_osemsc_configuration`
SELECT* FROM `v311_osemsc_content` WHERE (type = 'joomla') AND (content_type = 'menu') AND (status = '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
FROMv311_menuAS m
LEFTJOINv311_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
select `alias`,`newurl` from `v311_sh404sef_aliases` where `alias` = 'http://306847.minerockhongkong.tech/2019-board- and-nominating-committee-members' or `alias` = 'ongkong.tech/2019-board- and-nominating-committee-members' or `alias` = 'ongkong.tech/2019-board- and-nominating-committee-members/' order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd` FROMv311_sh404sef_urls WHERE `oldurl`='2019-board- and-nominating-committee-members' ORDERBY `rank`;
SELECT extension_id AS id, element AS "option", params, enabled
FROMv311_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT id, home, template, s.params
FROMv311_template_styles as s
LEFTJOINv311_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
WHERE s.client_id = 0 AND e.enabled = 1
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT b.id
FROMv311_usergroupsAS a
LEFTJOINv311_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 9
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASEWHEN badcats.id is null THEN a.state ELSE 0 ENDAS state, a.catid, a.created, a.created_by, a.created_by_alias, CASEWHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROMv311_contentAS a
LEFTJOINv311_categoriesAS c on c.id = a.catid
LEFTJOINv311_usersAS u on u.id = a.created_by
LEFTJOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROMv311_contact_detailsAS contact
WHERE contact.published = 1
GROUPBY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFTJOINv311_categories as parent ON parent.id = c.parent_id
LEFTJOINv311_content_ratingAS v ON a.id = v.content_id
LEFT OUTERJOIN (SELECT cat.id as id FROMv311_categoriesAS cat JOINv311_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUPBY cat.id) AS badcats ON badcats.id = c.id
WHERE a.id = 508 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-28 07:51:38') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-28 07:51:38') AND (a.state = 1 OR a.state =2)
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASEWHENCHAR_LENGTH(c.alias) != 0 THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROMv311_categories as c
LEFTJOINv311_categoriesAS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt)
LEFTJOIN (SELECT cat.id as id FROMv311_categoriesAS cat JOINv311_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUPBY cat.id) AS badcats ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id=2 AND badcats.id is null
GROUPBY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDERBY c.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROMv311_extensions WHERE `type` = 'component' AND `element` = 'com_tags'
SELECT `m`.`tag_id`,`t`.* FROM `v311_contentitem_tag_map` AS m
INNERJOIN `v311_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 508 AND `t`.`published` = 1 AND t.access IN (1,1,5)
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.508')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT a.id, CASEWHENCHAR_LENGTH(a.alias) != 0 THENCONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASEWHENCHAR_LENGTH(cc.alias) != 0 THENCONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROMv311_contentAS a
LEFTJOINv311_categoriesAS cc ON cc.id = a.catid
WHERE a.catid = 2 AND a.state = 1 AND a.access = 1 AND (a.state = 1 OR a.state = -1) AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-28 07:51:38') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-28 07:51:38')
ORDERBY a.created DESC
UPDATEv311_content SET hits = hits + 1 WHERE id = 508
SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROMv311_modulesAS m
LEFTJOINv311_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
LEFTJOINv311_advancedmodules as am ON am.moduleid = m.id
WHERE m.published = 1 AND e.enabled = 1 AND m.client_id = 0 AND m.access IN (1,1,5)
ORDERBY m.ordering, m.id
SELECT extension_id AS id, element AS "option", params, enabled
FROMv311_extensions WHERE `type` = 'component' AND `element` = 'com_advancedmodules'
SHOWFULLCOLUMNS FROM `v311_content`
SELECT* FROMv311_content WHERE `id` = '508'
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 2
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 1
SELECT m.menutype
FROMv311_menuAS m
WHERE m.id = 777
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 777
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 168
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 166
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 1
SELECT* FROMv311_content WHERE `id` = '508'
SELECT* FROMv311_content WHERE `id` = '508'
SELECT* FROMv311_content WHERE `id` = '508'
SELECT* FROMv311_content WHERE `id` = '508'
SELECT* FROMv311_content WHERE `id` = '508'
SELECT* FROMv311_content WHERE `id` = '508'
SELECT* FROMv311_banners WHERE '2024-11-28 07:51:38' >= 'reset' AND `reset` != '0000-00-00 00:00:00' AND `reset`!=NULL AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROMv311_banners as a
LEFTJOINv311_banner_clientsAS cl ON cl.id = a.cid
WHERE a.state=1 AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') AND (a.imptotal = 0 OR a.impmade <= a.imptotal) AND a.catid IN (0,41)
ORDERBY a.sticky DESC,a.ordering
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROMv311_banners as a
LEFTJOINv311_banner_clientsAS cl ON cl.id = a.cid
WHERE a.state=1 AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') AND (a.imptotal = 0 OR a.impmade <= a.imptotal) AND a.catid IN (0,41)
ORDERBY a.sticky DESC,a.ordering LIMIT 0, 5
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_jdonation&Itemid=386&campaign_id=1&lang=en&view=donation';
SELECT `id`, `title`, `alias`, `catid`, `language` FROMv311_content WHERE `id`=508;
SELECT* FROMv311_categories WHERE parent_id > 0 and extension = 'com_content' and path = 'uncategorised' and level = 1;
SHOWFULLCOLUMNS FROM `v311_sh404sef_metas`
SELECT* FROMv311_sh404sef_metas WHERE `newurl`='index.php?option=com_content&Itemid=777&id=508&lang=en&view=article';
UPDATE `v311_session`
SET `data` = '__default|a:12:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1732780296;s:18:\"session.timer.last\";i:1732780296;s:17:\"session.timer.now\";i:1732780298;s:24:\"session.client.forwarded\";s:14:\"18.117.156.170\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"a4e3e1da878f4403b205387ed80a55a6\";s:12:\"url_amc_prev\";s:79:\"http://306847.minerockhongkong.tech/2019-board- and-nominating-committee-members\";s:8:\"oseClass\";a:9:{s:8:\"registry\";s:11:\"oseregistry\";s:3:\"msc\";s:10:\"membership\";s:4:\"user\";s:4:\"user\";s:6:\"member\";s:6:\"member\";s:7:\"payment\";s:7:\"payment\";s:6:\"remote\";s:6:\"remote\";s:3:\"lic\";s:7:\"license\";s:7:\"content\";s:7:\"content\";s:5:\"debug\";s:5:\"debug\";}s:17:\"url_joomla_logout\";s:101:\"http://stage.aspho.org/index.php?option=com_users&task=user.logout&f41f40fb5cc455efebdcc21facfe6ac1=1\";}'
, `time` = '1732780298'
WHERE `session_id` = '2bgf5dcsbje6igh5unbokcjgq5'
36 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
7 × SELECT* FROMv311_content
5 × SELECT extension_id AS id, element AS "option", params, enabled FROMv311_extensions
4 × SELECT t.parent_id FROMv311_menu as t
2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROMv311_banners as a LEFTJOINv311_banner_clientsAS cl ON cl.id = a.cid
2 × SELECT b.rules FROMv311_assetsAS a LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
2 × SELECT t.parent_id FROMv311_categories as t
1 × SELECT a.id, CASEWHENCHAR_LENGTH(a.alias) != 0 THENCONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASEWHENCHAR_LENGTH(cc.alias) != 0 THENCONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROMv311_contentAS a LEFTJOINv311_categoriesAS cc ON cc.id = a.catid
1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down FROMv311_modulesAS m LEFTJOINv311_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id LEFTJOINv311_advancedmodules as am ON am.moduleid = m.id
1 × SELECT `m`.`tag_id`,`t`.* FROM `v311_contentitem_tag_map` AS m INNERJOIN `v311_tags` AS t ON `m`.`tag_id` = `t`.`id`
1 × SELECT m.menutype FROMv311_menuAS m
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASEWHEN badcats.id is null THEN a.state ELSE 0 ENDAS state, a.catid, a.created, a.created_by, a.created_by_alias, CASEWHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count FROMv311_contentAS a LEFTJOINv311_categoriesAS c on c.id = a.catid LEFTJOINv311_usersAS u on u.id = a.created_by LEFTJOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROMv311_contact_detailsAS contact
1 × SELECT id,oldurl,newurl FROM `v311_sh404sef_urls`
1 × SELECT* FROM `v311_osemsc_configuration
1 × SELECT* FROMv311_languages
1 × SELECT `params` FROMv311_extensions
1 × SELECT folder AS type, element AS name, params FROMv311_extensions
1 × SELECT params FROMv311_modules
1 × SELECT* FROM `v311_osemsc_content`
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 FROMv311_menuAS m LEFTJOINv311_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT b.id FROMv311_usergroupsAS a LEFTJOINv311_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `data` FROM `v311_session`
1 × SELECT id, home, template, s.params FROMv311_template_styles as s LEFTJOINv311_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id