| 0.0003 |
SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = 'ebac75242f00055a6f37e3843659a5e8'
AND `user_agent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
|
| 0.0001 |
select * from site_settings
|
| 0.0001 |
select tmp_name, site_id, site_name,parent,site_analytics_code,site_analytics_domain,site_domain,site_analytics_code_ga4 from cms_sites s JOIN cms_template t ON s.site_template=t.tmp_id where tmp_status=1 AND site_active=1 AND site_domain = 'https://www.medicareplusdev.molehost6.net/'
|
| 0.0001 |
select * from sso_sites where id='1'
|
| 0.0001 |
select * from lang_phrases where site_id = '1' AND status = '1'
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1' AND site_setting_name = 'sso_enabled'
|
| 0.0001 |
select * from site_settings where set_key='site_maintenance'
|
| 0.0001 |
select * from installation where ini_status=1 and ini_controller!=''
|
| 0.0002 |
UPDATE `ci_sessions` SET `last_activity` = 1765045349, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:98:\"https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services\";s:5:\"redir\";s:112:\"https://www.medicareplusdev.molehost6.net/resources/details/medi-derma-s-barrier-cream-product-information-sheet\";s:22:\"resource_reading_redir\";s:112:\"https://www.medicareplusdev.molehost6.net/resources/details/medi-derma-s-barrier-cream-product-information-sheet\";}' WHERE `session_id` = 'ebac75242f00055a6f37e3843659a5e8'
|
| 0.0001 |
UPDATE `ci_sessions` SET `last_activity` = 1765045349, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:98:\"https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services\";s:5:\"redir\";s:98:\"https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services\";s:22:\"resource_reading_redir\";s:112:\"https://www.medicareplusdev.molehost6.net/resources/details/medi-derma-s-barrier-cream-product-information-sheet\";}' WHERE `session_id` = 'ebac75242f00055a6f37e3843659a5e8'
|
| 0.0001 |
select count(distinct(r.res_id) ) as total from resources r
LEFT JOIN resource_content_types ct ON ct.res_cont_type_id = r.cont_type_id
LEFT JOIN resources_lang rl ON rl.res_lang_id = r.res_lang_id
LEFT JOIN organisation o ON o.org_id = r.res_org_id AND r.res_show_org = 1 where r.res_status = 1 AND r.res_active = 1 AND r.res_site_id = '1'
|
| 0.0002 |
select
distinct(r.res_id),
r.res_site_id,
r.res_details_url,
r.res_title,
r.res_date,
r.res_date_expiry,
r.res_expiry_date_email,
r.res_expiry_four_wk_email_sent,
r.res_expiry_today_email_sent,
r.res_short_desc,
r.res_long_desc,
r.res_file,
r.res_url,
r.res_image,
r.cont_type_id,
r.res_location_id,
r.res_access,
r.res_add_to_reading_list,
r.res_price,
ct.res_cont_type_class,
ct.res_cont_type_name,
ct.res_cont_type_identifier,
rl.res_lang_name,
o.org_name,
r.topic_id
from resources r
LEFT JOIN resource_content_types ct ON ct.res_cont_type_id = r.cont_type_id
LEFT JOIN resources_lang rl ON rl.res_lang_id = r.res_lang_id
LEFT JOIN organisation o ON o.org_id = r.res_org_id AND r.res_show_org = 1 where r.res_status = 1 AND r.res_active = 1 AND r.res_site_id = '1' order by r.res_date asc LIMIT 0, 12
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 1 AND rt.status = 1
|
| 0.0001 |
select topic_id,topic_title from topic t where topic_id = '25' AND topic_status = 1 AND topic_active = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 2 AND rt.status = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 6 AND rt.status = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 5 AND rt.status = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 16 AND rt.status = 1
|
| 0.0001 |
select topic_id,topic_title from topic t where topic_id = '80' AND topic_status = 1 AND topic_active = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 18 AND rt.status = 1
|
| 0.0001 |
select topic_id,topic_title from topic t where topic_id = '80' AND topic_status = 1 AND topic_active = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 19 AND rt.status = 1
|
| 0.0001 |
select topic_id,topic_title from topic t where topic_id = '80' AND topic_status = 1 AND topic_active = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 20 AND rt.status = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 21 AND rt.status = 1
|
| 0.0001 |
select topic_id,topic_title from topic t where topic_id = '82' AND topic_status = 1 AND topic_active = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 22 AND rt.status = 1
|
| 0.0001 |
select topic_id,topic_title from topic t where topic_id = '80' AND topic_status = 1 AND topic_active = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 23 AND rt.status = 1
|
| 0.0001 |
select topic_id,topic_title from topic t where topic_id = '80' AND topic_status = 1 AND topic_active = 1
|
| 0.0001 |
select t.topic_id, t.topic_title from resource_topics rt LEFT JOIN topic t ON t.topic_id = rt.topic_id where rt.res_id = 24 AND rt.status = 1
|
| 0.0001 |
select * from sys_site_settings where (
site_setting_name = 'meta_title_resource_listing'
OR
site_setting_name = 'meta_description_resource_listing'
)
and site_id = '1'
and status = 1
order by site_setting_id ASC
|
| 0.0001 |
select * from resource_content_types where res_cont_type_site_id = '1' AND res_cont_type_active = 1 AND res_cont_type_status = 1 ORDER BY res_cont_type_name ASC
|
| 0.0001 |
select
ts.topic_id,t.topic_title,t.topic_is_key_topic from
topic_sites ts
LEFT JOIN topic t ON ts.topic_id = t.topic_id where
ts.site_id = '1' AND
ts.topic_site_status = 1 AND
ts.topic_site_active = 1 AND
t.topic_status = 1 AND
t.topic_active = 1 AND t.topic_parent_id = '41' GROUP BY t.topic_title ORDER BY t.topic_title ASC
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '106' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '42' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '76' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '75' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '78' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '79' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '93' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '105' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '80' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '110' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '101' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '77' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select
ts.topic_id,t.topic_title,t.topic_is_key_topic from
topic_sites ts
LEFT JOIN topic t ON ts.topic_id = t.topic_id where
ts.site_id = '1' AND
ts.topic_site_status = 1 AND
ts.topic_site_active = 1 AND
t.topic_status = 1 AND
t.topic_active = 1 AND t.topic_parent_id IN (65,107) GROUP BY t.topic_title ORDER BY t.topic_title ASC
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '67' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0000 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '68' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '66' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '108' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select rt.resource_topic_id from resource_topics rt
LEFT JOIN resources r ON rt.res_id = r.res_id where
rt.topic_id = '109' AND
rt.`status` = 1 AND
r.res_active = 1 AND
r.res_status = 1
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1' AND site_setting_name = 'meta_no_follow'
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1' AND site_setting_name = 'og_image'
|
| 0.0001 |
select core_file_path,min_file_path from sys_minify_files where `status` = 1
|
| 0.0001 |
select site_analytics_code_ga4 from cms_sites where site_id = '1'
|
| 0.0002 |
UPDATE `ci_sessions` SET `last_activity` = 1765045349, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:98:\"https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services\";s:5:\"redir\";s:98:\"https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services\";s:22:\"resource_reading_redir\";s:112:\"https://www.medicareplusdev.molehost6.net/resources/details/medi-derma-s-barrier-cream-product-information-sheet\";}' WHERE `session_id` = 'ebac75242f00055a6f37e3843659a5e8'
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1'
|
| 0.0002 |
select
ca.cmp_ad_id,
ca.cmp_ad_cmp_id,
ca.cmp_ad_fmat_id,
ca.cmp_ad_fmat_external,
ca.cmp_ad_bnr_size_id,
ca.cmp_ad_primary_file,
ca.cmp_ad_secondary_fmat_id,
ca.cmp_ad_secondary_file,
ca.cmp_ad_mobile_fmat_id,
ca.cmp_ad_bnr_mobile_size_id,
ca.cmp_ad_mobile_file,
ca.cmp_ad_dsp_id,
ca.cmp_ad_weighting,
ca.cmp_ad_repeat_display,
ca.cmp_ad_cross_ad_show_only_cmp,
ca.cmp_ad_cross_ad_show_other_cmp,
ca.cmp_hcp_disabled,
ca.cmp_ad_uprof_login_req,
ca.cmp_ad_uprof_login_not_req,
ca.cmp_ad_url,
ca.cmp_ad_fmat_external,
ca.cmp_ad_fmat_mobile_external,
f.fmat_id,
bs.bnr_id,
c.cmp_org_id from
ad_campaign_advert ca
LEFT JOIN ad_campaign c ON ca.cmp_ad_cmp_id = c.cmp_id
LEFT JOIN ad_banner_size bs ON ca.cmp_ad_bnr_size_id = bs.bnr_id
LEFT JOIN ad_format f ON ca.cmp_ad_fmat_id = f.fmat_id where ca.cmp_ad_status = 1 AND ca.cmp_ad_active = 1 AND c.cmp_status = 1 AND c.cmp_active = 1 AND c.site_id = '1' AND bs.bnr_status = 1 AND bs.bnr_active = 1 AND f.fmat_status = 1 AND f.fmat_active = 1 AND bs.bnr_id = '2' AND ca.cmp_ad_dsp_id = 2 AND (ca.cmp_ad_start_date <= '2025-12-06' AND ca.cmp_ad_end_date >= '2025-12-06') AND (c.cmp_start_date <= '2025-12-06' AND c.cmp_end_date >= '2025-12-06')
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1' AND site_setting_name = 'sso_enabled'
|
| 0.0001 |
select * from cms_menu where cmn_name='wct_main_menu'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='0' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '203'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='389' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='390' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '206'
|
| 0.0001 |
select * from cms_pages where page_id = '207'
|
| 0.0001 |
select * from cms_pages where page_id = '230'
|
| 0.0001 |
select * from cms_menu where cmn_name='wct_main_menu'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='0' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '203'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='389' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='1' and cmi_parent='390' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '206'
|
| 0.0001 |
select * from cms_pages where page_id = '207'
|
| 0.0001 |
select * from cms_pages where page_id = '230'
|
| 0.0001 |
select * from cms_menu where cmn_name='wct_footer_menu_2'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='6' and cmi_parent='0' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = ''
|
| 0.0001 |
UPDATE `ci_sessions` SET `last_activity` = 1765045349, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:98:\"https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services\";s:5:\"redir\";s:98:\"https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services\";s:22:\"resource_reading_redir\";s:112:\"https://www.medicareplusdev.molehost6.net/resources/details/medi-derma-s-barrier-cream-product-information-sheet\";}' WHERE `session_id` = 'ebac75242f00055a6f37e3843659a5e8'
|
| 0.0001 |
UPDATE `ci_sessions` SET `last_activity` = 1765045349, `user_data` = 'a:4:{s:9:\"user_data\";s:0:\"\";s:14:\"register_redir\";s:98:\"https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services\";s:5:\"redir\";s:98:\"https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services\";s:22:\"resource_reading_redir\";s:112:\"https://www.medicareplusdev.molehost6.net/resources/details/medi-derma-s-barrier-cream-product-information-sheet\";}' WHERE `session_id` = 'ebac75242f00055a6f37e3843659a5e8'
|
| 0.0001 |
select site_setting_name,site_setting_value from sys_site_settings where status = 1 AND site_id = '1'
|
| 0.0001 |
select
ca.cmp_ad_id,
ca.cmp_ad_cmp_id,
ca.cmp_ad_fmat_id,
ca.cmp_ad_fmat_external,
ca.cmp_ad_bnr_size_id,
ca.cmp_ad_primary_file,
ca.cmp_ad_secondary_fmat_id,
ca.cmp_ad_secondary_file,
ca.cmp_ad_mobile_fmat_id,
ca.cmp_ad_bnr_mobile_size_id,
ca.cmp_ad_mobile_file,
ca.cmp_ad_dsp_id,
ca.cmp_ad_weighting,
ca.cmp_ad_repeat_display,
ca.cmp_ad_cross_ad_show_only_cmp,
ca.cmp_ad_cross_ad_show_other_cmp,
ca.cmp_hcp_disabled,
ca.cmp_ad_uprof_login_req,
ca.cmp_ad_uprof_login_not_req,
ca.cmp_ad_url,
ca.cmp_ad_fmat_external,
ca.cmp_ad_fmat_mobile_external,
f.fmat_id,
bs.bnr_id,
c.cmp_org_id from
ad_campaign_advert ca
LEFT JOIN ad_campaign c ON ca.cmp_ad_cmp_id = c.cmp_id
LEFT JOIN ad_banner_size bs ON ca.cmp_ad_bnr_size_id = bs.bnr_id
LEFT JOIN ad_format f ON ca.cmp_ad_fmat_id = f.fmat_id where ca.cmp_ad_status = 1 AND ca.cmp_ad_active = 1 AND c.cmp_status = 1 AND c.cmp_active = 1 AND c.site_id = '1' AND bs.bnr_status = 1 AND bs.bnr_active = 1 AND f.fmat_status = 1 AND f.fmat_active = 1 AND bs.bnr_id = '1' AND ca.cmp_ad_dsp_id = 2 AND (ca.cmp_ad_start_date <= '2025-12-06' AND ca.cmp_ad_end_date >= '2025-12-06') AND (c.cmp_start_date <= '2025-12-06' AND c.cmp_end_date >= '2025-12-06')
|
| 0.0001 |
select wt.widget_type_handler from widgets_type wt INNER JOIN widgets w on w.widget_type_id=wt.widget_type_id where w.widget_id=374 AND w.widget_active=1 AND w.widget_status=1
|
| 0.0001 |
select * from widgets where widget_id=374
|
| 0.0001 |
select * from cms_menu where cmn_name='footer_menu'
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='2' and cmi_parent='0' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = ''
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='2' and cmi_parent='406' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '1'
|
| 0.0001 |
select * from cms_pages where page_id = '203'
|
| 0.0001 |
select * from cms_pages where page_id = '206'
|
| 0.0001 |
select * from cms_pages where page_id = '224'
|
| 0.0001 |
select * from cms_pages where page_id = ''
|
| 0.0001 |
select MI.cmi_id,cmi_title,cmi_url,cmi_type,cmi_parent,cmi_new_window,cmi_style_class,C.page_url,C.page_id,CS.cms_sec_url,MI.cmi_sub_nav_display,MI.cmi_sub_nav_display_widget_id,(Select count(CMI.cmi_id) from cms_menu_items CMI where CMI.cmi_parent=MI.cmi_id and CMI.cmi_active=1 and CMI.cmi_status=1) as total_sub from cms_menu_items MI left join cms_pages C on MI.cmi_page=C.page_id and page_status=1 Left Join cms_sections CS on C.cms_sec_id=CS.cms_sec_id where cmn_id='2' and cmi_parent='407' and cmi_active=1 and cmi_status=1 order by cmi_order
|
| 0.0001 |
select * from cms_pages where page_id = '230'
|
| 0.0001 |
select * from cms_pages where page_id = '54'
|
| 0.0001 |
select * from cms_pages where page_id = '205'
|
| 0.0001 |
select * from cms_pages where page_id = '178'
|
| 0.0001 |
select * from cms_pages where page_id = '204'
|
| 0.0002 |
INSERT INTO `logs_cms_pages` (`page_id`, `log_page_title`, `log_page_url`, `ses_db_id`) VALUES ('0', 'Resources', 'https://www.medicareplusdev.molehost6.net/resources/all/0/date/asc/topic/Clinical+Support+Services', 0)
|
Contact Us
My Account
.jpg)
.jpg)
-With-A-Total-Barrier-Protection-Strategy.jpg)
Success!