Welcome, President Billett Q&A with ASPHO's New President
Amy Billett, MD
What is your vision for ASPHO during the next 2 years? Are there particular undertakings you anticipate?
My most important goal in the next year is to help guide ASPHO through an effective strategic planning process because that will impact ASPHO long after my term as president ends. We have already had several meetings to prepare for strategic planning, and we have hired a consultant to ensure we complete the process effectively. ASPHO has a phenomenal board of trustees, but we want to strengthen everyone’s skills around strategic planning. We want the board to be knowledgeable about strategic planning in general before getting into the details of the process itself. The first level of strategic planning will involve gathering existing data from needs assessment and member surveys. We want to focus on what will help ASPHO grow and be better. We hope to have a draft strategic plan by fall, and then we will be refining it and posting it for member comments and feedback. We hope that members will be vocal. Next, we will make edits and eventually share the new plan at the 2017 Annual Meeting.
Overall, I hope that ASPHO is a stronger and more effective organization when I hand the gavel to Patrick Leavey in 2018.
What do you feel are the greatest challenges facing ASPHO as an organization?
This is the key question as we begin our strategic planning process. Our members work in a wide variety of practice settings, with or without areas of specialty, and follow many different career paths. We want to ensure that ASPHO works well for all, including members at small, medium, and large institutions. We want to ensure our diversity considers not only common attributes of diversity, but also diversity within our field. We would like to make sure that we acknowledge its importance and ensure that ASPHO meets the needs of our diverse membership.
Fifty percent of the clinical workforce in our field is now made up of advanced practice providers (APPs). We need to understand the needs of the small but growing number of APP members and consider the optimal way for ASPHO to address this segment of our workforce. What is the optimal way of moving forward as the world around us changes?
We need to constantly monitor member engagement in the organization; engagement is all about value. We are all bombarded by various organizations, including our own institutions, with information and opportunities. How does ASPHO become the “go to” for our members in getting the information, knowledge, and news they need to be engaged? This dovetails with diversity and inclusion as well as communication strategies. We need to do a good job of providing concise, relevant and up-to-date information. The reason we’re doing the strategic plan is to address these and other types of concerns that will arise.
In your candidate statement, you mentioned three areas important to the subspecialty’s future—research funding, work force, and efficiency of professional practice . Can you elaborate?
Research funding is critical to moving our field forward and is one of our recently defined advocacy priorities. Through ASPHO’s membership in the Alliance for Childhood Cancer, we regularly advocate in Washington, DC, for increased NIH funding. I am proud of ASPHO’s Clinician Educator Awards that were sponsored by the Enriching the Future Campaign, our Young Investigator Travel Awards, and our partnership with St. Baldrick’s Foundation for the Robert J. Arceci Innovation Award.
The workforce topic is really critical, and it has become a major focus. We are very much focused on ensuring that we help support and grow the new people entering our field, as they will be the leaders of ASPHO in the future. This work began under the leadership of others, but moving it forward to completion is important. ASPHO is supporting the development of a white paper on the workforce in our field. I would like to take this moment to thank Jeff Hord, MD, for his dedicated leadership of several workforce surveys and Allen Wayne, MD, and Patrick Leavey, MD, for leading the task force. We know how important this information is to members because the workforce data is downloaded often from ASPHO’s website.
Efficiency of professional practice is a challenge for all of us. Joanne Hilden, MD, our recent past president, has been leading efforts to ensure ASPHO is “at the table” as potential changes to Maintenance of Certification are considered by the American Board of Pediatrics. I plan to continue this work in conjunction with Joanne. We have asked the Practice Committee to think of how we can best share information among institutions and how we can best share approaches so that each individual site doesn’t need to recreate the wheel for everything.
Is there anything in general you would like to say to the members as your term as ASPHO President begins?
I hope that all members of ASPHO reach out to me with suggestions and questions. And if you are not already a volunteer in one of ASPHO’s activities, I encourage you to get involved. There is a volunteer link on the ASPHO website; if you’d like to get involved, fill it out and we’ll get back to you. When we send communications out for comment concerning the strategic plan, please take the time to share your thoughts. Reach out to a committee chair if there’s a specific area you’d like to discuss. If you think there’s a SIG that ASPHO doesn’t have but should, let us know. There are a multitude of ways to get involved in ASPHO.
You’ve been an ASPHO member for most of your career. How has the membership benefitted you through different stages of your career?
It goes without saying that I am a better clinician because of all the information I have learned by attending the annual meetings. However, I think the most important member benefit to me has been getting to know so many different people in our field, at many different career stages, involved in many different areas. ASPHO truly feels like home. Even before ASPHO offered a formal mentoring program, I found outside mentors through ASPHO. In recent years, I have particularly benefited from career development sessions that help me in my own career and also help me to help others.
What do you enjoy doing outside of work?
Reading is my number one way to relax. For a while, I refused to get an e-reader because I love physical books, but I eventually caved in and now I love to travel without piles of books weighing down my suitcase. I continue to enjoy parenting because there are always new challenges and new delights with each phase. My husband and I think we have mastered social media well enough to know what our three young adult children are doing, but realize that we are deluded. We only see what they want us to see. We treasure opportunities to travel as a family, including hiking in Patagonia last December.
SELECT extension_id AS id, element AS "option", params, enabled
FROMv311_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id
FROMv311_usergroupsAS a
LEFTJOINv311_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 9
SELECT id, rules
FROM `v311_viewlevels`
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/about/q-a-amy-billett' 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/about/q-a-amy-billett' or `alias` = 'ongkong.tech/about/q-a-amy-billett' or `alias` = 'ongkong.tech/about/q-a-amy-billett/' order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd` FROMv311_sh404sef_urls WHERE `oldurl`='about/q-a-amy-billett' 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 a.rules
FROMv311_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
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 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 = 260 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-01 00:24:29') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-01 00:24:29') 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=16 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` = 260 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.260')
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 = 16 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-12-01 00:24:29') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-01 00:24:29')
ORDERBY a.created DESC
UPDATEv311_content SET hits = hits + 1 WHERE id = 260
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` = '260'
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 16
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 1
SELECT m.menutype
FROMv311_menuAS m
WHERE m.id = 494
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 494
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` = '260'
SELECT* FROMv311_content WHERE `id` = '260'
SELECT* FROMv311_content WHERE `id` = '260'
SELECT* FROMv311_content WHERE `id` = '260'
SELECT* FROMv311_content WHERE `id` = '260'
SELECT* FROMv311_content WHERE `id` = '260'
SELECT* FROMv311_banners WHERE '2024-12-01 00:24:29' >= '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`=260;
SELECT* FROMv311_categories WHERE parent_id > 0 and extension = 'com_content' and path = 'uncategorised' and level = 1;
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 s.id=16 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
SHOWFULLCOLUMNS FROM `v311_sh404sef_metas`
SELECT* FROMv311_sh404sef_metas WHERE `newurl`='index.php?option=com_content&Itemid=494&id=260&lang=en&view=article';
UPDATE `v311_session`
SET `data` = '__default|a:12:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1733012669;s:18:\"session.timer.last\";i:1733012669;s:17:\"session.timer.now\";i:1733012669;s:24:\"session.client.forwarded\";s:12:\"18.221.8.126\";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:\"3fc7a16768b4c986ad4ecf55f2649cef\";s:17:\"url_joomla_logout\";s:101:\"http://stage.aspho.org/index.php?option=com_users&task=user.logout&bd90040718e4f908f223b5c27ee5f980=1\";s:12:\"url_amc_prev\";s:57:\"http://306847.minerockhongkong.tech/about/q-a-amy-billett\";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\";}}'
, `time` = '1733012670'
WHERE `session_id` = 'uu6ppudo4imnc2krcmirp3a3c7'
41 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
3 × SELECT t.parent_id FROMv311_menu as t
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
2 × SELECT b.rules FROMv311_assetsAS a LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
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 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`.`tag_id`,`t`.* FROM `v311_contentitem_tag_map` AS m INNERJOIN `v311_tags` AS t ON `m`.`tag_id` = `t`.`id`
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 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 m.menutype FROMv311_menuAS m
1 × SELECT* FROMv311_categories
1 × SELECT* FROMv311_sh404sef_metas
1 × SELECT* FROMv311_banners
1 × SELECT a.rules FROMv311_assetsAS a
1 × SELECT params FROMv311_modules
1 × SELECT `params` FROMv311_extensions
1 × SELECT folder AS type, element AS name, params FROMv311_extensions
1 × SELECT id, rules FROM `v311_viewlevels
1 × SELECT `session_id` FROM `v311_session`
1 × SELECT b.id FROMv311_usergroupsAS a LEFTJOINv311_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT* FROMv311_languages
1 × SELECT id,oldurl,newurl FROM `v311_sh404sef_urls`
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
1 × select `alias`,`newurl` from `v311_sh404sef_aliases`
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* FROM `v311_osemsc_configuration
1 × SELECT* FROM `v311_osemsc_content`
1 × SELECT `data` FROM `v311_session`
OTHER Tables:
1 × SHOWFULLCOLUMNS FROM `v311_sh404sef_metas
1 × UPDATE `v311_session` SET `data` = '__default|a:12:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1733012669;s:18:\"session.timer.last\";i:1733012669;s:17:\"session.timer.now\";i:1733012669;s:24:\"session.client.forwarded\";s:12:\"18.221.8.126\";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:\"3fc7a16768b4c986ad4ecf55f2649cef\";s:17:\"url_joomla_logout\";s:101:\"http://stage.aspho.org/index.php?option=com_users&task=user.logout&bd90040718e4f908f223b5c27ee5f980=1\";s:12:\"url_amc_prev\";s:57:\"http://306847.minerockhongkong.tech/about/q-a-amy-billett\";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\";}}' , `time` = '1733012670'