The mission of the cancer predisposition SIG is to promote the identification, management and surveillance of children with inherited cancer predisposition syndromes (ICPS), as well as develop research and provide education to members of the ASPHO community.
Goals
1. Increase awareness and provide tools to assist in the identification, work-up and referral of children with cancer or family history of cancer for a cancer predisposition evaluation 2. Provide management strategies and best practice discussion for children identified as having an inherited cancer predisposition syndrome. Provide an opportunity to discuss different surveillance modalities and intervals. 3. Provide a platform for research collaboration for those interested in multi-institutional collaborations regarding rare ICPS.
Leadership
This email address is being protected from spambots. You need JavaScript enabled to view it.
, MD, Past Chair University of Pittsburgh School of Medicine
This email address is being protected from spambots. You need JavaScript enabled to view it.
, MD FAAP, FACMG, Chair Cleveland Clinic
This email address is being protected from spambots. You need JavaScript enabled to view it.
, MD MS, Vice Chair Medical College of Wisconsin
Communication Tool
A discussion group in the ASPHO member community has been designated for members of the SIG to share information, documents, links and files. Members can join the SIG from their My Account Special Interest Groups account page. Current SIG members can access the community directly to participate.
SELECT `data`
FROM `v311_session`
WHERE `session_id` = 'n39j0mblo108c5046nthi0ue12'
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/membership/special-interest-groups/cancer-predisposition' 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/membership/special-interest-groups/cancer-predisposition' or `alias` = 'ongkong.tech/membership/special-interest-groups/cancer-predisposition' or `alias` = 'ongkong.tech/membership/special-interest-groups/cancer-predisposition/' order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd` FROMv311_sh404sef_urls WHERE `oldurl`='membership/special-interest-groups/cancer-predisposition' 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 = 657 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-01 01:11:02') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-01 01:11:02') 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=31 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` = 657 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.657')
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 = 31 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 01:11:02') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-01 01:11:02')
ORDERBY a.created DESC
UPDATEv311_content SET hits = hits + 1 WHERE id = 657
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` = '657'
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 31
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 15
SELECT t.parent_id
FROMv311_categories as t
WHERE t.id = 1
SELECT m.menutype
FROMv311_menuAS m
WHERE m.id = 928
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 928
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 275
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 184
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 1
SELECT* FROMv311_content WHERE `id` = '657'
SELECT* FROMv311_content WHERE `id` = '657'
SELECT* FROMv311_content WHERE `id` = '657'
SELECT* FROMv311_content WHERE `id` = '657'
SELECT* FROMv311_content WHERE `id` = '657'
SELECT* FROMv311_content WHERE `id` = '657'
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_jdonation&Itemid=386&campaign_id=1&lang=en&view=donation';
SELECT* FROMv311_banners WHERE '2024-12-01 01:11:02' >= '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`=657;
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=31 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=928&id=657&lang=en&view=article';
UPDATE `v311_session`
SET `data` = '__default|a:12:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1733015458;s:18:\"session.timer.last\";i:1733015460;s:17:\"session.timer.now\";i:1733015462;s:24:\"session.client.forwarded\";s:10:\"3.147.62.5\";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:\"65f108df27dbe810c19f2f34f8a7cc70\";s:12:\"url_amc_prev\";s:92:\"http://306847.minerockhongkong.tech/membership/special-interest-groups/cancer-predisposition\";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&df9da17992c24cef3fe594d6f012449e=1\";}'
, `time` = '1733015463'
WHERE `session_id` = 'n39j0mblo108c5046nthi0ue12'
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
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.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* FROMv311_categories
1 × SELECT* FROMv311_sh404sef_metas
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