-
SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
#system/ee/legacy/core/Loader.php L:944 EE_Extensions::__construct()
-
SELECT COUNT(*) AS `numrows`
FROM (`exp_modules`)
WHERE `module_name` = 'Block_and_allow'
#system/ee/legacy/libraries/Blockedlist.php L:71 Addons_model::module_installed()
-
SELECT *
FROM (`exp_remember_me`)
WHERE `remember_me_id` = 'c3939d63a94278d051c463d231756c6055215a50'
#system/ee/legacy/libraries/Remember.php L:97 Remember::_validate_db()
-
SELECT Session_sessions.session_id as Session__session_id, Session_sessions.member_id as Session__member_id, Session_sessions.admin_sess as Session__admin_sess, Session_sessions.ip_address as Session__ip_address, Session_sessions.user_agent as Session__user_agent, Session_sessions.login_state as Session__login_state, Session_sessions.fingerprint as Session__fingerprint, Session_sessions.sess_start as Session__sess_start, Session_sessions.auth_timeout as Session__auth_timeout, Session_sessions.last_activity as Session__last_activity, Session_sessions.can_debug as Session__can_debug, Session_sessions.mfa_flag as Session__mfa_flag, Session_sessions.pro_banner_seen as Session__pro_banner_seen
FROM (`exp_sessions` as Session_sessions)
WHERE (
`Session_sessions`.`session_id` = 'da9ffed5cd7edfad903828db6978b24652ac100d'
)
LIMIT 1
#system/ee/legacy/libraries/Session.php L:179 EE_Session::fetch_session_data()
-
SELECT *
FROM (`exp_members` m, `exp_role_settings` g)
WHERE `g`.`site_id` = 1
AND m.role_id = g.role_id
AND `member_id` = 1
#system/ee/legacy/libraries/Session.php L:591 EE_Session::_do_member_query()
-
SELECT COUNT(*) AS `numrows`
FROM (`exp_member_fields` as MemberField_member_fields)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Service/Model/Query/Select.php L:100 ExpressionEngine\Library\Data\Entity::getMetaData()
-
SELECT Member_members.member_id as Member__member_id, Member_members.role_id as Member__role_id, Member_members.pending_role_id as Member__pending_role_id, Member_members.username as Member__username, Member_members.screen_name as Member__screen_name, Member_members.password as Member__password, Member_members.salt as Member__salt, Member_members.unique_id as Member__unique_id, Member_members.crypt_key as Member__crypt_key, Member_members.backup_mfa_code as Member__backup_mfa_code, Member_members.authcode as Member__authcode, Member_members.email as Member__email, Member_members.signature as Member__signature, Member_members.avatar_filename as Member__avatar_filename, Member_members.avatar_width as Member__avatar_width, Member_members.avatar_height as Member__avatar_height, Member_members.photo_filename as Member__photo_filename, Member_members.photo_width as Member__photo_width, Member_members.photo_height as Member__photo_height, Member_members.sig_img_filename as Member__sig_img_filename, Member_members.sig_img_width as Member__sig_img_width, Member_members.sig_img_height as Member__sig_img_height, Member_members.ignore_list as Member__ignore_list, Member_members.private_messages as Member__private_messages, Member_members.accept_messages as Member__accept_messages, Member_members.last_view_bulletins as Member__last_view_bulletins, Member_members.last_bulletin_date as Member__last_bulletin_date, Member_members.ip_address as Member__ip_address, Member_members.join_date as Member__join_date, Member_members.last_visit as Member__last_visit, Member_members.last_activity as Member__last_activity, Member_members.total_entries as Member__total_entries, Member_members.total_comments as Member__total_comments, Member_members.total_forum_topics as Member__total_forum_topics, Member_members.total_forum_posts as Member__total_forum_posts, Member_members.last_entry_date as Member__last_entry_date, Member_members.last_comment_date as Member__last_comment_date, Member_members.last_forum_post_date as Member__last_forum_post_date, Member_members.last_email_date as Member__last_email_date, Member_members.in_authorlist as Member__in_authorlist, Member_members.accept_admin_email as Member__accept_admin_email, Member_members.accept_user_email as Member__accept_user_email, Member_members.notify_by_default as Member__notify_by_default, Member_members.notify_of_pm as Member__notify_of_pm, Member_members.display_signatures as Member__display_signatures, Member_members.parse_smileys as Member__parse_smileys, Member_members.smart_notifications as Member__smart_notifications, Member_members.language as Member__language, Member_members.timezone as Member__timezone, Member_members.time_format as Member__time_format, Member_members.date_format as Member__date_format, Member_members.week_start as Member__week_start, Member_members.include_seconds as Member__include_seconds, Member_members.profile_theme as Member__profile_theme, Member_members.forum_theme as Member__forum_theme, Member_members.tracker as Member__tracker, Member_members.template_size as Member__template_size, Member_members.notepad as Member__notepad, Member_members.notepad_size as Member__notepad_size, Member_members.bookmarklets as Member__bookmarklets, Member_members.quick_links as Member__quick_links, Member_members.quick_tabs as Member__quick_tabs, Member_members.show_sidebar as Member__show_sidebar, Member_members.pmember_id as Member__pmember_id, Member_members.cp_homepage as Member__cp_homepage, Member_members.cp_homepage_channel as Member__cp_homepage_channel, Member_members.cp_homepage_custom as Member__cp_homepage_custom, Member_members.dismissed_banner as Member__dismissed_banner, Member_members.enable_mfa as Member__enable_mfa, PrimaryRole_roles.role_id as PrimaryRole__role_id, PrimaryRole_roles.name as PrimaryRole__name, PrimaryRole_roles.short_name as PrimaryRole__short_name, PrimaryRole_roles.description as PrimaryRole__description, PrimaryRole_roles.highlight as PrimaryRole__highlight, PrimaryRole_roles.total_members as PrimaryRole__total_members, PrimaryRole_roles.is_locked as PrimaryRole__is_locked, RoleSettings_role_settings.id as RoleSettings__id, RoleSettings_role_settings.role_id as RoleSettings__role_id, RoleSettings_role_settings.site_id as RoleSettings__site_id, RoleSettings_role_settings.menu_set_id as RoleSettings__menu_set_id, RoleSettings_role_settings.mbr_delete_notify_emails as RoleSettings__mbr_delete_notify_emails, RoleSettings_role_settings.exclude_from_moderation as RoleSettings__exclude_from_moderation, RoleSettings_role_settings.search_flood_control as RoleSettings__search_flood_control, RoleSettings_role_settings.prv_msg_send_limit as RoleSettings__prv_msg_send_limit, RoleSettings_role_settings.prv_msg_storage_limit as RoleSettings__prv_msg_storage_limit, RoleSettings_role_settings.include_in_authorlist as RoleSettings__include_in_authorlist, RoleSettings_role_settings.include_in_memberlist as RoleSettings__include_in_memberlist, RoleSettings_role_settings.cp_homepage as RoleSettings__cp_homepage, RoleSettings_role_settings.cp_homepage_channel as RoleSettings__cp_homepage_channel, RoleSettings_role_settings.cp_homepage_custom as RoleSettings__cp_homepage_custom, RoleSettings_role_settings.require_mfa as RoleSettings__require_mfa, RoleSettings_role_settings.show_field_names as RoleSettings__show_field_names, Roles_roles.role_id as Roles__role_id, Roles_roles.name as Roles__name, Roles_roles.short_name as Roles__short_name, Roles_roles.description as Roles__description, Roles_roles.highlight as Roles__highlight, Roles_roles.total_members as Roles__total_members, Roles_roles.is_locked as Roles__is_locked, RoleGroups_role_groups.group_id as RoleGroups__group_id, RoleGroups_role_groups.name as RoleGroups__name
FROM (`exp_members` as Member_members)
LEFT JOIN `exp_member_data` as Member_member_data ON `Member_member_data`.`member_id` = `Member_members`.`member_id`
LEFT JOIN `exp_roles` AS PrimaryRole_roles ON `PrimaryRole_roles`.`role_id` = `Member_members`.`role_id`
LEFT JOIN `exp_role_settings` AS RoleSettings_role_settings ON `RoleSettings_role_settings`.`role_id` = `PrimaryRole_roles`.`role_id`
LEFT JOIN `exp_members_roles` as Member_Roles_members_roles ON `Member_Roles_members_roles`.`member_id` = `Member_members`.`member_id`
LEFT JOIN `exp_roles` as Roles_roles ON `Roles_roles`.`role_id` = `Member_Roles_members_roles`.`role_id`
LEFT JOIN `exp_members_role_groups` as Member_RoleGroups_members_role_groups ON `Member_RoleGroups_members_role_groups`.`member_id` = `Member_members`.`member_id`
LEFT JOIN `exp_role_groups` as RoleGroups_role_groups ON `RoleGroups_role_groups`.`group_id` = `Member_RoleGroups_members_role_groups`.`group_id`
WHERE (
`Member_members`.`member_id` = 1
AND `RoleSettings_role_settings`.`site_id` = 1
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Session.php L:1210 EE_Session::_setupMemberModel()
-
SELECT MemberField_member_fields.m_field_id as MemberField__m_field_id, MemberField_member_fields.m_field_name as MemberField__m_field_name, MemberField_member_fields.m_field_label as MemberField__m_field_label, MemberField_member_fields.m_field_description as MemberField__m_field_description, MemberField_member_fields.m_field_type as MemberField__m_field_type, MemberField_member_fields.m_field_list_items as MemberField__m_field_list_items, MemberField_member_fields.m_field_ta_rows as MemberField__m_field_ta_rows, MemberField_member_fields.m_field_maxl as MemberField__m_field_maxl, MemberField_member_fields.m_field_width as MemberField__m_field_width, MemberField_member_fields.m_field_search as MemberField__m_field_search, MemberField_member_fields.m_field_required as MemberField__m_field_required, MemberField_member_fields.m_field_public as MemberField__m_field_public, MemberField_member_fields.m_field_reg as MemberField__m_field_reg, MemberField_member_fields.m_field_cp_reg as MemberField__m_field_cp_reg, MemberField_member_fields.m_field_fmt as MemberField__m_field_fmt, MemberField_member_fields.m_field_show_fmt as MemberField__m_field_show_fmt, MemberField_member_fields.m_field_exclude_from_anon as MemberField__m_field_exclude_from_anon, MemberField_member_fields.m_field_order as MemberField__m_field_order, MemberField_member_fields.m_field_text_direction as MemberField__m_field_text_direction, MemberField_member_fields.m_field_settings as MemberField__m_field_settings, MemberField_member_fields.m_legacy_field_data as MemberField__m_legacy_field_data
FROM (`exp_member_fields` as MemberField_member_fields)
WHERE (
`MemberField_member_fields`.`m_legacy_field_data` = 'n'
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Session.php L:1210 EE_Session::_setupMemberModel()
-
SELECT exp_members.member_id as Member__member_id, Member_field_id_1.m_field_id_1 as Member__m_field_id_1, Member_field_id_1.m_field_ft_1 as Member__m_field_ft_1
FROM (`exp_members`)
LEFT JOIN `exp_member_data_field_1` AS Member_field_id_1 ON `Member_field_id_1`.`member_id` = `exp_members`.`member_id`
WHERE `exp_members`.`member_id` IN (1)
#system/ee/legacy/libraries/Session.php L:1210 EE_Session::_setupMemberModel()
-
SELECT ee_m_Role_roles.role_id as ee_m_Role__role_id, ee_m_Role_roles.name as ee_m_Role__name, ee_m_Role_roles.short_name as ee_m_Role__short_name, ee_m_Role_roles.description as ee_m_Role__description, ee_m_Role_roles.highlight as ee_m_Role__highlight, ee_m_Role_roles.total_members as ee_m_Role__total_members, ee_m_Role_roles.is_locked as ee_m_Role__is_locked
FROM (`exp_roles` as ee_m_Role_roles)
LEFT JOIN `exp_roles_role_groups` as ee_m_RoleGroup_ee_m_Role_roles_role_groups ON `ee_m_RoleGroup_ee_m_Role_roles_role_groups`.`role_id` = `ee_m_Role_roles`.`role_id`
WHERE `ee_m_RoleGroup_ee_m_Role_roles_role_groups`.`group_id` = 0
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Model/Member/Member.php L:1152 ExpressionEngine\Model\Member\Member::getAllRoles()
-
SELECT Permission_permissions.permission_id as Permission__permission_id, Permission_permissions.role_id as Permission__role_id, Permission_permissions.site_id as Permission__site_id, Permission_permissions.permission as Permission__permission
FROM (`exp_permissions` as Permission_permissions)
WHERE (
`Permission_permissions`.`site_id` = 1
AND `Permission_permissions`.`role_id` IN (1)
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Session.php L:625 ExpressionEngine\Model\Member\Member::getPermissions()
-
UPDATE `exp_sessions` SET `session_id` = 'da9ffed5cd7edfad903828db6978b24652ac100d', `fingerprint` = '72016d1f76d8997a0198bffc2b25a85d', `member_id` = 1, `admin_sess` = 1, `mfa_flag` = 'skip', `ip_address` = '217.63.223.52', `user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', `last_activity` = 1765527327, `sess_start` = 1765527254, `can_debug` = 0 WHERE session_id = 'da9ffed5cd7edfad903828db6978b24652ac100d'
#system/ee/legacy/libraries/Session.php L:190 EE_Session::update_session()
-
SELECT *
FROM (`exp_security_hashes`)
WHERE `session_id` = 'da9ffed5cd7edfad903828db6978b24652ac100d'
#system/ee/legacy/libraries/Csrf.php L:165 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:463 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)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Model/Template/Snippet.php L:170 ExpressionEngine\Model\Template\Snippet::getFolderPath()
-
SELECT `group_id`
FROM (`exp_template_groups`)
WHERE `group_name` = 'news'
AND `site_id` = 1
ORDER BY `group_id` asc
#system/ee/legacy/libraries/Template.php L:229 EE_Template::parse_template_uri()
-
SELECT COUNT(*) as count
FROM (`exp_templates`)
WHERE `group_id` = 7
AND `template_name` = 'studio-treats-fans-to-4th-anniversary-celebration-of-blue-archive'
#system/ee/legacy/libraries/Template.php L:229 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` = 'news'
#system/ee/legacy/libraries/Template.php L:2408 EE_Template::fetch_template()
-
SELECT Role_roles.role_id as Role__role_id, Role_roles.short_name as Role__short_name
FROM (`exp_roles` as Role_roles)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Template.php L:376 EE_Template::getMemberVariables()
-
SELECT `field_id`, `field_type`, `field_fmt`, `field_name`, `site_id`, `field_settings`
FROM (`exp_channel_fields`)
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:338 Api_channel_fields::fetch_custom_channel_fields()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'studio-treats-fans-to-4th-anniversary-celebration-of-blue-archive'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.search_excerpt as Channel__search_excerpt
FROM (`exp_channels` as Channel_channels)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND (t.expiration_date = 0 OR t.expiration_date > 1765527327) AND t.url_title = 'studio-treats-fans-to-4th-anniversary-celebration-of-blue-archive' AND t.channel_id IN (7,13) AND t.url_title = 'studio-treats-fans-to-4th-anniversary-celebration-of-blue-archive' AND t.status IN ('open','suppressed','closed')ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 100
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN (14925)
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN (7)
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = 9
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
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.screen_name, 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.role_id, m.member_id,
wd.*, exp_channel_data_field_25.field_id_25, exp_channel_data_field_25.field_ft_25, exp_channel_data_field_37.field_id_37, exp_channel_data_field_37.field_ft_37, exp_channel_data_field_57.field_id_57, exp_channel_data_field_57.field_ft_57, exp_channel_data_field_59.field_id_59, exp_channel_data_field_59.field_ft_59, exp_channel_data_field_34.field_id_34, exp_channel_data_field_34.field_ft_34, exp_channel_data_field_35.field_id_35, exp_channel_data_field_35.field_ft_35, exp_channel_data_field_51.field_id_51, exp_channel_data_field_51.field_ft_51 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_channel_data_field_25 ON t.entry_id = exp_channel_data_field_25.entry_id LEFT JOIN exp_channel_data_field_37 ON t.entry_id = exp_channel_data_field_37.entry_id LEFT JOIN exp_channel_data_field_57 ON t.entry_id = exp_channel_data_field_57.entry_id LEFT JOIN exp_channel_data_field_59 ON t.entry_id = exp_channel_data_field_59.entry_id LEFT JOIN exp_channel_data_field_34 ON t.entry_id = exp_channel_data_field_34.entry_id LEFT JOIN exp_channel_data_field_35 ON t.entry_id = exp_channel_data_field_35.entry_id LEFT JOIN exp_channel_data_field_51 ON t.entry_id = exp_channel_data_field_51.entry_id WHERE t.entry_id IN (14925)ORDER BY FIELD(t.entry_id, 14925)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT *
FROM (`exp_grid_columns`)
WHERE `field_id` IN (1, 5, 6, 7, 9)
AND `content_type` = 'channel'
ORDER BY `col_order`
#system/ee/legacy/libraries/channel_entries_parser/components/Relationship.php L:56 Grid_model::get_columns_for_field()
-
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`.`fluid_field_data_id` = 0
AND `L0`.`grid_field_id` = 0
AND `L0`.`parent_id` IN (14925)
ORDER BY `L0`.`order` asc
#system/ee/legacy/models/relationship_model.php L:38 Relationship_model::_run_node_query()
-
SELECT ChannelEntry_channel_titles.entry_id as ChannelEntry__entry_id, ChannelEntry_channel_titles.site_id as ChannelEntry__site_id, ChannelEntry_channel_titles.channel_id as ChannelEntry__channel_id, ChannelEntry_channel_titles.author_id as ChannelEntry__author_id, ChannelEntry_channel_titles.forum_topic_id as ChannelEntry__forum_topic_id, ChannelEntry_channel_titles.ip_address as ChannelEntry__ip_address, ChannelEntry_channel_titles.title as ChannelEntry__title, ChannelEntry_channel_titles.url_title as ChannelEntry__url_title, ChannelEntry_channel_titles.status as ChannelEntry__status, ChannelEntry_channel_titles.status_id as ChannelEntry__status_id, ChannelEntry_channel_titles.versioning_enabled as ChannelEntry__versioning_enabled, ChannelEntry_channel_titles.view_count_one as ChannelEntry__view_count_one, ChannelEntry_channel_titles.view_count_two as ChannelEntry__view_count_two, ChannelEntry_channel_titles.view_count_three as ChannelEntry__view_count_three, ChannelEntry_channel_titles.view_count_four as ChannelEntry__view_count_four, ChannelEntry_channel_titles.allow_comments as ChannelEntry__allow_comments, ChannelEntry_channel_titles.sticky as ChannelEntry__sticky, ChannelEntry_channel_titles.entry_date as ChannelEntry__entry_date, ChannelEntry_channel_titles.year as ChannelEntry__year, ChannelEntry_channel_titles.month as ChannelEntry__month, ChannelEntry_channel_titles.day as ChannelEntry__day, ChannelEntry_channel_titles.expiration_date as ChannelEntry__expiration_date, ChannelEntry_channel_titles.comment_expiration_date as ChannelEntry__comment_expiration_date, ChannelEntry_channel_titles.edit_date as ChannelEntry__edit_date, ChannelEntry_channel_titles.recent_comment_date as ChannelEntry__recent_comment_date, ChannelEntry_channel_titles.comment_total as ChannelEntry__comment_total, Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, Author_members.member_id as Author__member_id, Author_members.role_id as Author__role_id, Author_members.pending_role_id as Author__pending_role_id, Author_members.username as Author__username, Author_members.screen_name as Author__screen_name, Author_members.password as Author__password, Author_members.salt as Author__salt, Author_members.unique_id as Author__unique_id, Author_members.crypt_key as Author__crypt_key, Author_members.backup_mfa_code as Author__backup_mfa_code, Author_members.authcode as Author__authcode, Author_members.email as Author__email, Author_members.signature as Author__signature, Author_members.avatar_filename as Author__avatar_filename, Author_members.avatar_width as Author__avatar_width, Author_members.avatar_height as Author__avatar_height, Author_members.photo_filename as Author__photo_filename, Author_members.photo_width as Author__photo_width, Author_members.photo_height as Author__photo_height, Author_members.sig_img_filename as Author__sig_img_filename, Author_members.sig_img_width as Author__sig_img_width, Author_members.sig_img_height as Author__sig_img_height, Author_members.ignore_list as Author__ignore_list, Author_members.private_messages as Author__private_messages, Author_members.accept_messages as Author__accept_messages, Author_members.last_view_bulletins as Author__last_view_bulletins, Author_members.last_bulletin_date as Author__last_bulletin_date, Author_members.ip_address as Author__ip_address, Author_members.join_date as Author__join_date, Author_members.last_visit as Author__last_visit, Author_members.last_activity as Author__last_activity, Author_members.total_entries as Author__total_entries, Author_members.total_comments as Author__total_comments, Author_members.total_forum_topics as Author__total_forum_topics, Author_members.total_forum_posts as Author__total_forum_posts, Author_members.last_entry_date as Author__last_entry_date, Author_members.last_comment_date as Author__last_comment_date, Author_members.last_forum_post_date as Author__last_forum_post_date, Author_members.last_email_date as Author__last_email_date, Author_members.in_authorlist as Author__in_authorlist, Author_members.accept_admin_email as Author__accept_admin_email, Author_members.accept_user_email as Author__accept_user_email, Author_members.notify_by_default as Author__notify_by_default, Author_members.notify_of_pm as Author__notify_of_pm, Author_members.display_signatures as Author__display_signatures, Author_members.parse_smileys as Author__parse_smileys, Author_members.smart_notifications as Author__smart_notifications, Author_members.language as Author__language, Author_members.timezone as Author__timezone, Author_members.time_format as Author__time_format, Author_members.date_format as Author__date_format, Author_members.week_start as Author__week_start, Author_members.include_seconds as Author__include_seconds, Author_members.profile_theme as Author__profile_theme, Author_members.forum_theme as Author__forum_theme, Author_members.tracker as Author__tracker, Author_members.template_size as Author__template_size, Author_members.notepad as Author__notepad, Author_members.notepad_size as Author__notepad_size, Author_members.bookmarklets as Author__bookmarklets, Author_members.quick_links as Author__quick_links, Author_members.quick_tabs as Author__quick_tabs, Author_members.show_sidebar as Author__show_sidebar, Author_members.pmember_id as Author__pmember_id, Author_members.cp_homepage as Author__cp_homepage, Author_members.cp_homepage_channel as Author__cp_homepage_channel, Author_members.cp_homepage_custom as Author__cp_homepage_custom, Author_members.dismissed_banner as Author__dismissed_banner, Author_members.enable_mfa as Author__enable_mfa
FROM (`exp_channel_titles` as ChannelEntry_channel_titles)
LEFT JOIN `exp_channel_data` as ChannelEntry_channel_data ON `ChannelEntry_channel_data`.`entry_id` = `ChannelEntry_channel_titles`.`entry_id`
LEFT JOIN `exp_channels` AS Channel_channels ON `Channel_channels`.`channel_id` = `ChannelEntry_channel_titles`.`channel_id`
LEFT JOIN `exp_members` AS Author_members ON `Author_members`.`member_id` = `ChannelEntry_channel_titles`.`author_id`
LEFT JOIN `exp_member_data` as Author_member_data ON `Author_member_data`.`member_id` = `Author_members`.`member_id`
WHERE (
`ChannelEntry_channel_titles`.`entry_id` IN (14925, 14226)
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required
FROM (`exp_channels` as Channel_channels)
WHERE (
`Channel_channels`.`channel_id` IN (5, 7)
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channels_channel_fields` as ee_m_Channel_ee_m_ChannelField_channels_channel_fields ON `ee_m_Channel_ee_m_ChannelField_channels_channel_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_Channel_ee_m_ChannelField_channels_channel_fields`.`channel_id` = 5
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Model/Channel/Channel.php L:596 ExpressionEngine\Model\Channel\Channel::__get()
-
SELECT ee_m_ChannelFieldGroup_field_groups.group_id as ee_m_ChannelFieldGroup__group_id, ee_m_ChannelFieldGroup_field_groups.site_id as ee_m_ChannelFieldGroup__site_id, ee_m_ChannelFieldGroup_field_groups.group_name as ee_m_ChannelFieldGroup__group_name, ee_m_ChannelFieldGroup_field_groups.short_name as ee_m_ChannelFieldGroup__short_name, ee_m_ChannelFieldGroup_field_groups.group_description as ee_m_ChannelFieldGroup__group_description
FROM (`exp_field_groups` as ee_m_ChannelFieldGroup_field_groups)
LEFT JOIN `exp_channels_channel_field_groups` as ee_m_Channel_ee_m_ChannelFieldGroup_channels_channel_field_groups ON `ee_m_Channel_ee_m_ChannelFieldGroup_channels_channel_field_groups`.`group_id` = `ee_m_ChannelFieldGroup_field_groups`.`group_id`
WHERE `ee_m_Channel_ee_m_ChannelFieldGroup_channels_channel_field_groups`.`channel_id` = 5
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Model/Channel/Channel.php L:597 ExpressionEngine\Model\Channel\Channel::__get()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = 6
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Service/Model/Query/Select.php L:273 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
SELECT exp_channel_titles.entry_id as ChannelEntry__entry_id, ChannelEntry_field_id_33.field_id_33 as ChannelEntry__field_id_33, ChannelEntry_field_id_33.field_ft_33 as ChannelEntry__field_ft_33, ChannelEntry_field_id_38.field_id_38 as ChannelEntry__field_id_38, ChannelEntry_field_id_38.field_ft_38 as ChannelEntry__field_ft_38, ChannelEntry_field_id_39.field_id_39 as ChannelEntry__field_id_39, ChannelEntry_field_id_39.field_dt_39 as ChannelEntry__field_dt_39, ChannelEntry_field_id_39.field_ft_39 as ChannelEntry__field_ft_39, ChannelEntry_field_id_42.field_id_42 as ChannelEntry__field_id_42, ChannelEntry_field_id_42.field_ft_42 as ChannelEntry__field_ft_42, ChannelEntry_field_id_10.field_id_10 as ChannelEntry__field_id_10, ChannelEntry_field_id_10.field_ft_10 as ChannelEntry__field_ft_10, ChannelEntry_field_id_11.field_id_11 as ChannelEntry__field_id_11, ChannelEntry_field_id_11.field_ft_11 as ChannelEntry__field_ft_11, ChannelEntry_field_id_12.field_id_12 as ChannelEntry__field_id_12, ChannelEntry_field_id_12.field_ft_12 as ChannelEntry__field_ft_12, ChannelEntry_field_id_13.field_id_13 as ChannelEntry__field_id_13, ChannelEntry_field_id_13.field_ft_13 as ChannelEntry__field_ft_13, ChannelEntry_field_id_14.field_id_14 as ChannelEntry__field_id_14, ChannelEntry_field_id_14.field_ft_14 as ChannelEntry__field_ft_14, ChannelEntry_field_id_15.field_id_15 as ChannelEntry__field_id_15, ChannelEntry_field_id_15.field_ft_15 as ChannelEntry__field_ft_15, ChannelEntry_field_id_21.field_id_21 as ChannelEntry__field_id_21, ChannelEntry_field_id_21.field_ft_21 as ChannelEntry__field_ft_21, ChannelEntry_field_id_32.field_id_32 as ChannelEntry__field_id_32, ChannelEntry_field_id_32.field_ft_32 as ChannelEntry__field_ft_32, ChannelEntry_field_id_40.field_id_40 as ChannelEntry__field_id_40, ChannelEntry_field_id_40.field_ft_40 as ChannelEntry__field_ft_40, ChannelEntry_field_id_41.field_id_41 as ChannelEntry__field_id_41, ChannelEntry_field_id_41.field_ft_41 as ChannelEntry__field_ft_41, ChannelEntry_field_id_48.field_id_48 as ChannelEntry__field_id_48, ChannelEntry_field_id_48.field_ft_48 as ChannelEntry__field_ft_48, ChannelEntry_field_id_49.field_id_49 as ChannelEntry__field_id_49, ChannelEntry_field_id_49.field_ft_49 as ChannelEntry__field_ft_49, ChannelEntry_field_id_54.field_id_54 as ChannelEntry__field_id_54, ChannelEntry_field_id_54.field_ft_54 as ChannelEntry__field_ft_54, ChannelEntry_field_id_55.field_id_55 as ChannelEntry__field_id_55, ChannelEntry_field_id_55.field_ft_55 as ChannelEntry__field_ft_55, ChannelEntry_field_id_56.field_id_56 as ChannelEntry__field_id_56, ChannelEntry_field_id_56.field_ft_56 as ChannelEntry__field_ft_56, ChannelEntry_field_id_58.field_id_58 as ChannelEntry__field_id_58, ChannelEntry_field_id_58.field_ft_58 as ChannelEntry__field_ft_58, ChannelEntry_field_id_25.field_id_25 as ChannelEntry__field_id_25, ChannelEntry_field_id_25.field_ft_25 as ChannelEntry__field_ft_25, ChannelEntry_field_id_37.field_id_37 as ChannelEntry__field_id_37, ChannelEntry_field_id_37.field_ft_37 as ChannelEntry__field_ft_37, ChannelEntry_field_id_57.field_id_57 as ChannelEntry__field_id_57, ChannelEntry_field_id_57.field_ft_57 as ChannelEntry__field_ft_57, ChannelEntry_field_id_59.field_id_59 as ChannelEntry__field_id_59, ChannelEntry_field_id_59.field_ft_59 as ChannelEntry__field_ft_59, ChannelEntry_field_id_34.field_id_34 as ChannelEntry__field_id_34, ChannelEntry_field_id_34.field_ft_34 as ChannelEntry__field_ft_34, ChannelEntry_field_id_35.field_id_35 as ChannelEntry__field_id_35, ChannelEntry_field_id_35.field_ft_35 as ChannelEntry__field_ft_35, ChannelEntry_field_id_51.field_id_51 as ChannelEntry__field_id_51, ChannelEntry_field_id_51.field_ft_51 as ChannelEntry__field_ft_51
FROM (`exp_channel_titles`)
LEFT JOIN `exp_channel_data_field_33` AS ChannelEntry_field_id_33 ON `ChannelEntry_field_id_33`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_38` AS ChannelEntry_field_id_38 ON `ChannelEntry_field_id_38`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_39` AS ChannelEntry_field_id_39 ON `ChannelEntry_field_id_39`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_42` AS ChannelEntry_field_id_42 ON `ChannelEntry_field_id_42`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_10` AS ChannelEntry_field_id_10 ON `ChannelEntry_field_id_10`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_11` AS ChannelEntry_field_id_11 ON `ChannelEntry_field_id_11`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_12` AS ChannelEntry_field_id_12 ON `ChannelEntry_field_id_12`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_13` AS ChannelEntry_field_id_13 ON `ChannelEntry_field_id_13`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_14` AS ChannelEntry_field_id_14 ON `ChannelEntry_field_id_14`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_15` AS ChannelEntry_field_id_15 ON `ChannelEntry_field_id_15`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_21` AS ChannelEntry_field_id_21 ON `ChannelEntry_field_id_21`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_32` AS ChannelEntry_field_id_32 ON `ChannelEntry_field_id_32`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_40` AS ChannelEntry_field_id_40 ON `ChannelEntry_field_id_40`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_41` AS ChannelEntry_field_id_41 ON `ChannelEntry_field_id_41`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_48` AS ChannelEntry_field_id_48 ON `ChannelEntry_field_id_48`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_49` AS ChannelEntry_field_id_49 ON `ChannelEntry_field_id_49`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_54` AS ChannelEntry_field_id_54 ON `ChannelEntry_field_id_54`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_55` AS ChannelEntry_field_id_55 ON `ChannelEntry_field_id_55`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_56` AS ChannelEntry_field_id_56 ON `ChannelEntry_field_id_56`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_58` AS ChannelEntry_field_id_58 ON `ChannelEntry_field_id_58`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_25` AS ChannelEntry_field_id_25 ON `ChannelEntry_field_id_25`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_37` AS ChannelEntry_field_id_37 ON `ChannelEntry_field_id_37`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_57` AS ChannelEntry_field_id_57 ON `ChannelEntry_field_id_57`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_59` AS ChannelEntry_field_id_59 ON `ChannelEntry_field_id_59`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_34` AS ChannelEntry_field_id_34 ON `ChannelEntry_field_id_34`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_35` AS ChannelEntry_field_id_35 ON `ChannelEntry_field_id_35`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_51` AS ChannelEntry_field_id_51 ON `ChannelEntry_field_id_51`.`entry_id` = `exp_channel_titles`.`entry_id`
WHERE `exp_channel_titles`.`entry_id` IN (14226, 14925)
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT exp_members.member_id as Author__member_id, Author_field_id_1.m_field_id_1 as Author__m_field_id_1, Author_field_id_1.m_field_ft_1 as Author__m_field_ft_1
FROM (`exp_members`)
LEFT JOIN `exp_member_data_field_1` AS Author_field_id_1 ON `Author_field_id_1`.`member_id` = `exp_members`.`member_id`
WHERE `exp_members`.`member_id` IN (1, 4)
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT *
FROM (`exp_fieldtypes`)
#system/ee/legacy/libraries/api/Api_channel_fields.php L:126 EE_Addons::get_installed()
-
SHOW TABLES FROM `rpggamers`
#system/phar://user/addons/fieldpack/fieldpack.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\Fieldpack\FluxCapacitor\Bridge\EE5::initiateSettings()
-
SELECT `settings`
FROM (`exp_fieldtypes`)
WHERE `name` = 'fieldpack'
#system/phar://user/addons/fieldpack/fieldpack.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\Fieldpack\FluxCapacitor\Bridge\EE5::initiateSettings()
-
SHOW TABLES FROM `rpggamers`
#system/phar://user/addons/tagger/tagger.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\Tagger\FluxCapacitor\Bridge\EE5::initiateSettings()
-
SELECT `settings`
FROM (`exp_fieldtypes`)
WHERE `name` = 'tagger'
#system/phar://user/addons/tagger/tagger.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\Tagger\FluxCapacitor\Bridge\EE5::initiateSettings()
-
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:227 Addons_model::get_plugin_formatting()
-
SHOW TABLES FROM `rpggamers`
#system/phar://user/addons/favorites/favorites.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\Favorites\FluxCapacitor\Bridge\EE5::initiateSettings()
-
SELECT `settings`
FROM (`exp_fieldtypes`)
WHERE `name` = 'favorites'
#system/phar://user/addons/favorites/favorites.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\Favorites\FluxCapacitor\Bridge\EE5::initiateSettings()
-
SELECT lasting_impressions_m_Settings_lasting_impressions.li_id as lasting_impressions_m_Settings__li_id, lasting_impressions_m_Settings_lasting_impressions.channel_id as lasting_impressions_m_Settings__channel_id, lasting_impressions_m_Settings_lasting_impressions.site_id as lasting_impressions_m_Settings__site_id, lasting_impressions_m_Settings_lasting_impressions.limit as lasting_impressions_m_Settings__limit, lasting_impressions_m_Settings_lasting_impressions.enabled as lasting_impressions_m_Settings__enabled, lasting_impressions_m_Settings_lasting_impressions.expires as lasting_impressions_m_Settings__expires
FROM (`exp_lasting_impressions` as lasting_impressions_m_Settings_lasting_impressions)
LIMIT 1
#system/ee/legacy/core/Loader.php L:944 Lasting_impressions_entries::__construct()
-
SHOW TABLES FROM `rpggamers`
#system/phar://user/addons/matrix/matrix.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\Matrix\FluxCapacitor\Bridge\EE5::initiateSettings()
-
SELECT `settings`
FROM (`exp_fieldtypes`)
WHERE `name` = 'matrix'
#system/phar://user/addons/matrix/matrix.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\Matrix\FluxCapacitor\Bridge\EE5::initiateSettings()
-
SELECT `field_id`, `field_name`, `field_settings`
FROM (`exp_channel_fields`)
WHERE `field_type` = 'matrix'
AND `site_id` IN (1, 0)
#system/user/addons/matrix/ext.matrix.php L:91 Matrix_ext::_get_site_fields()
-
SHOW TABLES FROM `rpggamers`
#system/phar://user/addons/channel_images/channel_images.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\ChannelImages\FluxCapacitor\Bridge\EE5::initiateSettings()
-
SELECT `settings`
FROM (`exp_fieldtypes`)
WHERE `name` = 'channel_images'
#system/phar://user/addons/channel_images/channel_images.phar/FluxCapacitor/Bridge/EE5.php L:216 EEHarbor\ChannelImages\FluxCapacitor\Bridge\EE5::initiateSettings()
-
SELECT `settings`
FROM (`exp_modules`)
WHERE `module_name` = 'Channel_images'
#system/user/addons/channel_images/Service/Settings.php L:25 EEHarbor\ChannelImages\Service\Settings::getModuleSettings()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 33
AND `entry_id` = 14226
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT `field_settings`
FROM (`exp_channel_fields`)
WHERE `field_id` = 33
#system/user/addons/channel_images/models/channel_images_model.php L:645 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.adapter as UploadDestination__adapter, UploadDestination_upload_prefs.adapter_settings as UploadDestination__adapter_settings, 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.allow_subfolders as UploadDestination__allow_subfolders, UploadDestination_upload_prefs.subfolders_on_top as UploadDestination__subfolders_on_top, 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` = '9'
)
LIMIT 1
#system/user/addons/channel_images/locations/local/local.php L:131 CI_Location_local::getLocationPrefs()
-
UPDATE exp_channel_titles SET view_count_one = (view_count_one + 1) WHERE url_title = 'studio-treats-fans-to-4th-anniversary-celebration-of-blue-archive'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:270 Channel::track_views()
-
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1765527327 AND (t.expiration_date = 0 OR t.expiration_date > 1765527327) AND t.url_title != 'studio-treats-fans-to-4th-anniversary-celebration-of-blue-archive' AND t.channel_id IN (7,13,9) AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 3
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN (14928, 14927, 14926)
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 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.screen_name, 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.role_id, m.member_id,
wd.*, exp_channel_data_field_25.field_id_25, exp_channel_data_field_25.field_ft_25, exp_channel_data_field_37.field_id_37, exp_channel_data_field_37.field_ft_37, exp_channel_data_field_57.field_id_57, exp_channel_data_field_57.field_ft_57, exp_channel_data_field_59.field_id_59, exp_channel_data_field_59.field_ft_59, exp_channel_data_field_34.field_id_34, exp_channel_data_field_34.field_ft_34, exp_channel_data_field_35.field_id_35, exp_channel_data_field_35.field_ft_35, exp_channel_data_field_51.field_id_51, exp_channel_data_field_51.field_ft_51 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_channel_data_field_25 ON t.entry_id = exp_channel_data_field_25.entry_id LEFT JOIN exp_channel_data_field_37 ON t.entry_id = exp_channel_data_field_37.entry_id LEFT JOIN exp_channel_data_field_57 ON t.entry_id = exp_channel_data_field_57.entry_id LEFT JOIN exp_channel_data_field_59 ON t.entry_id = exp_channel_data_field_59.entry_id LEFT JOIN exp_channel_data_field_34 ON t.entry_id = exp_channel_data_field_34.entry_id LEFT JOIN exp_channel_data_field_35 ON t.entry_id = exp_channel_data_field_35.entry_id LEFT JOIN exp_channel_data_field_51 ON t.entry_id = exp_channel_data_field_51.entry_id WHERE t.entry_id IN (14928,14927,14926)ORDER BY FIELD(t.entry_id, 14928,14927,14926)
#system/ee/legacy/libraries/Template.php L:1841 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`.`fluid_field_data_id` = 0
AND `L0`.`grid_field_id` = 0
AND `L0`.`parent_id` IN (14928, 14927, 14926)
ORDER BY `L0`.`order` asc
#system/ee/legacy/models/relationship_model.php L:38 Relationship_model::_run_node_query()
-
SELECT ChannelEntry_channel_titles.entry_id as ChannelEntry__entry_id, ChannelEntry_channel_titles.site_id as ChannelEntry__site_id, ChannelEntry_channel_titles.channel_id as ChannelEntry__channel_id, ChannelEntry_channel_titles.author_id as ChannelEntry__author_id, ChannelEntry_channel_titles.forum_topic_id as ChannelEntry__forum_topic_id, ChannelEntry_channel_titles.ip_address as ChannelEntry__ip_address, ChannelEntry_channel_titles.title as ChannelEntry__title, ChannelEntry_channel_titles.url_title as ChannelEntry__url_title, ChannelEntry_channel_titles.status as ChannelEntry__status, ChannelEntry_channel_titles.status_id as ChannelEntry__status_id, ChannelEntry_channel_titles.versioning_enabled as ChannelEntry__versioning_enabled, ChannelEntry_channel_titles.view_count_one as ChannelEntry__view_count_one, ChannelEntry_channel_titles.view_count_two as ChannelEntry__view_count_two, ChannelEntry_channel_titles.view_count_three as ChannelEntry__view_count_three, ChannelEntry_channel_titles.view_count_four as ChannelEntry__view_count_four, ChannelEntry_channel_titles.allow_comments as ChannelEntry__allow_comments, ChannelEntry_channel_titles.sticky as ChannelEntry__sticky, ChannelEntry_channel_titles.entry_date as ChannelEntry__entry_date, ChannelEntry_channel_titles.year as ChannelEntry__year, ChannelEntry_channel_titles.month as ChannelEntry__month, ChannelEntry_channel_titles.day as ChannelEntry__day, ChannelEntry_channel_titles.expiration_date as ChannelEntry__expiration_date, ChannelEntry_channel_titles.comment_expiration_date as ChannelEntry__comment_expiration_date, ChannelEntry_channel_titles.edit_date as ChannelEntry__edit_date, ChannelEntry_channel_titles.recent_comment_date as ChannelEntry__recent_comment_date, ChannelEntry_channel_titles.comment_total as ChannelEntry__comment_total, Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, Author_members.member_id as Author__member_id, Author_members.role_id as Author__role_id, Author_members.pending_role_id as Author__pending_role_id, Author_members.username as Author__username, Author_members.screen_name as Author__screen_name, Author_members.password as Author__password, Author_members.salt as Author__salt, Author_members.unique_id as Author__unique_id, Author_members.crypt_key as Author__crypt_key, Author_members.backup_mfa_code as Author__backup_mfa_code, Author_members.authcode as Author__authcode, Author_members.email as Author__email, Author_members.signature as Author__signature, Author_members.avatar_filename as Author__avatar_filename, Author_members.avatar_width as Author__avatar_width, Author_members.avatar_height as Author__avatar_height, Author_members.photo_filename as Author__photo_filename, Author_members.photo_width as Author__photo_width, Author_members.photo_height as Author__photo_height, Author_members.sig_img_filename as Author__sig_img_filename, Author_members.sig_img_width as Author__sig_img_width, Author_members.sig_img_height as Author__sig_img_height, Author_members.ignore_list as Author__ignore_list, Author_members.private_messages as Author__private_messages, Author_members.accept_messages as Author__accept_messages, Author_members.last_view_bulletins as Author__last_view_bulletins, Author_members.last_bulletin_date as Author__last_bulletin_date, Author_members.ip_address as Author__ip_address, Author_members.join_date as Author__join_date, Author_members.last_visit as Author__last_visit, Author_members.last_activity as Author__last_activity, Author_members.total_entries as Author__total_entries, Author_members.total_comments as Author__total_comments, Author_members.total_forum_topics as Author__total_forum_topics, Author_members.total_forum_posts as Author__total_forum_posts, Author_members.last_entry_date as Author__last_entry_date, Author_members.last_comment_date as Author__last_comment_date, Author_members.last_forum_post_date as Author__last_forum_post_date, Author_members.last_email_date as Author__last_email_date, Author_members.in_authorlist as Author__in_authorlist, Author_members.accept_admin_email as Author__accept_admin_email, Author_members.accept_user_email as Author__accept_user_email, Author_members.notify_by_default as Author__notify_by_default, Author_members.notify_of_pm as Author__notify_of_pm, Author_members.display_signatures as Author__display_signatures, Author_members.parse_smileys as Author__parse_smileys, Author_members.smart_notifications as Author__smart_notifications, Author_members.language as Author__language, Author_members.timezone as Author__timezone, Author_members.time_format as Author__time_format, Author_members.date_format as Author__date_format, Author_members.week_start as Author__week_start, Author_members.include_seconds as Author__include_seconds, Author_members.profile_theme as Author__profile_theme, Author_members.forum_theme as Author__forum_theme, Author_members.tracker as Author__tracker, Author_members.template_size as Author__template_size, Author_members.notepad as Author__notepad, Author_members.notepad_size as Author__notepad_size, Author_members.bookmarklets as Author__bookmarklets, Author_members.quick_links as Author__quick_links, Author_members.quick_tabs as Author__quick_tabs, Author_members.show_sidebar as Author__show_sidebar, Author_members.pmember_id as Author__pmember_id, Author_members.cp_homepage as Author__cp_homepage, Author_members.cp_homepage_channel as Author__cp_homepage_channel, Author_members.cp_homepage_custom as Author__cp_homepage_custom, Author_members.dismissed_banner as Author__dismissed_banner, Author_members.enable_mfa as Author__enable_mfa
FROM (`exp_channel_titles` as ChannelEntry_channel_titles)
LEFT JOIN `exp_channel_data` as ChannelEntry_channel_data ON `ChannelEntry_channel_data`.`entry_id` = `ChannelEntry_channel_titles`.`entry_id`
LEFT JOIN `exp_channels` AS Channel_channels ON `Channel_channels`.`channel_id` = `ChannelEntry_channel_titles`.`channel_id`
LEFT JOIN `exp_members` AS Author_members ON `Author_members`.`member_id` = `ChannelEntry_channel_titles`.`author_id`
LEFT JOIN `exp_member_data` as Author_member_data ON `Author_member_data`.`member_id` = `Author_members`.`member_id`
WHERE (
`ChannelEntry_channel_titles`.`entry_id` IN (14928, 14927, 14926, 13346, 13458, 14913)
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required
FROM (`exp_channels` as Channel_channels)
WHERE (
`Channel_channels`.`channel_id` IN (5, 7)
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT exp_channel_titles.entry_id as ChannelEntry__entry_id, ChannelEntry_field_id_33.field_id_33 as ChannelEntry__field_id_33, ChannelEntry_field_id_33.field_ft_33 as ChannelEntry__field_ft_33, ChannelEntry_field_id_38.field_id_38 as ChannelEntry__field_id_38, ChannelEntry_field_id_38.field_ft_38 as ChannelEntry__field_ft_38, ChannelEntry_field_id_39.field_id_39 as ChannelEntry__field_id_39, ChannelEntry_field_id_39.field_dt_39 as ChannelEntry__field_dt_39, ChannelEntry_field_id_39.field_ft_39 as ChannelEntry__field_ft_39, ChannelEntry_field_id_42.field_id_42 as ChannelEntry__field_id_42, ChannelEntry_field_id_42.field_ft_42 as ChannelEntry__field_ft_42, ChannelEntry_field_id_10.field_id_10 as ChannelEntry__field_id_10, ChannelEntry_field_id_10.field_ft_10 as ChannelEntry__field_ft_10, ChannelEntry_field_id_11.field_id_11 as ChannelEntry__field_id_11, ChannelEntry_field_id_11.field_ft_11 as ChannelEntry__field_ft_11, ChannelEntry_field_id_12.field_id_12 as ChannelEntry__field_id_12, ChannelEntry_field_id_12.field_ft_12 as ChannelEntry__field_ft_12, ChannelEntry_field_id_13.field_id_13 as ChannelEntry__field_id_13, ChannelEntry_field_id_13.field_ft_13 as ChannelEntry__field_ft_13, ChannelEntry_field_id_14.field_id_14 as ChannelEntry__field_id_14, ChannelEntry_field_id_14.field_ft_14 as ChannelEntry__field_ft_14, ChannelEntry_field_id_15.field_id_15 as ChannelEntry__field_id_15, ChannelEntry_field_id_15.field_ft_15 as ChannelEntry__field_ft_15, ChannelEntry_field_id_21.field_id_21 as ChannelEntry__field_id_21, ChannelEntry_field_id_21.field_ft_21 as ChannelEntry__field_ft_21, ChannelEntry_field_id_32.field_id_32 as ChannelEntry__field_id_32, ChannelEntry_field_id_32.field_ft_32 as ChannelEntry__field_ft_32, ChannelEntry_field_id_40.field_id_40 as ChannelEntry__field_id_40, ChannelEntry_field_id_40.field_ft_40 as ChannelEntry__field_ft_40, ChannelEntry_field_id_41.field_id_41 as ChannelEntry__field_id_41, ChannelEntry_field_id_41.field_ft_41 as ChannelEntry__field_ft_41, ChannelEntry_field_id_48.field_id_48 as ChannelEntry__field_id_48, ChannelEntry_field_id_48.field_ft_48 as ChannelEntry__field_ft_48, ChannelEntry_field_id_49.field_id_49 as ChannelEntry__field_id_49, ChannelEntry_field_id_49.field_ft_49 as ChannelEntry__field_ft_49, ChannelEntry_field_id_54.field_id_54 as ChannelEntry__field_id_54, ChannelEntry_field_id_54.field_ft_54 as ChannelEntry__field_ft_54, ChannelEntry_field_id_55.field_id_55 as ChannelEntry__field_id_55, ChannelEntry_field_id_55.field_ft_55 as ChannelEntry__field_ft_55, ChannelEntry_field_id_56.field_id_56 as ChannelEntry__field_id_56, ChannelEntry_field_id_56.field_ft_56 as ChannelEntry__field_ft_56, ChannelEntry_field_id_58.field_id_58 as ChannelEntry__field_id_58, ChannelEntry_field_id_58.field_ft_58 as ChannelEntry__field_ft_58, ChannelEntry_field_id_25.field_id_25 as ChannelEntry__field_id_25, ChannelEntry_field_id_25.field_ft_25 as ChannelEntry__field_ft_25, ChannelEntry_field_id_37.field_id_37 as ChannelEntry__field_id_37, ChannelEntry_field_id_37.field_ft_37 as ChannelEntry__field_ft_37, ChannelEntry_field_id_57.field_id_57 as ChannelEntry__field_id_57, ChannelEntry_field_id_57.field_ft_57 as ChannelEntry__field_ft_57, ChannelEntry_field_id_59.field_id_59 as ChannelEntry__field_id_59, ChannelEntry_field_id_59.field_ft_59 as ChannelEntry__field_ft_59, ChannelEntry_field_id_34.field_id_34 as ChannelEntry__field_id_34, ChannelEntry_field_id_34.field_ft_34 as ChannelEntry__field_ft_34, ChannelEntry_field_id_35.field_id_35 as ChannelEntry__field_id_35, ChannelEntry_field_id_35.field_ft_35 as ChannelEntry__field_ft_35, ChannelEntry_field_id_51.field_id_51 as ChannelEntry__field_id_51, ChannelEntry_field_id_51.field_ft_51 as ChannelEntry__field_ft_51
FROM (`exp_channel_titles`)
LEFT JOIN `exp_channel_data_field_33` AS ChannelEntry_field_id_33 ON `ChannelEntry_field_id_33`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_38` AS ChannelEntry_field_id_38 ON `ChannelEntry_field_id_38`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_39` AS ChannelEntry_field_id_39 ON `ChannelEntry_field_id_39`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_42` AS ChannelEntry_field_id_42 ON `ChannelEntry_field_id_42`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_10` AS ChannelEntry_field_id_10 ON `ChannelEntry_field_id_10`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_11` AS ChannelEntry_field_id_11 ON `ChannelEntry_field_id_11`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_12` AS ChannelEntry_field_id_12 ON `ChannelEntry_field_id_12`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_13` AS ChannelEntry_field_id_13 ON `ChannelEntry_field_id_13`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_14` AS ChannelEntry_field_id_14 ON `ChannelEntry_field_id_14`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_15` AS ChannelEntry_field_id_15 ON `ChannelEntry_field_id_15`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_21` AS ChannelEntry_field_id_21 ON `ChannelEntry_field_id_21`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_32` AS ChannelEntry_field_id_32 ON `ChannelEntry_field_id_32`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_40` AS ChannelEntry_field_id_40 ON `ChannelEntry_field_id_40`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_41` AS ChannelEntry_field_id_41 ON `ChannelEntry_field_id_41`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_48` AS ChannelEntry_field_id_48 ON `ChannelEntry_field_id_48`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_49` AS ChannelEntry_field_id_49 ON `ChannelEntry_field_id_49`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_54` AS ChannelEntry_field_id_54 ON `ChannelEntry_field_id_54`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_55` AS ChannelEntry_field_id_55 ON `ChannelEntry_field_id_55`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_56` AS ChannelEntry_field_id_56 ON `ChannelEntry_field_id_56`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_58` AS ChannelEntry_field_id_58 ON `ChannelEntry_field_id_58`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_25` AS ChannelEntry_field_id_25 ON `ChannelEntry_field_id_25`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_37` AS ChannelEntry_field_id_37 ON `ChannelEntry_field_id_37`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_57` AS ChannelEntry_field_id_57 ON `ChannelEntry_field_id_57`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_59` AS ChannelEntry_field_id_59 ON `ChannelEntry_field_id_59`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_34` AS ChannelEntry_field_id_34 ON `ChannelEntry_field_id_34`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_35` AS ChannelEntry_field_id_35 ON `ChannelEntry_field_id_35`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_51` AS ChannelEntry_field_id_51 ON `ChannelEntry_field_id_51`.`entry_id` = `exp_channel_titles`.`entry_id`
WHERE `exp_channel_titles`.`entry_id` IN (13346, 13458, 14913, 14926, 14927, 14928)
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT exp_members.member_id as Author__member_id, Author_field_id_1.m_field_id_1 as Author__m_field_id_1, Author_field_id_1.m_field_ft_1 as Author__m_field_ft_1
FROM (`exp_members`)
LEFT JOIN `exp_member_data_field_1` AS Author_field_id_1 ON `Author_field_id_1`.`member_id` = `exp_members`.`member_id`
WHERE `exp_members`.`member_id` IN (1, 1, 1, 4, 4, 4)
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 33
AND `entry_id` = 13458
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 33
AND `entry_id` = 13346
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT `fieldtype_id`
FROM (`exp_fieldtypes`)
WHERE `name` = 'rte'
#system/ee/legacy/libraries/api/Api_channel_fields.php L:415 Matrix_ft::__construct()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 33
AND `entry_id` = 14913
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT `m_field_id`, `m_field_name`, `m_field_fmt`, `m_legacy_field_data`, `m_field_type`, `m_field_settings`
FROM (`exp_member_fields`)
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:409 Api_channel_fields::fetch_custom_member_fields()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'studio-treats-fans-to-4th-anniversary-celebration-of-blue-archive'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1765527327 AND (t.expiration_date = 0 OR t.expiration_date > 1765527327) AND t.channel_id IN (7,13) AND t.url_title = 'studio-treats-fans-to-4th-anniversary-celebration-of-blue-archive' AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 100
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN (14925)
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 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.screen_name, 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.role_id, m.member_id,
wd.*, md.* , exp_member_data_field_1.*, exp_channel_data_field_25.field_id_25, exp_channel_data_field_25.field_ft_25, exp_channel_data_field_37.field_id_37, exp_channel_data_field_37.field_ft_37, exp_channel_data_field_57.field_id_57, exp_channel_data_field_57.field_ft_57, exp_channel_data_field_59.field_id_59, exp_channel_data_field_59.field_ft_59, exp_channel_data_field_34.field_id_34, exp_channel_data_field_34.field_ft_34, exp_channel_data_field_35.field_id_35, exp_channel_data_field_35.field_ft_35, exp_channel_data_field_51.field_id_51, exp_channel_data_field_51.field_ft_51 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 LEFT JOIN exp_member_data_field_1 ON m.member_id = exp_member_data_field_1.member_id LEFT JOIN exp_channel_data_field_25 ON t.entry_id = exp_channel_data_field_25.entry_id LEFT JOIN exp_channel_data_field_37 ON t.entry_id = exp_channel_data_field_37.entry_id LEFT JOIN exp_channel_data_field_57 ON t.entry_id = exp_channel_data_field_57.entry_id LEFT JOIN exp_channel_data_field_59 ON t.entry_id = exp_channel_data_field_59.entry_id LEFT JOIN exp_channel_data_field_34 ON t.entry_id = exp_channel_data_field_34.entry_id LEFT JOIN exp_channel_data_field_35 ON t.entry_id = exp_channel_data_field_35.entry_id LEFT JOIN exp_channel_data_field_51 ON t.entry_id = exp_channel_data_field_51.entry_id WHERE t.entry_id IN (14925)ORDER BY FIELD(t.entry_id, 14925)
#system/ee/legacy/libraries/Template.php L:1841 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`.`fluid_field_data_id` = 0
AND `L0`.`grid_field_id` = 0
AND `L0`.`parent_id` IN (14925)
ORDER BY `L0`.`order` asc
#system/ee/legacy/models/relationship_model.php L:38 Relationship_model::_run_node_query()
-
SELECT `col_id`, `col_type`, `col_label`, `col_name`, `col_instructions`, `col_width`, `col_required`, `col_search`, `col_settings`
FROM (`exp_matrix_cols`)
WHERE `field_id` = 38
ORDER BY `col_order`
#system/user/addons/matrix/ft.matrix.php L:2984 Matrix_ft::_get_cols()
-
SELECT `name`, `settings`
FROM (`exp_fieldtypes`)
#system/user/addons/matrix/ft.matrix.php L:742 Matrix_ft::_get_all_celltype_settings()
-
SELECT row_id, col_id_2, col_id_3, col_id_4, col_id_5
FROM exp_matrix_data WHERE field_id = 38
AND entry_id = 14226
AND is_draft = 0 ORDER BY row_order ASC LIMIT 100
#system/user/addons/matrix/ft.matrix.php L:3028 Matrix_ft::_data_query()
-
SELECT row_id
FROM exp_matrix_data WHERE field_id = 38
AND entry_id = 14226
AND is_draft = 0 ORDER BY row_order ASC
#system/user/addons/matrix/ft.matrix.php L:3059 Matrix_ft::_data_query()
-
SELECT `col_id`, `col_type`, `col_label`, `col_name`, `col_instructions`, `col_width`, `col_required`, `col_search`, `col_settings`
FROM (`exp_matrix_cols`)
WHERE `field_id` = 41
ORDER BY `col_order`
#system/user/addons/matrix/ft.matrix.php L:2984 Matrix_ft::_get_cols()
-
SELECT row_id, col_id_6, col_id_7
FROM exp_matrix_data WHERE field_id = 41
AND entry_id = 14226
AND is_draft = 0 ORDER BY row_order ASC LIMIT 100
#system/user/addons/matrix/ft.matrix.php L:3028 Matrix_ft::_data_query()
-
SELECT lasting_impressions_m_Settings_lasting_impressions.li_id as lasting_impressions_m_Settings__li_id, lasting_impressions_m_Settings_lasting_impressions.channel_id as lasting_impressions_m_Settings__channel_id, lasting_impressions_m_Settings_lasting_impressions.site_id as lasting_impressions_m_Settings__site_id, lasting_impressions_m_Settings_lasting_impressions.limit as lasting_impressions_m_Settings__limit, lasting_impressions_m_Settings_lasting_impressions.enabled as lasting_impressions_m_Settings__enabled, lasting_impressions_m_Settings_lasting_impressions.expires as lasting_impressions_m_Settings__expires
FROM (`exp_lasting_impressions` as lasting_impressions_m_Settings_lasting_impressions)
LIMIT 1
#system/ee/legacy/libraries/Template.php L:1779 Lasting_impressions::__construct()
-
SELECT *
FROM (`exp_actions`)
WHERE `class` = 'Lasting_impressions'
AND `method` = 'remove_item_from_cookie'
#system/ee/legacy/libraries/Template.php L:1779 Lasting_impressions::__construct()
-
INSERT INTO `exp_lasting_impressions_data` (`entry_id`, `member_id`, `session_id`, `ip_address`, `user_agent`, `entry_date`) VALUES ('14925', 1, 'tod9a4rg6nlv7kao9acab15n3b', '217.63.223.52', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 1765527327)
#system/user/addons/lasting_impressions/libraries/lasting_impressions_entries.php L:85 Lasting_impressions_entries::_save_to_data_table()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `entry_id` = '14226'
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 1
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT `field_settings`
FROM (`exp_channel_fields`)
WHERE `field_id` = 15
#system/user/addons/channel_images/models/channel_images_model.php L:645 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.adapter as UploadDestination__adapter, UploadDestination_upload_prefs.adapter_settings as UploadDestination__adapter_settings, 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.allow_subfolders as UploadDestination__allow_subfolders, UploadDestination_upload_prefs.subfolders_on_top as UploadDestination__subfolders_on_top, 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` = '10'
)
LIMIT 1
#system/user/addons/channel_images/locations/local/local.php L:131 CI_Location_local::getLocationPrefs()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `entry_id` = '13458'
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 1
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `entry_id` = '13346'
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 1
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `category` = 'box art'
AND `entry_id` = '14226'
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 1
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
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` = '_html-wrapper'
AND `exp_template_groups`.`group_name` = 'layouts'
#system/ee/legacy/libraries/Template.php L:228 EE_Template::fetch_template()
-
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1765527327 AND (t.expiration_date = 0 OR t.expiration_date > 1765527327) AND t.channel_id IN (4,7,13) AND t.status = 'open' ORDER BY t.sticky desc, t.view_count_one desc, t.entry_date desc, t.entry_id desc LIMIT 0, 3
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN (8105, 7027, 7890)
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN (4)
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = 8
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
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.screen_name, 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.role_id, m.member_id,
wd.*, exp_channel_data_field_57.field_id_57, exp_channel_data_field_57.field_ft_57, exp_channel_data_field_59.field_id_59, exp_channel_data_field_59.field_ft_59, exp_channel_data_field_22.field_id_22, exp_channel_data_field_22.field_ft_22, exp_channel_data_field_23.field_id_23, exp_channel_data_field_23.field_ft_23, exp_channel_data_field_24.field_id_24, exp_channel_data_field_24.field_ft_24, exp_channel_data_field_25.field_id_25, exp_channel_data_field_25.field_ft_25, exp_channel_data_field_26.field_id_26, exp_channel_data_field_26.field_ft_26, exp_channel_data_field_27.field_id_27, exp_channel_data_field_27.field_ft_27, exp_channel_data_field_28.field_id_28, exp_channel_data_field_28.field_ft_28, exp_channel_data_field_29.field_id_29, exp_channel_data_field_29.field_ft_29, exp_channel_data_field_30.field_id_30, exp_channel_data_field_30.field_ft_30, exp_channel_data_field_31.field_id_31, exp_channel_data_field_31.field_ft_31, exp_channel_data_field_33.field_id_33, exp_channel_data_field_33.field_ft_33 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_channel_data_field_57 ON t.entry_id = exp_channel_data_field_57.entry_id LEFT JOIN exp_channel_data_field_59 ON t.entry_id = exp_channel_data_field_59.entry_id LEFT JOIN exp_channel_data_field_22 ON t.entry_id = exp_channel_data_field_22.entry_id LEFT JOIN exp_channel_data_field_23 ON t.entry_id = exp_channel_data_field_23.entry_id LEFT JOIN exp_channel_data_field_24 ON t.entry_id = exp_channel_data_field_24.entry_id LEFT JOIN exp_channel_data_field_25 ON t.entry_id = exp_channel_data_field_25.entry_id LEFT JOIN exp_channel_data_field_26 ON t.entry_id = exp_channel_data_field_26.entry_id LEFT JOIN exp_channel_data_field_27 ON t.entry_id = exp_channel_data_field_27.entry_id LEFT JOIN exp_channel_data_field_28 ON t.entry_id = exp_channel_data_field_28.entry_id LEFT JOIN exp_channel_data_field_29 ON t.entry_id = exp_channel_data_field_29.entry_id LEFT JOIN exp_channel_data_field_30 ON t.entry_id = exp_channel_data_field_30.entry_id LEFT JOIN exp_channel_data_field_31 ON t.entry_id = exp_channel_data_field_31.entry_id LEFT JOIN exp_channel_data_field_33 ON t.entry_id = exp_channel_data_field_33.entry_id WHERE t.entry_id IN (8105,7027,7890)ORDER BY FIELD(t.entry_id, 8105,7027,7890)
#system/ee/legacy/libraries/Template.php L:1841 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`.`fluid_field_data_id` = 0
AND `L0`.`grid_field_id` = 0
AND `L0`.`parent_id` IN (8105, 7027, 7890)
ORDER BY `L0`.`order` asc
#system/ee/legacy/models/relationship_model.php L:38 Relationship_model::_run_node_query()
-
SELECT ChannelEntry_channel_titles.entry_id as ChannelEntry__entry_id, ChannelEntry_channel_titles.site_id as ChannelEntry__site_id, ChannelEntry_channel_titles.channel_id as ChannelEntry__channel_id, ChannelEntry_channel_titles.author_id as ChannelEntry__author_id, ChannelEntry_channel_titles.forum_topic_id as ChannelEntry__forum_topic_id, ChannelEntry_channel_titles.ip_address as ChannelEntry__ip_address, ChannelEntry_channel_titles.title as ChannelEntry__title, ChannelEntry_channel_titles.url_title as ChannelEntry__url_title, ChannelEntry_channel_titles.status as ChannelEntry__status, ChannelEntry_channel_titles.status_id as ChannelEntry__status_id, ChannelEntry_channel_titles.versioning_enabled as ChannelEntry__versioning_enabled, ChannelEntry_channel_titles.view_count_one as ChannelEntry__view_count_one, ChannelEntry_channel_titles.view_count_two as ChannelEntry__view_count_two, ChannelEntry_channel_titles.view_count_three as ChannelEntry__view_count_three, ChannelEntry_channel_titles.view_count_four as ChannelEntry__view_count_four, ChannelEntry_channel_titles.allow_comments as ChannelEntry__allow_comments, ChannelEntry_channel_titles.sticky as ChannelEntry__sticky, ChannelEntry_channel_titles.entry_date as ChannelEntry__entry_date, ChannelEntry_channel_titles.year as ChannelEntry__year, ChannelEntry_channel_titles.month as ChannelEntry__month, ChannelEntry_channel_titles.day as ChannelEntry__day, ChannelEntry_channel_titles.expiration_date as ChannelEntry__expiration_date, ChannelEntry_channel_titles.comment_expiration_date as ChannelEntry__comment_expiration_date, ChannelEntry_channel_titles.edit_date as ChannelEntry__edit_date, ChannelEntry_channel_titles.recent_comment_date as ChannelEntry__recent_comment_date, ChannelEntry_channel_titles.comment_total as ChannelEntry__comment_total, Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, Author_members.member_id as Author__member_id, Author_members.role_id as Author__role_id, Author_members.pending_role_id as Author__pending_role_id, Author_members.username as Author__username, Author_members.screen_name as Author__screen_name, Author_members.password as Author__password, Author_members.salt as Author__salt, Author_members.unique_id as Author__unique_id, Author_members.crypt_key as Author__crypt_key, Author_members.backup_mfa_code as Author__backup_mfa_code, Author_members.authcode as Author__authcode, Author_members.email as Author__email, Author_members.signature as Author__signature, Author_members.avatar_filename as Author__avatar_filename, Author_members.avatar_width as Author__avatar_width, Author_members.avatar_height as Author__avatar_height, Author_members.photo_filename as Author__photo_filename, Author_members.photo_width as Author__photo_width, Author_members.photo_height as Author__photo_height, Author_members.sig_img_filename as Author__sig_img_filename, Author_members.sig_img_width as Author__sig_img_width, Author_members.sig_img_height as Author__sig_img_height, Author_members.ignore_list as Author__ignore_list, Author_members.private_messages as Author__private_messages, Author_members.accept_messages as Author__accept_messages, Author_members.last_view_bulletins as Author__last_view_bulletins, Author_members.last_bulletin_date as Author__last_bulletin_date, Author_members.ip_address as Author__ip_address, Author_members.join_date as Author__join_date, Author_members.last_visit as Author__last_visit, Author_members.last_activity as Author__last_activity, Author_members.total_entries as Author__total_entries, Author_members.total_comments as Author__total_comments, Author_members.total_forum_topics as Author__total_forum_topics, Author_members.total_forum_posts as Author__total_forum_posts, Author_members.last_entry_date as Author__last_entry_date, Author_members.last_comment_date as Author__last_comment_date, Author_members.last_forum_post_date as Author__last_forum_post_date, Author_members.last_email_date as Author__last_email_date, Author_members.in_authorlist as Author__in_authorlist, Author_members.accept_admin_email as Author__accept_admin_email, Author_members.accept_user_email as Author__accept_user_email, Author_members.notify_by_default as Author__notify_by_default, Author_members.notify_of_pm as Author__notify_of_pm, Author_members.display_signatures as Author__display_signatures, Author_members.parse_smileys as Author__parse_smileys, Author_members.smart_notifications as Author__smart_notifications, Author_members.language as Author__language, Author_members.timezone as Author__timezone, Author_members.time_format as Author__time_format, Author_members.date_format as Author__date_format, Author_members.week_start as Author__week_start, Author_members.include_seconds as Author__include_seconds, Author_members.profile_theme as Author__profile_theme, Author_members.forum_theme as Author__forum_theme, Author_members.tracker as Author__tracker, Author_members.template_size as Author__template_size, Author_members.notepad as Author__notepad, Author_members.notepad_size as Author__notepad_size, Author_members.bookmarklets as Author__bookmarklets, Author_members.quick_links as Author__quick_links, Author_members.quick_tabs as Author__quick_tabs, Author_members.show_sidebar as Author__show_sidebar, Author_members.pmember_id as Author__pmember_id, Author_members.cp_homepage as Author__cp_homepage, Author_members.cp_homepage_channel as Author__cp_homepage_channel, Author_members.cp_homepage_custom as Author__cp_homepage_custom, Author_members.dismissed_banner as Author__dismissed_banner, Author_members.enable_mfa as Author__enable_mfa
FROM (`exp_channel_titles` as ChannelEntry_channel_titles)
LEFT JOIN `exp_channel_data` as ChannelEntry_channel_data ON `ChannelEntry_channel_data`.`entry_id` = `ChannelEntry_channel_titles`.`entry_id`
LEFT JOIN `exp_channels` AS Channel_channels ON `Channel_channels`.`channel_id` = `ChannelEntry_channel_titles`.`channel_id`
LEFT JOIN `exp_members` AS Author_members ON `Author_members`.`member_id` = `ChannelEntry_channel_titles`.`author_id`
LEFT JOIN `exp_member_data` as Author_member_data ON `Author_member_data`.`member_id` = `Author_members`.`member_id`
WHERE (
`ChannelEntry_channel_titles`.`entry_id` IN (8105, 7027, 7890, 6931, 950)
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required
FROM (`exp_channels` as Channel_channels)
WHERE (
`Channel_channels`.`channel_id` IN (5, 4)
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT exp_channel_titles.entry_id as ChannelEntry__entry_id, ChannelEntry_field_id_57.field_id_57 as ChannelEntry__field_id_57, ChannelEntry_field_id_57.field_ft_57 as ChannelEntry__field_ft_57, ChannelEntry_field_id_59.field_id_59 as ChannelEntry__field_id_59, ChannelEntry_field_id_59.field_ft_59 as ChannelEntry__field_ft_59, ChannelEntry_field_id_22.field_id_22 as ChannelEntry__field_id_22, ChannelEntry_field_id_22.field_ft_22 as ChannelEntry__field_ft_22, ChannelEntry_field_id_23.field_id_23 as ChannelEntry__field_id_23, ChannelEntry_field_id_23.field_ft_23 as ChannelEntry__field_ft_23, ChannelEntry_field_id_24.field_id_24 as ChannelEntry__field_id_24, ChannelEntry_field_id_24.field_ft_24 as ChannelEntry__field_ft_24, ChannelEntry_field_id_25.field_id_25 as ChannelEntry__field_id_25, ChannelEntry_field_id_25.field_ft_25 as ChannelEntry__field_ft_25, ChannelEntry_field_id_26.field_id_26 as ChannelEntry__field_id_26, ChannelEntry_field_id_26.field_ft_26 as ChannelEntry__field_ft_26, ChannelEntry_field_id_27.field_id_27 as ChannelEntry__field_id_27, ChannelEntry_field_id_27.field_ft_27 as ChannelEntry__field_ft_27, ChannelEntry_field_id_28.field_id_28 as ChannelEntry__field_id_28, ChannelEntry_field_id_28.field_ft_28 as ChannelEntry__field_ft_28, ChannelEntry_field_id_29.field_id_29 as ChannelEntry__field_id_29, ChannelEntry_field_id_29.field_ft_29 as ChannelEntry__field_ft_29, ChannelEntry_field_id_30.field_id_30 as ChannelEntry__field_id_30, ChannelEntry_field_id_30.field_ft_30 as ChannelEntry__field_ft_30, ChannelEntry_field_id_31.field_id_31 as ChannelEntry__field_id_31, ChannelEntry_field_id_31.field_ft_31 as ChannelEntry__field_ft_31, ChannelEntry_field_id_33.field_id_33 as ChannelEntry__field_id_33, ChannelEntry_field_id_33.field_ft_33 as ChannelEntry__field_ft_33, ChannelEntry_field_id_38.field_id_38 as ChannelEntry__field_id_38, ChannelEntry_field_id_38.field_ft_38 as ChannelEntry__field_ft_38, ChannelEntry_field_id_39.field_id_39 as ChannelEntry__field_id_39, ChannelEntry_field_id_39.field_dt_39 as ChannelEntry__field_dt_39, ChannelEntry_field_id_39.field_ft_39 as ChannelEntry__field_ft_39, ChannelEntry_field_id_42.field_id_42 as ChannelEntry__field_id_42, ChannelEntry_field_id_42.field_ft_42 as ChannelEntry__field_ft_42, ChannelEntry_field_id_10.field_id_10 as ChannelEntry__field_id_10, ChannelEntry_field_id_10.field_ft_10 as ChannelEntry__field_ft_10, ChannelEntry_field_id_11.field_id_11 as ChannelEntry__field_id_11, ChannelEntry_field_id_11.field_ft_11 as ChannelEntry__field_ft_11, ChannelEntry_field_id_12.field_id_12 as ChannelEntry__field_id_12, ChannelEntry_field_id_12.field_ft_12 as ChannelEntry__field_ft_12, ChannelEntry_field_id_13.field_id_13 as ChannelEntry__field_id_13, ChannelEntry_field_id_13.field_ft_13 as ChannelEntry__field_ft_13, ChannelEntry_field_id_14.field_id_14 as ChannelEntry__field_id_14, ChannelEntry_field_id_14.field_ft_14 as ChannelEntry__field_ft_14, ChannelEntry_field_id_15.field_id_15 as ChannelEntry__field_id_15, ChannelEntry_field_id_15.field_ft_15 as ChannelEntry__field_ft_15, ChannelEntry_field_id_21.field_id_21 as ChannelEntry__field_id_21, ChannelEntry_field_id_21.field_ft_21 as ChannelEntry__field_ft_21, ChannelEntry_field_id_32.field_id_32 as ChannelEntry__field_id_32, ChannelEntry_field_id_32.field_ft_32 as ChannelEntry__field_ft_32, ChannelEntry_field_id_40.field_id_40 as ChannelEntry__field_id_40, ChannelEntry_field_id_40.field_ft_40 as ChannelEntry__field_ft_40, ChannelEntry_field_id_41.field_id_41 as ChannelEntry__field_id_41, ChannelEntry_field_id_41.field_ft_41 as ChannelEntry__field_ft_41, ChannelEntry_field_id_48.field_id_48 as ChannelEntry__field_id_48, ChannelEntry_field_id_48.field_ft_48 as ChannelEntry__field_ft_48, ChannelEntry_field_id_49.field_id_49 as ChannelEntry__field_id_49, ChannelEntry_field_id_49.field_ft_49 as ChannelEntry__field_ft_49, ChannelEntry_field_id_54.field_id_54 as ChannelEntry__field_id_54, ChannelEntry_field_id_54.field_ft_54 as ChannelEntry__field_ft_54, ChannelEntry_field_id_55.field_id_55 as ChannelEntry__field_id_55, ChannelEntry_field_id_55.field_ft_55 as ChannelEntry__field_ft_55, ChannelEntry_field_id_56.field_id_56 as ChannelEntry__field_id_56, ChannelEntry_field_id_56.field_ft_56 as ChannelEntry__field_ft_56, ChannelEntry_field_id_58.field_id_58 as ChannelEntry__field_id_58, ChannelEntry_field_id_58.field_ft_58 as ChannelEntry__field_ft_58
FROM (`exp_channel_titles`)
LEFT JOIN `exp_channel_data_field_57` AS ChannelEntry_field_id_57 ON `ChannelEntry_field_id_57`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_59` AS ChannelEntry_field_id_59 ON `ChannelEntry_field_id_59`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_22` AS ChannelEntry_field_id_22 ON `ChannelEntry_field_id_22`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_23` AS ChannelEntry_field_id_23 ON `ChannelEntry_field_id_23`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_24` AS ChannelEntry_field_id_24 ON `ChannelEntry_field_id_24`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_25` AS ChannelEntry_field_id_25 ON `ChannelEntry_field_id_25`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_26` AS ChannelEntry_field_id_26 ON `ChannelEntry_field_id_26`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_27` AS ChannelEntry_field_id_27 ON `ChannelEntry_field_id_27`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_28` AS ChannelEntry_field_id_28 ON `ChannelEntry_field_id_28`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_29` AS ChannelEntry_field_id_29 ON `ChannelEntry_field_id_29`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_30` AS ChannelEntry_field_id_30 ON `ChannelEntry_field_id_30`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_31` AS ChannelEntry_field_id_31 ON `ChannelEntry_field_id_31`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_33` AS ChannelEntry_field_id_33 ON `ChannelEntry_field_id_33`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_38` AS ChannelEntry_field_id_38 ON `ChannelEntry_field_id_38`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_39` AS ChannelEntry_field_id_39 ON `ChannelEntry_field_id_39`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_42` AS ChannelEntry_field_id_42 ON `ChannelEntry_field_id_42`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_10` AS ChannelEntry_field_id_10 ON `ChannelEntry_field_id_10`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_11` AS ChannelEntry_field_id_11 ON `ChannelEntry_field_id_11`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_12` AS ChannelEntry_field_id_12 ON `ChannelEntry_field_id_12`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_13` AS ChannelEntry_field_id_13 ON `ChannelEntry_field_id_13`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_14` AS ChannelEntry_field_id_14 ON `ChannelEntry_field_id_14`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_15` AS ChannelEntry_field_id_15 ON `ChannelEntry_field_id_15`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_21` AS ChannelEntry_field_id_21 ON `ChannelEntry_field_id_21`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_32` AS ChannelEntry_field_id_32 ON `ChannelEntry_field_id_32`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_40` AS ChannelEntry_field_id_40 ON `ChannelEntry_field_id_40`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_41` AS ChannelEntry_field_id_41 ON `ChannelEntry_field_id_41`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_48` AS ChannelEntry_field_id_48 ON `ChannelEntry_field_id_48`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_49` AS ChannelEntry_field_id_49 ON `ChannelEntry_field_id_49`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_54` AS ChannelEntry_field_id_54 ON `ChannelEntry_field_id_54`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_55` AS ChannelEntry_field_id_55 ON `ChannelEntry_field_id_55`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_56` AS ChannelEntry_field_id_56 ON `ChannelEntry_field_id_56`.`entry_id` = `exp_channel_titles`.`entry_id`
LEFT JOIN `exp_channel_data_field_58` AS ChannelEntry_field_id_58 ON `ChannelEntry_field_id_58`.`entry_id` = `exp_channel_titles`.`entry_id`
WHERE `exp_channel_titles`.`entry_id` IN (950, 6931, 7027, 7890, 8105)
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT exp_members.member_id as Author__member_id, Author_field_id_1.m_field_id_1 as Author__m_field_id_1, Author_field_id_1.m_field_ft_1 as Author__m_field_ft_1
FROM (`exp_members`)
LEFT JOIN `exp_member_data_field_1` AS Author_field_id_1 ON `Author_field_id_1`.`member_id` = `exp_members`.`member_id`
WHERE `exp_members`.`member_id` IN (1, 1, 1, 3, 3)
#system/ee/legacy/libraries/Relationships_parser.php L:118 EE_relationship_tree_builder::get_parser()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 33
AND `entry_id` = 8105
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 33
AND `entry_id` = 6931
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 33
AND `entry_id` = 7027
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 33
AND `entry_id` = 7890
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `field_id` = 33
AND `entry_id` = 950
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 30
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT tg.tag_id, tg.tag_name, tg.hits, tg.total_entries, COUNT(tl.tag_id) as count
FROM (`exp_tagger` tg)
LEFT JOIN `exp_tagger_links` tl ON `tl`.`tag_id` = `tg`.`tag_id`
WHERE `tg`.`total_entries` > 0
GROUP BY `tg`.`tag_id`
ORDER BY `tg`.`total_entries` DESC
LIMIT 50
#system/ee/legacy/libraries/Template.php L:1841 Tagger::cloud()
-
SELECT `settings`
FROM (`exp_modules`)
WHERE `module_name` = 'Tagger'
#system/user/addons/tagger/Service/Settings.php L:25 EEHarbor\Tagger\Service\Settings::getModuleSettings()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `entry_id` = '8105'
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 1
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `entry_id` = '7027'
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 1
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
SELECT *
FROM (`exp_channel_images`)
WHERE `entry_id` = '7890'
AND `is_draft` = 0
ORDER BY `image_order` ASC
LIMIT 1
#system/user/addons/channel_images/models/channel_images_model.php L:321 Channel_images_model::get_images()
-
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/ExpressionEngine/Service/Template/Variables/StandardGlobals.php L:43 ExpressionEngine\Model\Template\GlobalVariable::loadAll()
-
SELECT action_id, class, method FROM exp_actions WHERE (class= 'Lasting_impressions' AND method = 'remove_item_from_cookie')
#system/ee/legacy/libraries/Template.php L:3334 EE_Functions::insert_action_ids()
Gyre Prime Access is Now Available in Warframe
The DLC for Digimon Story Time Stranger is Now Live