-
SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
#system/ee/legacy/core/Loader.php L:1090 EE_Extensions::__construct()
-
SELECT COUNT(*) AS `numrows`
FROM (`exp_modules`)
WHERE `module_name` = 'Blacklist'
#system/ee/legacy/libraries/Blacklist.php L:70 Addons_model::module_installed()
-
SELECT `member_id`, `can_debug`, `admin_sess`, `last_activity`, `fingerprint`, `sess_start`, `login_state`
FROM (`exp_sessions`)
WHERE `session_id` = 'e8c67746e0c045bc2319f92706dbb78c078f77f0'
#system/ee/legacy/libraries/Session.php L:175 EE_Session::fetch_session_data()
-
SELECT *
FROM (`exp_members` m, `exp_member_groups` g)
WHERE `g`.`site_id` = 1
AND m.group_id = g.group_id
AND `member_id` = 32728
#system/ee/legacy/libraries/Session.php L:582 EE_Session::_do_member_query()
-
UPDATE `exp_sessions` SET `session_id` = 'e8c67746e0c045bc2319f92706dbb78c078f77f0', `fingerprint` = 'd7e48d7d1a5e0698f22ac07e3bf72eac', `member_id` = 32728, `admin_sess` = 1, `ip_address` = '172.70.43.80', `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', `last_activity` = 1696342227, `sess_start` = 1696341213, `can_debug` = 'n' WHERE session_id = 'e8c67746e0c045bc2319f92706dbb78c078f77f0'
#system/ee/legacy/libraries/Session.php L:191 EE_Session::update_session()
-
DELETE FROM `exp_sessions`
WHERE `last_activity` < 1696335027
#system/ee/legacy/libraries/Session.php L:216 EE_Session::delete_old_sessions()
-
SELECT *
FROM (`exp_security_hashes`)
WHERE `session_id` = 'e8c67746e0c045bc2319f92706dbb78c078f77f0'
#system/ee/legacy/libraries/Csrf.php L:174 Csrf_database::fetch_token()
-
SELECT Snippet_snippets.snippet_id as Snippet__snippet_id, Snippet_snippets.site_id as Snippet__site_id, Snippet_snippets.snippet_name as Snippet__snippet_name, Snippet_snippets.snippet_contents as Snippet__snippet_contents, Snippet_snippets.edit_date as Snippet__edit_date
FROM (`exp_snippets` as Snippet_snippets)
WHERE (
`Snippet_snippets`.`site_id` = 1
OR `Snippet_snippets`.`site_id` = 0
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Core.php L:370 EllisLab\ExpressionEngine\Model\Template\Snippet::loadAll()
-
SELECT Site_sites.site_id as Site__site_id, Site_sites.site_name as Site__site_name
FROM (`exp_sites` as Site_sites)
WHERE (
`Site_sites`.`site_id` = 1
)
LIMIT 1
#system/ee/EllisLab/ExpressionEngine/Model/Template/Snippet.php L:181 EllisLab\ExpressionEngine\Model\Template\Snippet::getFolderPath()
-
SELECT `route_parsed`, `template_name`, `group_name`
FROM (`exp_templates`)
JOIN `exp_template_routes` ON `exp_templates`.`template_id` = `exp_template_routes`.`template_id`
JOIN `exp_template_groups` ON `exp_templates`.`group_id` = `exp_template_groups`.`group_id`
WHERE `route_parsed` is not null
AND `exp_templates`.`site_id` = 1
ORDER BY `order`, `group_name`, `template_name` ASC
#system/ee/legacy/libraries/Template_router.php L:37 EE_Template_Router::set_routes()
-
SELECT `group_id`
FROM (`exp_template_groups`)
WHERE `group_name` = 'register'
AND `site_id` = 1
#system/ee/legacy/libraries/Template.php L:217 EE_Template::parse_template_uri()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = 'index'
AND `exp_template_groups`.`group_name` = 'register'
#system/ee/legacy/libraries/Template.php L:2240 EE_Template::fetch_template()
-
SHOW COLUMNS FROM `exp_category_field_data`
#system/ee/EllisLab/ExpressionEngine/Service/Model/MetaDataReader.php L:167 EllisLab\ExpressionEngine\Model\Content\VariableColumnGateway::getFieldList()
-
SELECT Category_categories.cat_id as Category__cat_id, Category_categories.site_id as Category__site_id, Category_categories.group_id as Category__group_id, Category_categories.parent_id as Category__parent_id, Category_categories.cat_name as Category__cat_name, Category_categories.cat_url_title as Category__cat_url_title, Category_categories.cat_description as Category__cat_description, Category_categories.cat_image as Category__cat_image, Category_categories.cat_order as Category__cat_order, Category_category_field_data.cat_id as Category__cat_id, Category_category_field_data.site_id as Category__site_id, Category_category_field_data.group_id as Category__group_id, Category_category_field_data.cat_id as Category__cat_id, Category_category_field_data.site_id as Category__site_id, Category_category_field_data.group_id as Category__group_id
FROM (`exp_categories` as Category_categories, `exp_category_field_data` as Category_category_field_data)
WHERE Category_category_field_data.cat_id = Category_categories.cat_id
AND (
`Category_categories`.`cat_url_title` IN ('register')
AND `Category_category_field_data`.`site_id` = 1
)
LIMIT 12
#system/user/addons/low_seg2cat/ext.low_seg2cat.php L:326 Low_seg2cat_ext::add_vars()
-
SELECT Plugin_plugins.plugin_id as Plugin__plugin_id, Plugin_plugins.plugin_name as Plugin__plugin_name, Plugin_plugins.plugin_package as Plugin__plugin_package, Plugin_plugins.plugin_version as Plugin__plugin_version, Plugin_plugins.is_typography_related as Plugin__is_typography_related
FROM (`exp_plugins` as Plugin_plugins)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Template.php L:1280 EE_Template::fetch_addons()
-
SELECT `module_version`, `module_name`
FROM (`exp_modules`)
#system/ee/legacy/libraries/Template.php L:1304 EE_Template::process_tags()
-
SELECT `field_id`, `field_type`, `field_fmt`, `field_name`, `site_id`, `field_settings`
FROM (`exp_channel_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:369 Api_channel_fields::fetch_custom_channel_fields()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'register'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (21) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1422) ORDER BY t.sticky desc, t.status desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT field_id, field_name FROM exp_category_fields WHERE site_id IN ('1')
#system/ee/EllisLab/Addons/channel/mod.channel.php L:294 Channel::fetch_categories()
-
SELECT c.cat_name, c.cat_url_title, c.cat_id, c.cat_image, c.cat_description, c.parent_id,
p.cat_id, p.entry_id, c.group_id , cg.field_html_formatting, fd.*
FROM (exp_categories AS c, exp_category_posts AS p)
LEFT JOIN exp_category_field_data AS fd ON fd.cat_id = c.cat_id
LEFT JOIN exp_category_groups AS cg ON cg.group_id = c.group_id
WHERE c.cat_id = p.cat_id
AND p.entry_id IN ('1422') ORDER BY c.group_id, c.parent_id, c.cat_order
#system/ee/EllisLab/Addons/channel/mod.channel.php L:294 Channel::fetch_categories()
-
SELECT *
FROM (`exp_grid_columns`)
WHERE `field_id` IN (238, 239, 240, 241, 125, 116, 117)
AND `content_type` = 'channel'
ORDER BY `col_order`
#system/ee/legacy/libraries/Grid_parser.php L:105 Grid_model::get_columns_for_field()
-
SELECT *
FROM (`exp_channel_grid_field_238`)
WHERE `entry_id` IN (1422)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_239`)
WHERE `entry_id` IN (1422)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_240`)
WHERE `entry_id` IN (1422)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_241`)
WHERE `entry_id` IN (1422)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_125`)
WHERE `entry_id` IN (1422)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_116`)
WHERE `entry_id` IN (1422)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_117`)
WHERE `entry_id` IN (1422)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_fieldtypes`)
#system/ee/legacy/libraries/api/Api_channel_fields.php L:124 EE_Addons::get_installed()
-
SELECT Plugin_plugins.plugin_id as Plugin__plugin_id, Plugin_plugins.plugin_name as Plugin__plugin_name, Plugin_plugins.plugin_package as Plugin__plugin_package, Plugin_plugins.plugin_version as Plugin__plugin_version, Plugin_plugins.is_typography_related as Plugin__is_typography_related
FROM (`exp_plugins` as Plugin_plugins)
WHERE (
`Plugin_plugins`.`is_typography_related` = 'y'
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Typography.php L:258 Addons_model::get_plugin_formatting()
-
SELECT `upload_id`
FROM (`exp_upload_no_access`)
WHERE `member_group` IS NULL
#system/ee/legacy/models/file_upload_preferences_model.php L:271 File_upload_preferences_model::get_file_upload_preferences()
-
SELECT *
FROM (`exp_upload_prefs`)
ORDER BY `name`
#system/ee/legacy/models/file_upload_preferences_model.php L:271 File_upload_preferences_model::get_file_upload_preferences()
-
SELECT `settings`
FROM (`exp_modules`)
WHERE `module_name` = 'Channel_images'
#system/user/addons/channel_images/Service/Settings.php L:25 DevDemon\ChannelImages\Service\Settings::getModuleSettings()
-
SELECT DISTINCT `L0`.`field_id` as L0_field, `L0`.`grid_field_id` as L0_grid_field_id, `L0`.`grid_col_id` as L0_grid_col_id, `L0`.`grid_row_id` as L0_grid_row_id, `L0`.`parent_id` AS L0_parent, `L0`.`child_id` as L0_id, `L0`.`order`
FROM (`exp_relationships` as L0)
LEFT JOIN `exp_relationships` as L1 ON `L0`.`child_id` = `L1`.`parent_id` OR L1.parent_id = NULL
WHERE `L0`.`grid_field_id` = 0
AND `L0`.`parent_id` IN (70, 71)
ORDER BY `L0`.`order` asc
#system/ee/legacy/models/relationship_model.php L:52 Relationship_model::_run_node_query()
-
SELECT DISTINCT `L0`.`field_id` as L0_field, `L0`.`grid_field_id` as L0_grid_field_id, `L0`.`grid_col_id` as L0_grid_col_id, `L0`.`grid_row_id` as L0_grid_row_id, `L0`.`grid_row_id` AS L0_parent, `L0`.`child_id` as L0_id, `L0`.`order`
FROM (`exp_relationships` as L0)
LEFT JOIN `exp_relationships` as L1 ON `L0`.`child_id` = `L1`.`parent_id` OR L1.parent_id = NULL
WHERE `L0`.`grid_field_id` IN (125, '0')
AND `L0`.`grid_row_id` IN (70, 71)
ORDER BY `L0`.`order` asc
#system/ee/legacy/models/relationship_model.php L:52 Relationship_model::_run_node_query()
-
SELECT DISTINCT `L0`.`field_id` as L0_field, `L0`.`grid_field_id` as L0_grid_field_id, `L0`.`grid_col_id` as L0_grid_col_id, `L0`.`grid_row_id` as L0_grid_row_id, `L0`.`grid_row_id` AS L0_parent, `L0`.`child_id` as L0_id, `L0`.`order`
FROM (`exp_relationships` as L0)
LEFT JOIN `exp_relationships` as L1 ON `L0`.`child_id` = `L1`.`parent_id` OR L1.parent_id = NULL
WHERE `L0`.`grid_field_id` IN (125, '0')
AND `L0`.`grid_row_id` IN (70, 71)
ORDER BY `L0`.`order` asc
#system/ee/legacy/models/relationship_model.php L:52 Relationship_model::_run_node_query()
-
SELECT DISTINCT `L0`.`field_id` as L0_field, `L0`.`grid_field_id` as L0_grid_field_id, `L0`.`grid_col_id` as L0_grid_col_id, `L0`.`grid_row_id` as L0_grid_row_id, `L0`.`grid_row_id` AS L0_parent, `L0`.`child_id` as L0_id, `L0`.`order`, `L1`.`grid_row_id` as L1_grid_row_id, `L1`.`field_id` as L1_field, `L1`.`parent_id` AS L1_parent, `L1`.`child_id` as L1_id, `L1`.`order`
FROM (`exp_relationships` as L0)
LEFT JOIN `exp_relationships` as L1 ON `L0`.`child_id` = `L1`.`parent_id` OR L1.parent_id = NULL
LEFT JOIN `exp_relationships` as L2 ON `L1`.`child_id` = `L2`.`parent_id` OR L2.parent_id = NULL
WHERE `L0`.`grid_field_id` IN (125, '0')
AND (
`L1`.`grid_field_id` = 0
OR `L1`.`grid_field_id` IS NULL
)
AND `L0`.`grid_row_id` IN (70, 71)
ORDER BY `L0`.`order` asc, `L0`.`order` asc, `L1`.`order` asc
#system/ee/legacy/models/relationship_model.php L:52 Relationship_model::_run_node_query()
-
SELECT c.*, cp.entry_id, cg.field_html_formatting, fd.*
FROM exp_categories AS c
LEFT JOIN exp_category_posts AS cp ON c.cat_id = cp.cat_id
LEFT JOIN exp_category_field_data AS fd ON fd.cat_id = c.cat_id
LEFT JOIN exp_category_groups AS cg ON cg.group_id = c.group_id
WHERE cp.entry_id IN (152, 153, 154, 1202, 1203, 1208, 309, 313, 308, 312)
ORDER BY c.group_id, c.parent_id, c.cat_order
#system/ee/legacy/libraries/relationship_parser/Tree_builder.php L:178 Category_model::get_entry_categories()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.group_id, m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (152,153,154,1202,1203,1208,309,313,308,312)
#system/ee/legacy/libraries/relationship_parser/Tree_builder.php L:182 Channel_entries_model::get_entry_data()
-
SELECT *
FROM (`exp_grid_columns`)
WHERE `field_id` IN (121)
AND `content_type` = 'channel'
ORDER BY `col_order`
#system/ee/legacy/libraries/Grid_parser.php L:105 Grid_model::get_columns_for_field()
-
SELECT *
FROM (`exp_channel_grid_field_121`)
WHERE `entry_id` IN (152, 153, 154)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_grid_columns`)
WHERE `field_id` IN (122)
AND `content_type` = 'channel'
ORDER BY `col_order`
#system/ee/legacy/libraries/Grid_parser.php L:105 Grid_model::get_columns_for_field()
-
SELECT *
FROM (`exp_channel_grid_field_122`)
WHERE `entry_id` IN (152, 153, 154)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_121`)
WHERE `entry_id` IN (1202, 1203, 1208, 309, 313, 308, 312)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_122`)
WHERE `entry_id` IN (1202)
ORDER BY `row_order` asc
#system/ee/EllisLab/Addons/grid/ft.grid.php L:200 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_122`)
WHERE `entry_id` IN (1203)
ORDER BY `row_order` asc
#system/ee/EllisLab/Addons/grid/ft.grid.php L:200 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_122`)
WHERE `entry_id` IN (1208)
ORDER BY `row_order` asc
#system/ee/EllisLab/Addons/grid/ft.grid.php L:200 Grid_model::get_entry_rows()
-
SELECT *
FROM (`exp_channel_grid_field_122`)
WHERE `entry_id` IN (309, 313, 308, 312)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = '_layout-main'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = '_header-scripts'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT *
FROM (`exp_seolite_config`)
WHERE `exp_seolite_config`.`site_id` = 1
#system/user/addons/seo_lite/mod.seo_lite.php L:58 Seo_lite::get_canonical_url()
-
SELECT *
FROM (`exp_seolite_config`)
WHERE `exp_seolite_config`.`site_id` = 1
#system/user/addons/seo_lite/mod.seo_lite.php L:19 Seo_lite::perform()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = 'header'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = '_nav__task-bar'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'global'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (23) AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1405) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT *
FROM (`exp_grid_columns`)
WHERE `field_id` IN (9)
AND `content_type` = 'channel'
ORDER BY `col_order`
#system/ee/legacy/libraries/Grid_parser.php L:105 Grid_model::get_columns_for_field()
-
SELECT *
FROM (`exp_channel_grid_field_9`)
WHERE `entry_id` IN (1405)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT File_files.file_id as File__file_id, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.mime_type as File__mime_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`file_name` IN ('topbar--naspa_1.png')
AND `File_files`.`upload_location_id` IN ('6')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:551 File_field::get_files_by_name()
-
SELECT `upload_id`
FROM (`exp_upload_no_access`)
WHERE `member_group` IS NULL
#system/ee/legacy/libraries/File_field.php L:738 File_upload_preferences_model::get_file_upload_preferences()
-
SELECT *
FROM (`exp_upload_prefs`)
ORDER BY `name`
#system/ee/legacy/libraries/File_field.php L:738 File_upload_preferences_model::get_file_upload_preferences()
-
SELECT FileDimension_file_dimensions.id as FileDimension__id, FileDimension_file_dimensions.site_id as FileDimension__site_id, FileDimension_file_dimensions.upload_location_id as FileDimension__upload_location_id, FileDimension_file_dimensions.title as FileDimension__title, FileDimension_file_dimensions.short_name as FileDimension__short_name, FileDimension_file_dimensions.resize_type as FileDimension__resize_type, FileDimension_file_dimensions.width as FileDimension__width, FileDimension_file_dimensions.height as FileDimension__height, FileDimension_file_dimensions.watermark_id as FileDimension__watermark_id
FROM (`exp_file_dimensions` as FileDimension_file_dimensions)
WHERE (
`FileDimension_file_dimensions`.`upload_location_id` = 6
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:655 File_field::_get_dimensions_by_dir_id()
-
SELECT File_files.file_id as File__file_id, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.mime_type as File__mime_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`file_name` IN ('Foundation_Logo_2018_Transparent_1.png')
AND `File_files`.`upload_location_id` IN ('6')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:551 File_field::get_files_by_name()
-
SELECT File_files.file_id as File__file_id, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.mime_type as File__mime_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`file_name` IN ('topbar--olc_1.png')
AND `File_files`.`upload_location_id` IN ('6')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:551 File_field::get_files_by_name()
-
SELECT File_files.file_id as File__file_id, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.mime_type as File__mime_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`file_name` IN ('topbar--vpsa_1.png')
AND `File_files`.`upload_location_id` IN ('6')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:551 File_field::get_files_by_name()
-
SELECT File_files.file_id as File__file_id, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.mime_type as File__mime_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`file_name` IN ('NASPA_FirstGen-Logo_FullColor_1.png')
AND `File_files`.`upload_location_id` IN ('6')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:551 File_field::get_files_by_name()
-
SELECT File_files.file_id as File__file_id, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.mime_type as File__mime_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`file_name` IN ('topbar--nas.png')
AND `File_files`.`upload_location_id` IN ('6')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:551 File_field::get_files_by_name()
-
SELECT File_files.file_id as File__file_id, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.mime_type as File__mime_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`file_name` IN ('topbar--tpe.png')
AND `File_files`.`upload_location_id` IN ('6')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:551 File_field::get_files_by_name()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = '_nav__mobile-drawer'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'session_formats'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (8) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1415) ORDER BY t.sticky desc, t.status desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'speakers'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT DISTINCT t.entry_id , t.sticky , t.status FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id INNER JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id
INNER JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (6) AND exp_categories.cat_id IN ('5','6') AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'schedule'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (4) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'program_subpages'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (3) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc LIMIT 0, 100
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1406,1369,1410,1411,1419,1420) ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'program'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (2) AND t.status = 'open' ORDER BY t.sticky desc, t.status desc, t.entry_date desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1393) ORDER BY t.sticky desc, t.status desc, t.entry_date desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT *
FROM (`exp_grid_columns`)
WHERE `field_id` IN (68)
AND `content_type` = 'channel'
ORDER BY `col_order`
#system/ee/legacy/libraries/Grid_parser.php L:105 Grid_model::get_columns_for_field()
-
SELECT *
FROM (`exp_channel_grid_field_68`)
WHERE `entry_id` IN (1393)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'faq'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (13) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1402) ORDER BY t.sticky desc, t.status desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'attendees_first'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (14) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'attendees_presenters'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (15) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'attendees_subpages'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (12) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc LIMIT 0, 100
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1414,1421,1423,1424) ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'about_subpages'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (19) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc LIMIT 0, 100
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1389,1179,1178,1184,1397) ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'global'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (23) AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1405) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT *
FROM (`exp_grid_columns`)
WHERE `field_id` IN (11)
AND `content_type` = 'channel'
ORDER BY `col_order`
#system/ee/legacy/libraries/Grid_parser.php L:105 Grid_model::get_columns_for_field()
-
SELECT *
FROM (`exp_channel_grid_field_11`)
WHERE `entry_id` IN (1405)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = '_nav__mobile-menu'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = '_nav__desktop-menu'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = '.conference-name'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'global'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (23) AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1405) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = 'subpage-banner'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'global'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (23) AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1405) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 47
AND `entry_id` = 1405
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:320 Channel_images_model::get_images()
-
SELECT `field_settings`
FROM (`exp_channel_fields`)
WHERE `field_id` = 47
#system/user/addons/channel_images/models/channel_images_model.php L:675 Channel_images_model::get_field_settings()
-
SELECT UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_upload_prefs` as UploadDestination_upload_prefs)
WHERE (
`UploadDestination_upload_prefs`.`id` = '6'
)
LIMIT 1
#system/user/addons/channel_images/locations/local/local.php L:121 CI_Location_local::getLocationPrefs()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = '_countdown-ticker'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = 'footer'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'global'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (23) AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1405) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT DISTINCT `L0`.`field_id` as L0_field, `L0`.`grid_field_id` as L0_grid_field_id, `L0`.`grid_col_id` as L0_grid_col_id, `L0`.`grid_row_id` as L0_grid_row_id, `L0`.`parent_id` AS L0_parent, `L0`.`child_id` as L0_id, `L0`.`order`
FROM (`exp_relationships` as L0)
LEFT JOIN `exp_relationships` as L1 ON `L0`.`child_id` = `L1`.`parent_id` OR L1.parent_id = NULL
WHERE `L0`.`grid_field_id` = 0
AND `L0`.`parent_id` IN (1405)
ORDER BY `L0`.`order` asc
#system/ee/legacy/models/relationship_model.php L:52 Relationship_model::_run_node_query()
-
SELECT c.*, cp.entry_id, cg.field_html_formatting, fd.*
FROM exp_categories AS c
LEFT JOIN exp_category_posts AS cp ON c.cat_id = cp.cat_id
LEFT JOIN exp_category_field_data AS fd ON fd.cat_id = c.cat_id
LEFT JOIN exp_category_groups AS cg ON cg.group_id = c.group_id
WHERE cp.entry_id IN (1405)
ORDER BY c.group_id, c.parent_id, c.cat_order
#system/ee/legacy/libraries/relationship_parser/Tree_builder.php L:178 Category_model::get_entry_categories()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.group_id, m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1405)
#system/ee/legacy/libraries/relationship_parser/Tree_builder.php L:182 Channel_entries_model::get_entry_data()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'session_formats'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (8) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1415) ORDER BY t.sticky desc, t.status desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'speakers'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT DISTINCT t.entry_id , t.sticky , t.status FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id INNER JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id
INNER JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (6) AND exp_categories.cat_id IN ('5','6') AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'schedule'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (4) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'program_subpages'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (3) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc LIMIT 0, 100
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1406,1369,1410,1411,1419,1420) ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'program'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (2) AND t.status = 'open' ORDER BY t.sticky desc, t.status desc, t.entry_date desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1393) ORDER BY t.sticky desc, t.status desc, t.entry_date desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'faq'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (13) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1402) ORDER BY t.sticky desc, t.status desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'attendees_first'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (14) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'attendees_presenters'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (15) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.status desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'attendees_subpages'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (12) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc LIMIT 0, 100
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1414,1421,1423,1424) ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'about_subpages'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (19) AND t.status IN ('open','draft') AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc LIMIT 0, 100
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1389,1179,1178,1184,1397) ORDER BY t.sticky desc, t.entry_date asc, t.entry_id asc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`
FROM (`exp_member_fields`)
#system/ee/EllisLab/Addons/channel/mod.channel.php L:176 Channel::fetch_custom_member_fields()
-
SELECT channel_id FROM exp_channels WHERE channel_name = 'global'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1696342227 AND (t.expiration_date = 0 OR t.expiration_date > 1696342227) AND t.channel_id IN (23) AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:260 Channel::build_sql_query()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id
LEFT JOIN exp_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (1405) ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc
#system/ee/legacy/libraries/Template.php L:1651 Channel::entries()
-
SELECT *
FROM (`exp_grid_columns`)
WHERE `field_id` IN (19)
AND `content_type` = 'channel'
ORDER BY `col_order`
#system/ee/legacy/libraries/Grid_parser.php L:105 Grid_model::get_columns_for_field()
-
SELECT *
FROM (`exp_channel_grid_field_19`)
WHERE `entry_id` IN (1405)
ORDER BY `row_order` asc
#system/ee/legacy/libraries/Grid_parser.php L:116 Grid_model::get_entry_rows()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = 1
AND `exp_templates`.`template_name` = '_footer-scripts'
AND `exp_template_groups`.`group_name` = 'includes'
#system/ee/legacy/libraries/Template.php L:216 EE_Template::fetch_template()
-
SELECT GlobalVariable_global_variables.variable_id as GlobalVariable__variable_id, GlobalVariable_global_variables.site_id as GlobalVariable__site_id, GlobalVariable_global_variables.variable_name as GlobalVariable__variable_name, GlobalVariable_global_variables.variable_data as GlobalVariable__variable_data, GlobalVariable_global_variables.edit_date as GlobalVariable__edit_date
FROM (`exp_global_variables` as GlobalVariable_global_variables)
WHERE (
`GlobalVariable_global_variables`.`site_id` = 1
OR `GlobalVariable_global_variables`.`site_id` = 0
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Template.php L:2973 EllisLab\ExpressionEngine\Model\Template\GlobalVariable::loadAll()
-
SELECT action_id, class, method FROM exp_actions WHERE (class= 'Search' AND method = 'do_search')
#system/ee/legacy/libraries/Template.php L:3187 EE_Functions::insert_action_ids()