ASPHO’s rich and diverse resources address key workplace and clinical issues relevant to professionals at every career stage in pediatric hematology/oncology. It’s easy to stay informed with ASPHO’s convenient webinars, conference recordings and other topical resources. Members can also access Case Quizzes and receive special savings on recordings and other resources.
Please search by title of resource, or use one of the following keywords: webinar, case, quiz, KARE, recording, survey.
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/kc-overview' 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/kc-overview?lang=en&limitstart=75' or `alias` = 'ongkong.tech/knowledge-center/kc-overview' or `alias` = 'ongkong.tech/knowledge-center/kc-overview/' order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd` FROMv311_sh404sef_urls WHERE `oldurl`='knowledge-center/kc-overview' ORDERBY `rank`;
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en&limitstart=75&view=media';
SELECT extension_id AS id, element AS "option", params, enabled
FROMv311_extensions WHERE `type` = 'component' AND `element` = 'com_hwdmediashare'
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
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
SHOWFULLCOLUMNS FROM `v311_hwdms_config`
SHOWFULLCOLUMNS FROM `v311_assets`
SELECT `id`
FROM `v311_assets`
WHERE `name` = 'com_hwdmediashare'
SELECT* FROMv311_assets WHERE `id` = '186'
SELECT* FROMv311_hwdms_config WHERE `id` = '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_hwdmediashare')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT a.id, a.key, a.ext_id, a.title, a.description, a.alias, a.checked_out, a.checked_out_time,a.created_user_id, a.thumbnail_ext_id, a.location, a.hits, a.thumbnail, a.type, a.published, a.likes, a.dislikes, a.featured,a.status, a.publish_up, a.publish_down, a.duration, a.source, a.ordering, a.created, a.access,a.language, a.modified, a.created_user_id_alias, CASEWHEN a.created_user_id_alias > ' ' THEN a.created_user_id_alias ELSE ua.username ENDAS author, CASEWHEN a.ext_id > 0 THEN ext.media_type ELSE a.media_type ENDAS media_type,ext.ext
FROMv311_hwdms_mediaAS a
LEFTJOINv311_usersAS ua ON ua.id = a.created_user_id
LEFTJOINv311_usersAS uam ON uam.id = a.modified_user_id
LEFTJOINv311_hwdms_extAS ext ON ext.id = a.ext_id
WHERE a.access IN (1,1,5) AND (a.private = 0 OR (a.private = 1 && a.created_user_id = 0)) AND a.published = 1 AND a.status = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-01 03:01:31') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-01 03:01:31')
ORDERBY a.created DESC
SELECT a.id, a.key, a.ext_id, a.title, a.description, a.alias, a.checked_out, a.checked_out_time,a.created_user_id, a.thumbnail_ext_id, a.location, a.hits, a.thumbnail, a.type, a.published, a.likes, a.dislikes, a.featured,a.status, a.publish_up, a.publish_down, a.duration, a.source, a.ordering, a.created, a.access,a.language, a.modified, a.created_user_id_alias, CASEWHEN a.created_user_id_alias > ' ' THEN a.created_user_id_alias ELSE ua.username ENDAS author, CASEWHEN a.ext_id > 0 THEN ext.media_type ELSE a.media_type ENDAS media_type,ext.ext
FROMv311_hwdms_mediaAS a
LEFTJOINv311_usersAS ua ON ua.id = a.created_user_id
LEFTJOINv311_usersAS uam ON uam.id = a.modified_user_id
LEFTJOINv311_hwdms_extAS ext ON ext.id = a.ext_id
WHERE a.access IN (1,1,5) AND (a.private = 0 OR (a.private = 1 && a.created_user_id = 0)) AND a.published = 1 AND a.status = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-01 03:01:31') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-01 03:01:31')
ORDERBY a.created DESC LIMIT 75, 15
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '109' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '107' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '104' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '101' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '97' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '94' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '93' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '92' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '88' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '72' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '71' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '70' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '69' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '68' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT c.id, c.title
FROMv311_hwdms_category_mapAS cmap
LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
WHERE `cmap`.`element_id` = '65' AND `cmap`.`element_type` = '1' AND `c`.`id` > 0 AND c.access IN (1,1,5) AND c.published = 1
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.109')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SHOWFULLCOLUMNS FROM `v311_hwdms_media`
SELECT* FROMv311_hwdms_media WHERE `id` = '109'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '109'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '109'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.107')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '107'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '107'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '107'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.104')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '104'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '104'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '104'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.101')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '101'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '101'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '101'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.97')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '97'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '97'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '97'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.94')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '94'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '94'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '94'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.93')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '93'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '93'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.92')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '92'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '92'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '92'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.88')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '88'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '88'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '88'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.72')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '72'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '72'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '72'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.71')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '71'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '71'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '71'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.70')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '70'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '70'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '70'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.69')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '69'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '69'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '69'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.68')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '68'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '68'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '68'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT b.rules
FROMv311_assetsAS a
LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_hwdmediashare.media.65')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT* FROMv311_hwdms_media WHERE `id` = '65'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key
FROMv311_hwdms_filesAS a
LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
WHERE `a`.`element_type` = '1' AND `a`.`element_id` = '65'
SELECT ext
FROMv311_hwdms_ext WHERE `id` = '32'
SELECT* FROMv311_hwdms_media WHERE `id` = '65'
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT a.media_type
FROMv311_hwdms_extAS a
WHERE `id` = 32
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en&limitstart=0&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en& limit=15&limitstart=60&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en& limit=15&limitstart=90&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en& limit=15&limitstart=90&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en& limit=15&limitstart=0&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en& limit=15&limitstart=15&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en& limit=15&limitstart=30&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en& limit=15&limitstart=45&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en& limit=15&limitstart=60&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
SELECT `oldurl`, `dateadd` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en& limit=15&limitstart=90&view=media';
SELECT `oldurl` FROMv311_sh404sef_urls WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&view=media&lang=en';
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'
SELECT m.menutype
FROMv311_menuAS m
WHERE m.id = 183
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_banners WHERE '2024-12-01 03:01:31' >= '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';
SHOWFULLCOLUMNS FROM `v311_sh404sef_metas`
SELECT* FROMv311_sh404sef_metas WHERE `newurl`='index.php?option=com_hwdmediashare&Itemid=183&lang=en&limitstart=75&view=media';
UPDATE `v311_session`
SET `data` = '__default|a:12:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1733022090;s:18:\"session.timer.last\";i:1733022090;s:17:\"session.timer.now\";i:1733022090;s:24:\"session.client.forwarded\";s:11:\"3.22.70.169\";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\":1:{s:17:\"com_hwdmediashare\";O:8:\"stdClass\":1:{s:5:\"media\";O:8:\"stdClass\":1:{s:10:\"limitstart\";s:2:\"75\";}}}}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:\"4f3b903ee777050d604d3641e4ed70ca\";s:17:\"url_joomla_logout\";s:101:\"http://stage.aspho.org/index.php?option=com_users&task=user.logout&779d3abf27f6a13a8c272fc9a5d6945e=1\";s:12:\"url_amc_prev\";s:86:\"http://306847.minerockhongkong.tech/knowledge-center/kc-overview?lang=en&limitstart=75\";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` = '1733022092'
WHERE `session_id` = 'caf07if17h3funcjtoasmcsve6'
42 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
60 × SELECT a.media_type FROMv311_hwdms_extAS a
35 × SELECT ext FROMv311_hwdms_ext
30 × SELECT* FROMv311_hwdms_media
16 × SELECT b.rules FROMv311_assetsAS a LEFTJOINv311_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
15 × SELECT c.id, c.title FROMv311_hwdms_category_mapAS cmap LEFTJOINv311_categoriesAS c ON c.id = cmap.category_id
14 × SELECT a.id, a.element_id, a.file_type, a.ext, a.size, a.checked,m.key FROMv311_hwdms_filesAS a LEFTJOINv311_hwdms_mediaAS m ON m.id = a.element_id
4 × SELECT extension_id AS id, element AS "option", params, enabled FROMv311_extensions
2 × SELECT t.parent_id FROMv311_menu 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 a.id, a.key, a.ext_id, a.title, a.description, a.alias, a.checked_out, a.checked_out_time,a.created_user_id, a.thumbnail_ext_id, a.location, a.hits, a.thumbnail, a.type, a.published, a.likes, a.dislikes, a.featured,a.status, a.publish_up, a.publish_down, a.duration, a.source, a.ordering, a.created, a.access,a.language, a.modified, a.created_user_id_alias, CASEWHEN a.created_user_id_alias > ' ' THEN a.created_user_id_alias ELSE ua.username ENDAS author, CASEWHEN a.ext_id > 0 THEN ext.media_type ELSE a.media_type ENDAS media_type,ext.ext FROMv311_hwdms_mediaAS a LEFTJOINv311_usersAS ua ON ua.id = a.created_user_id LEFTJOINv311_usersAS uam ON uam.id = a.modified_user_id LEFTJOINv311_hwdms_extAS ext ON ext.id = a.ext_id
1 × SELECT a.rules FROMv311_assetsAS a
1 × SELECT* FROMv311_hwdms_config
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* FROMv311_banners
1 × SELECT* FROMv311_assets
1 × SELECT* FROMv311_sh404sef_metas
1 × SELECT m.menutype FROMv311_menuAS m
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 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`
