ASPHO's Diversity Advisory Group supports the Society's commitment to ensuring a welcoming and inclusive experience for members and promoting equitable healthcare access for all pediatric hematology/oncology patients. Diversity, equity, and inclusion are infused into the Society through its leadership development, Diversity Statement, the volunteer Diversity Advisory Group, Points of Diversity representation guidelines, and the member-managed Diversity, Equity and Inclusion Special Interest Group. Read Diversity Advisory Group member reflections about their experiences with diversity, equity, and inclusion (DEI) in the subspecialty.
Nitya Bakshi, MBBS MS, Emory University, Children's Healthcare of Atlanta
"I am an Associate Professor of Pediatrics at Emory University and a pediatric hematologist with a focus in sickle cell disease and chronic pain at Childrens Healthcare of Atlanta. I joined the Diversity Advisory Group in 2022 as diversity, equity and inclusion are important to be able to serve our patients, and we must address barriers to professional success and career advancement faced by trainees and junior faculty, particularly women and those who are under-represented in medicine and biomedical research. I am excited to contribute to the outstanding work done by this group to promote diversity at ASPHO through increased awareness, education, and engagement amongst pediatric hematologists-oncologists."
Kenneth S. Chen, MD, UT Southwestern Medical Center
"As a physician scientist, my goal is to improve the care of children with cancer using data. With regards to DEI, the data suggest that we still have room to improve before the demographics of our field reflect the demographics of our patients. I serve on the Diversity Advisory Group to encourage ASPHO to continue gathering data on and addressing the barriers to diversity within the field of pediatric hematology and oncology."
Kalindi Yajnik Narine, MD, Texas Children's Hospital West Campus/Baylor College of Medicine
"Diversity, equity, and inclusion are important in society as well as in ASPHO. They give different perspectives and encourages original thinking, helping us to understand our colleagues and our patients better. Pediatric hematology and oncology have diverse patient populations. DEI discussions and education will help us to understand and give better care to all our patients."
"I am a pediatric hematologist at Phoenix Children’s Hospital and clinical associate professor at the University of Arizona College of Medicine in Phoenix. My life experiences and career path have taught me the importance of diversity and tolerance in our society. Diversity enriches our lives, spurs innovation, encourages engagement, improves tolerance, and reduces discrimination. I joined the Diversity Advisory Group in 2018, and through our group’s efforts and ASPHO as a larger organization, I hope to continue to engage our community in promoting effective strategies for a diverse, equitable workforce, which should hopefully lead to a better understanding of each other and greater satisfaction in our practice as a whole."
Sharon Singh, MD, C.S. Mott Children’s Hospital
"My career has been focused on caring for the vulnerable patients in my sickle clinic at University of Michigan and mentoring trainees of diverse backgrounds. Diversity in hematology/oncology is important as it leads to improved care for the patients in our community. Building a diverse and inclusive community of physicians, scientists and trainees that is free of discrimination and allows people of all backgrounds to flourish is a critical goal and important work that I would like to be involved in as a member of ASPHO's Diversity Advisory Group."
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/diversity-advisory- group-members' AND rank = 0;
SELECT* FROM `v311_osemsc_configuration`
SELECT* FROM `v311_osemsc_content` WHERE (type = 'joomla') AND (content_type = 'menu') AND (status = '1')
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROMv311_menuAS m
LEFTJOINv311_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
select `alias`,`newurl` from `v311_sh404sef_aliases` where `alias` = 'http://306847.minerockhongkong.tech/about/diversity-advisory- group-members' or `alias` = 'ongkong.tech/about/diversity-advisory- group-members' or `alias` = 'ongkong.tech/about/diversity-advisory- group-members/' order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd` FROMv311_sh404sef_urls WHERE `oldurl`='about/diversity-advisory- group-members' ORDERBY `rank`;
SELECT extension_id AS id, element AS "option", params, enabled
FROMv311_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT id, home, template, s.params
FROMv311_template_styles as s
LEFTJOINv311_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
WHERE s.client_id = 0 AND e.enabled = 1
SELECT 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 = 852 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-01 00:16:04') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-01 00:16:04') 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` = 852 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.852')
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:16:04') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-01 00:16:04')
ORDERBY a.created DESC
UPDATEv311_content SET hits = hits + 1 WHERE id = 852
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` = '852'
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 = 1125
SELECT t.parent_id
FROMv311_menu as t
WHERE t.id = 1125
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` = '852'
SELECT* FROMv311_content WHERE `id` = '852'
SELECT* FROMv311_content WHERE `id` = '852'
SELECT* FROMv311_content WHERE `id` = '852'
SELECT* FROMv311_content WHERE `id` = '852'
SELECT* FROMv311_content WHERE `id` = '852'
SELECT* FROMv311_banners WHERE '2024-12-01 00:16:04' >= '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`=852;
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=1125&id=852&lang=en&view=article';
UPDATE `v311_session`
SET `data` = '__default|a:12:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1733012164;s:18:\"session.timer.last\";i:1733012164;s:17:\"session.timer.now\";i:1733012164;s:24:\"session.client.forwarded\";s:12:\"18.118.37.85\";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:\"ca3e9da496796b963aa6d2b54297774f\";s:17:\"url_joomla_logout\";s:101:\"http://stage.aspho.org/index.php?option=com_users&task=user.logout&21c2337235b78e4246a1b6efb69a097e=1\";s:12:\"url_amc_prev\";s:74:\"http://306847.minerockhongkong.tech/about/diversity-advisory- group-members\";s:8:\"oseClass\";a:9:{s:8:\"registry\";s:11:\"oseregistry\";s:3:\"msc\";s:10:\"membership\";s:4:\"user\";s:4:\"user\";s:6:\"member\";s:6:\"member\";s:7:\"payment\";s:7:\"payment\";s:6:\"remote\";s:6:\"remote\";s:3:\"lic\";s:7:\"license\";s:7:\"content\";s:7:\"content\";s:5:\"debug\";s:5:\"debug\";}}'
, `time` = '1733012165'
WHERE `session_id` = 'r7ksvd4moscjdicuqn7u91tub6'
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
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
