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.
.
Raise your hand if the elections played out exactly as you thought they would.
Maybe you can, maybe you can’t. Those pesky election statistics were right this time, though: Democrats won the House and Republicans stayed in control of the Senate. According to exit polls, voters were most concerned about health care.1 What does this mean for ASPHO? Health care is at the top of everyone’s agenda in 2019. Here are some of the biggest issues in play beginning in 2019:
Three red states, Nebraska, Idaho, and Utah, voted to expand Medicaid via ballot initiative. This expansion would allow individuals whose income reaches up to 138% of the federal poverty level to gain access to medical care. An estimated 300,000 low-income people, including children, will gain access to health care in these three states.2 This momentum may expand to other states: Maine, Kansas, and Wisconsin may also seek to expand Medicaid. Overall, this means more children with access to care.
Pre-existing conditions protections are safe – for now. With a Democrat majority in the House, no repeal bill will pass this chamber, even if a repeal passes the Senate. However, there is a lawsuit in Texas, titled Texas v. United States, which challenges the individual mandate and potentially the entire Affordable Care Act, including pre-existing conditions protections. The lawsuit was joined by 20 Republican state attorney generals, governors, and two individuals. The Department of Justice is not defending the case, leaving 16 Democrat state attorney generals and governors to defend the law.3
One of the most talked-about topics in Congress right now is drug pricing. The President has publically discussed plans to combat high drug costs. Many Democrats campaigned on the promise of lower drug prices if elected. This could be one topic that finds bipartisan support in the next Congress, but there may be pushback from the pharmaceutical industry. Cancer drugs are some of the most expensive drugs in the industry. Potential price drops could mean greater access.
ASPHO will continue to engage on issues that affect pediatric hematology and oncology. In conjunction with our coalition partners, we will continue to engage on the following health policy agenda items: • Ensure adequate federal funding for research, surveillance and other legislation • Improve access to drugs, devices and biologics for children and adolescents • Promote adequate payment for care of children by subspecialists in pediatric hematology/oncology to support needed access and workforce
Sarah Nichelson, JD, Health Policy and Advocacy Manager
References:
1. Benjy Sarlin, Midterm exit polls: Health care is top issue for voters, NBC News (November 6, 2018) 2. “What the 2018 Midterm Elections Means for Health Care," Health Affairs Blog, November 7, 2018. DOI: 10.1377/hblog20181107.185087 3. “Judge Hears Oral Arguments In Texas v. United States," Health Affairs Blog, September 10, 2018. DOI: 10.1377/hblog20180910.861789
Legislative/Regulatory News
Sickle Cell Research Bill Passed by Congress
On December 11, the House passed the bipartisan bill S. 2465, the Senate version of the Sickle Cell Disease Research, Surveillance, Prevention, and Treatment Act. The bill previously passed the Senate on October 11, 2018. Now that S. 2465 has passed both chambers of Congress, it will be sent to the President for his signature. S. 2465 is an important step in providing grants to states, institutions, and non-profits to study sickle cell disease and other heritable blood disorders. ASPHO has worked with the Sickle Cell Disease Coalition to bring awareness about this bill to members and to advocate for its passage with members of Congress. Thank you to all for your persistence and hard work.
ASPHO Participates in October Alliance for Childhood Cancer Meeting
On October 10, 2018, ASPHO members Eric Sandler and Wendy Darlington participated in the fall Alliance meeting. ASPHO maintains two representatives to the Alliance as part of the Advocacy Committee charge to collaborate with other organizations as appropriate to achieve the Society’s identified priorities. As you recall, the Alliance was one of the biggest supporters of the Childhood Cancer STAR Act, a bill that would maximize discovery and accelerate development and availability of promising childhood cancer treatments, and spent many years working towards its eventual passage. Now that the bill has passed, the Alliance is shifting focus to STAR Act implementation. The meeting also discussed ongoing work on global health issues associated with childhood cancer, received an update on Children’s Oncology Group, discussed challenges of implementing the Right to Try Act, and brainstormed goals for the next three to five years. The Alliance will hold its Action Day in Washington, D.C. in early spring and ASPHO looks forward to our continued involvement.
ASPHO Supports Pediatric Subspeciality Loan Repayment Program
ASPHO joined the American Academy of Pediatrics and 61 other groups to support reauthorizing loan repayment for pediatric subspecialists as part of the broader effort to reauthorize Title VII health professions workforce programs. If enacted, this program would increase pediatric subspecialists and encourage greater geographic distribution, ultimately increasing access to children in underserved areas.
ASPHO Supports Letter to General Accountability Office
ASPHO signed on to a letter with the Alliance for Childhood Cancer that asked the General Accountability Office (GAO) to provide specific recommendations on improving access and payment for childhood cancer survivorship and palliative care programs.
WHO Announces Global Childhood Cancer Initiative
In September 2018, the World Health Organization announced the Global Initiative for Childhood Cancer. This initiative aims to increase prioritization of childhood cancer through awareness raising at global and national levels and to expand the capacity of countries to deliver best practice in childhood cancer care.
ASH Congressional Fellowship Program Now Accepting Applications
The American Society of Hematology is presenting a new ASH Congressional Fellowship, which will allow a hematologist to work in a Congressional office on Capitol Hill and help shape health care and hematology policy for an academic year beginning in September 2019. For more information about the fellowship and how to apply, visit the ASH website.
Global Shortage of Erwinaze
Several members have alerted ASPHO about the Asparaginase Erwinia Chrysanthemi (Erwinaze) shortage. ASPHO has reached out to IRC member Jazz Pharmaceuticals for more information. Jazz Pharmaceuticals recommends setting up supply alerts at the website Erwinaze Supply. Those who sign up will be alerted when the drug is in stock and when the drug is out of stock. The FDA is reporting that the drug is expected to be available the week of January 14, 2019, at the earliest. ASPHO members can see information about the shortage at the supply website above or on the FDA Drug Shortages website.
Cancer Moonshot Update
The National Cancer Institute (NCI) has been busy implementing the report created by the Moonshot Blue Ribbon Panel. The report covered 10 areas for research. One area specific to childhood cancer is to “intensify research on the major drivers of childhood cancers,” specifically to “improve our understanding of fusion oncoproteins in pediatric cancer and use new preclinical models to develop inhibitors that target them.” NCI is funding a research team who is studying immunotherapeutic approaches in children. Their efforts are targeted at identifying immune targets and specific treatments for pediatric cancers, as well as modeling immunotherapy testing against cancer. The Moonshot is also funding research on highly aggressive pediatric cancers.
For more information on our coalition partners and activities here are some helpful links:
SELECT `data`
FROM `v311_session`
WHERE `session_id` = 'upei6e3k5ftguhrmisbv78f5e7'
DELETE FROM `v311_session`
WHERE `time` < '1732774483'
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/knowledge-center/advocacy-brief/advocacy-brief-december-2018' 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/advocacy-brief-december-2018' or `alias` = 'ongkong.tech/knowledge-center/advocacy-brief/advocacy-brief-december-2018' or `alias` = 'ongkong.tech/knowledge-center/advocacy-brief/advocacy-brief-december-2018/' order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd` FROMv311_sh404sef_urls WHERE `oldurl`='knowledge-center/advocacy-brief/advocacy-brief-december-2018' 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 = 484 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-28 07:44:43') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-28 07:44:43') 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` = 484 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.484')
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:44:43') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-28 07:44:43')
ORDERBY a.created DESC
UPDATEv311_content SET hits = hits + 1 WHERE id = 484
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` = '484'
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 = 750
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 750
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` = '484'
SELECT* FROMv311_content WHERE `id` = '484'
SELECT* FROMv311_content WHERE `id` = '484'
SELECT* FROMv311_content WHERE `id` = '484'
SELECT* FROMv311_content WHERE `id` = '484'
SELECT* FROMv311_content WHERE `id` = '484'
SELECT* FROMv311_banners WHERE '2024-11-28 07:44:43' >= '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`=484;
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=750&id=484&lang=en&view=article';
UPDATE `v311_session`
SET `data` = '__default|a:12:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1732779880;s:18:\"session.timer.last\";i:1732779881;s:17:\"session.timer.now\";i:1732779883;s:24:\"session.client.forwarded\";s:11:\"3.147.6.176\";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:\"8bce014b3765b3e8e1021dc7ed745f30\";s:12:\"url_amc_prev\";s:96:\"http://306847.minerockhongkong.tech/knowledge-center/advocacy-brief/advocacy-brief-december-2018\";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&7ca87ea869502594b1b17d5194cfd989=1\";}'
, `time` = '1732779884'
WHERE `session_id` = 'upei6e3k5ftguhrmisbv78f5e7'
37 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 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 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
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, 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* FROMv311_categories
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* FROMv311_languages
1 × SELECT id,oldurl,newurl FROM `v311_sh404sef_urls`
1 × SELECT `params` FROMv311_extensions
1 × SELECT params FROMv311_modules
1 × SELECT folder AS type, element AS name, params FROMv311_extensions
1 × SELECT* FROM `v311_osemsc_configuration
1 × SELECT* FROM `v311_osemsc_content`
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 b.id FROMv311_usergroupsAS a LEFTJOINv311_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
