Welcome to the Advocacy Brief, a quarterly offering from the American Society of Pediatric Hematology/Oncology. The goal of this e-newsletter is to inform members about legislative and regulatory issues impacting the profession of pediatric hematology/oncology and the patients we serve.
*Send your health policy and advocacy news to
This email address is being protected from spambots. You need JavaScript enabled to view it.
.
Special Features
ASPHO Bill Tracker
Visit ASPHO’s Legislative Tracking Chart to see a list of bills that ASPHO is monitoring.
Childhood Cancer STAR Act Update
From the Alliance for Childhood Cancer
House: We now have 60% of the House signed on to the STAR Act. We have 261 representatives signed on (109 Republicans and 152 Democrats). If we can sign on 10 more Republicans, we will have a majority of the Republican Caucus on board. Fortunately, we already have 80% of the Democratic Caucus signed on.
Senate: In the Senate, we now have 21 senators signed on (11 Democrats and 10 Republicans.) An additional nine Democratic senators have asked to sign on but we are waiting for additional Republicans to join before we add them.
Status of Negotiations
In the Senate, the staff of Senators Capito and Reed have been meeting with the Senate Health, Education, Labor, and Pensions (HELP) Committee to negotiate some of the details of the STAR Act before the Senate moves the bill to a mark-up and then to the floor for a vote. HELP Chairman Lamar Alexander (R-TN) has pledged to move the STAR Act though the Senate this year.
As you know, the House approved the STAR Act in December. Since this is a new Congress, the House will have to approve the bill once again. Congressman McCaul has already discussed the STAR Act with House Energy and Commerce Chairman Walden. They are discussing the possibility of moving the STAR Act through the House in September for Childhood Cancer Month. We will report on more details of these negotiations as they become available.
How can ASPHO members get involved?
Contact these key senators and ask them to support the STAR Act:
Bob Corker (R-TN)
Joni Ernst (R-IA)Deb Fischer (R-NE)
Cory Gardner (R-CO)
Dean Heller (R-NV)
Ron Johnson (R-WI)
Lisa Murkowski (R-AK)
Rob Portman (R-OH)
Pat Roberts (R-KS)
Tim Scott (R-SC)
Pat Toomey (R-PA)
There are currently 18 Republicans and 15 Democrats in the House that cosponsored the STAR Act last Congress but have not signed back on yet (despite repeated requests). We need to reach out to the following to ask why they have not signed back on:
Adams, Alma (D-NC)
Bilirakis, Gus (R-FL)
Bishop, Mike (R-MI)
Buchanan, Vern (R-FL)
Bucshon, Larry (R-IN)
Burgess, Michael (R-TX)
Castro, Joaquin (D-TX)
Collins, Chris (R-NY)
Crawford, Rick (R-AR)
Cuellar, Henry (D-TX)
Davis, Danny (D-IL)
Dent, Charles (R-PA)
Doggett, Lloyd (D-TX)
Esty, Elizabeth (D-CT)
Fortenberry, Jeff (R-NE)
Hill, French (R-AR)
Hudson, Richard (R-NC)
Johnson, Eddie Bernice (D-TX)
Lee, Barbara (D-CA)
Jackson Lee, Sheila (D-TX)
Lynch, Stephen (D-MA)
Murphy, Tim (R-PA)
Reed, Tom (R-NY)
McMorris Rodgers, Cathy (R-WA)
Meadows, Mark (R-NC)
Meeks, Gregory (D-NY)
Meng, Grace (D-NY)
Neal, Richard (D-MA)
Paulsen, Erik (R-MN)
Rokita, Todd (R-IN)
Ruppersberger, C.A. (D-MD)
Sanford, Mark (R-SC)
Schrader, Kurt (D-OR)
RACE Act Signed into Law
The Research to Accelerate Cures and Equity (RACE) for Children Act was signed into law on August 18, 2017, as part of the Food and Drug Reauthorization Act. The RACE for Children Act modifies the Pediatric Research Equity Act by requiring companies developing cancer drugs to conduct studies in children when the molecular target of their drug is relevant to a children’s cancer. Read a press release from Kids v Cancer.
Take Action on the Deferment for Active Cancer Treatment Act
Contact your representative and ask him or her to support the Deferment for Active Cancer Treatment Act (H.R. 2976), which allows for the deferment of certain student loans during a period in which a borrower is receiving treatment for cancer and 6 months after such period.
ASPHO Concerned with Proposed Changes to Medicaid
ASPHO joined other organizations in a letter to Senate leadership outlining concerns about potential changes to the fundamental structure and purpose of Medicaid.
ASPHO Supports Expanded Access Principles
As policymakers debate changes to the way in which unapproved therapies are accessed, ASPHO agrees that changes should adhere to certain principles.
2017 Childhood Cancer Awareness Month Activities
Sept 13–14: Rally for Medical Research Sept 14: Congressional Childhood Cancer Caucus Sept 14: Alliance Luncheon and Art Show (call for exhibits below) Sept 14: Golden Toast Sept 16–17: Cure Fest
Calling all childhood cancer families! You're invited to submit artwork for the 3rd Annual Alliance for Childhood Cancer Art Exhibit. The exhibit will showcase the work of children with cancer, survivors, and siblings and will be featured on Capitol Hill immediately following the Congressional Childhood Cancer Summit in September. Click here for more information.
Spending Bill Clears First Hurdle
The House Appropriations' Labor, Health, and Human Services (LHHS) Subcommittee passed their Fiscal Year (FY) 2018 spending bill, which includes:
Program
FY 2018 House Committee
+/-
Health Resources and Services Administration (HRSA)
Sickle Cell Services Demonstration Program
$4.455 million
Level
Special Projects of Regional and National Significance (SPRANS)-Sickle Cell
$3 million
Level
Children’s Hospitals Graduate Medical Education
$300 million
Level
National Institutes of Health (NIH)
$35 billion
+
National Cancer Institute (NCI)
$5.47 billion
+
Gabrielle Miller Kids First Research Act
$12.6 million
Level
National Heart, Lung, & Blood Institute
$3.256 billion
+
Cancer Moonshot Initiative
National Institute of Health (NIH)
$300 million
Level
FDA Commits to Reducing Orphan Drug Backlog
The Food & Drug Administration (FDA) released a strategic plan to ensure timely review of orphan drug designation requests. The goals of the plan are as follows:
In 90 days, the FDA will complete reviews of all orphan drug designation requests that are older than 120 days (the backlog) while maintaining consistent, scientifically rigorous reviews.
Within 90 days of receipt, all new orphan drug designation requests will receive a response by the agency.
Specific to pediatrics, the Office of Orphan Products Development (OOPD) will collaborate with the Office of Pediatric Therapeutics (OPT) to jointly review rare pediatric disease designation requests. In these cases, OPT will conduct the pediatric review and OOPD will conduct the rare disease review. This policy began as of May 15, 2017.
Orphan status for drugs and biologics is defined as those intended for the safe and effective treatment, diagnosis or prevention of rare diseases/disorders that affect fewer than 200,000 people in the United States, or that affect more than 200,000 persons but are not expected to recover the costs of developing and marketing a treatment drug.
FDA Launches Expanded Access Navigator
The Food and Drug Administration (FDA) has launched a new online tool called the Expanded Access Navigator to educate patients and physicians about the FDA’s expanded access process including a directory where companies can submit public links to their expanded access policies, criteria used by companies to determine whether to make a drug available through expanded access, and contact information.
FDA to Host Pediatric Trial Design Workshop
On September 8, 2017, the FDA is hosting a public workshop titled “Pediatric Trial Design and Modeling: Moving into the Next Decade.” The purpose of this 1-day workshop is to
review the current best practices in designing pediatric drug development trials using the knowledge and tools available
discuss problems and potential solutions presently encountered with pediatric drug development trials
discuss strategies related to design and evaluation that have the best chance of facilitating and optimizing the use of pediatric drug development trials to achieve the labeling of products for pediatric indications.
The 21st Century Cures Act, which was signed into law in December 2016 made $300 million available in Fiscal Year 2017 for the National Cancer Institute (NCI) to accelerate research efforts aligned with the Cancer Moonshot. The NCI has updated the Cancer Moonshot webpage to list all funding opportunity announcements aligned with the goals of the Moonshot.
For more information on ASPHO's coalition partners and activities, here are some helpful links:
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/knowledge-center/advocacy-brief/2017-august-advocacy-brief-2' 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/knowledge-center/advocacy-brief/2017-august-advocacy-brief-2' or `alias` = 'ongkong.tech/knowledge-center/advocacy-brief/2017-august-advocacy-brief-2' or `alias` = 'ongkong.tech/knowledge-center/advocacy-brief/2017-august-advocacy-brief-2/' order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd` FROMv311_sh404sef_urls WHERE `oldurl`='knowledge-center/advocacy-brief/2017-august-advocacy-brief-2' 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 = 364 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-28 07:54:52') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-28 07:54:52') 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=38 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` = 364 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.364')
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 = 38 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:54:52') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-28 07:54:52')
ORDERBY a.created DESC
UPDATEv311_content SET hits = hits + 1 WHERE id = 364
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` = '364'
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 38
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 13
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 1
SELECT m.menutype
FROMv311_menuAS m
WHERE m.id = 609
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 609
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 523
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 183
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 1
SELECT* FROMv311_content WHERE `id` = '364'
SELECT* FROMv311_content WHERE `id` = '364'
SELECT* FROMv311_content WHERE `id` = '364'
SELECT* FROMv311_content WHERE `id` = '364'
SELECT* FROMv311_content WHERE `id` = '364'
SELECT* FROMv311_content WHERE `id` = '364'
SELECT* FROMv311_banners WHERE '2024-11-28 07:54:52' >= '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`=364;
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=38 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=609&id=364&lang=en&view=article';
UPDATE `v311_session`
SET `data` = '__default|a:12:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732780492;s:18:\"session.timer.last\";i:1732780492;s:17:\"session.timer.now\";i:1732780492;s:24:\"session.client.forwarded\";s:12:\"3.145.63.131\";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:\"cba8bf6408fd0799c2f32448410fb1fd\";s:17:\"url_joomla_logout\";s:101:\"http://stage.aspho.org/index.php?option=com_users&task=user.logout&191f5ef1b73e168554811b630a66afa6=1\";s:12:\"url_amc_prev\";s:96:\"http://306847.minerockhongkong.tech/knowledge-center/advocacy-brief/2017-august-advocacy-brief-2\";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` = '1732780493'
WHERE `session_id` = 'jq1oc214tt2s31g5tbo2atafu0'
40 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
3 × SELECT t.parent_id FROMv311_categories 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 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
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 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:1732780492;s:18:\"session.timer.last\";i:1732780492;s:17:\"session.timer.now\";i:1732780492;s:24:\"session.client.forwarded\";s:12:\"3.145.63.131\";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:\"cba8bf6408fd0799c2f32448410fb1fd\";s:17:\"url_joomla_logout\";s:101:\"http://stage.aspho.org/index.php?option=com_users&task=user.logout&191f5ef1b73e168554811b630a66afa6=1\";s:12:\"url_amc_prev\";s:96:\"http://306847.minerockhongkong.tech/knowledge-center/advocacy-brief/2017-august-advocacy-brief-2\";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` = '1732780493'
1 × SHOWFULLCOLUMNS FROM `v311_content
1 × UPDATEv311_content SET hits = hits + 1
1 × 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
