SELECT `Association`.`id`, `Association`.`name`, `Association`.`association_name_abbreviation`, `Association`.`address`, `Association`.`city`, `Association`.`zip`, `Association`.`country`, `Association`.`state`, `Association`.`timezone`, `Association`.`lat`, `Association`.`lng`, `Association`.`non_associated_partner_ads`, `Association`.`last_report_date`, `Association`.`phone`, `Association`.`website`, `Association`.`sponsor_code_id`, `Association`.`default_sport_id`, `Association`.`activate_button`, `Association`.`team_type`, `Association`.`league_type`, `Association`.`league_site`, `Association`.`league_size`, `Association`.`league_size_members`, `Association`.`annual_registration`, `Association`.`track_player_statistics`, `Association`.`player_statistics_are_public`, `Association`.`setup_status`, `Association`.`division_levels`, `Association`.`structure_set`, `Association`.`logo_url`, `Association`.`logo_800_url`, `Association`.`logo`, `Association`.`primary_color`, `Association`.`secondary_color`, `Association`.`league_start_date`, `Association`.`drip_message_status`, `Association`.`marketing_adgroupid`, `Association`.`marketing_keyword`, `Association`.`creation_utms`, `Association`.`creation_source`, `Association`.`language`, `Association`.`event_waiver_view`, `Association`.`signup_interest`, `Association`.`hear_about_us`, `Association`.`login_task_created`, `Association`.`second_session_started`, `Association`.`ten_minute_web_sessions`, `Association`.`wp_plugin_api_key`, `Association`.`member_count_task_created`, `Association`.`zoho_account_id`, `Association`.`zoho_status`, `Association`.`zoho_status_updated`, `Association`.`pushed_to_zoho`, `Association`.`intercom_id`, `Association`.`module_officials_enabled`, `Association`.`respect_in_sport_enabled`, `Association`.`installment_plans_enabled`, `Association`.`apparel_sales_enabled`, `Association`.`available_genders`, `Association`.`api_secret`, `Association`.`child_association_registration_sanctioning`, `Association`.`self_submit_scores`, `Association`.`zoho_lead_id`, `Association`.`zoho_deal_status`, `Association`.`zoho_size`, `Association`.`zoho_account_scoring`, `Association`.`zoho_organization_type`, `Association`.`zoho_activation_date`, `Association`.`zoho_latest_activation_date`, `Association`.`zoho_last_contact`, `Association`.`zoho_setting_up`, `Association`.`zoho_account_owner`, `Association`.`zoho_updated`, `Association`.`hubspot_company_id`, `Association`.`hubspot_account_scoring`, `Association`.`hubspot_status`, `Association`.`hubspot_owner_id`, `Association`.`hubspot_last_push`, `Association`.`hubspot_last_pull`, `Association`.`intercom_last_sync`, `Association`.`intercom_zoho_last_sync`, `Association`.`status`, `Association`.`created`, `Association`.`created_by`, `Association`.`modified`, `Association`.`modified_by`, `Sport`.`id`, `Sport`.`type`, `Sport`.`name`, `Sport`.`description`, `Sport`.`active`, `Sport`.`created`, `Sport`.`icon`, `Sport`.`sort_order`, `Sport`.`interval_label`, `Sport`.`time`, `Sport`.`score`, `Sport`.`scoreboard_type`, `Sport`.`scoreboard_name`, `Sport`.`show_score`, `Sport`.`background_image`, `Sport`.`starter_sport_position_ids`, `AssociationSiteSetting`.`id`, `AssociationSiteSetting`.`association_id`, `AssociationSiteSetting`.`home_button_page_id`, `AssociationSiteSetting`.`hide_empty_banner_content`, `AssociationSiteSetting`.`display_name`, `AssociationSiteSetting`.`site_alias`, `AssociationSiteSetting`.`contact_email`, `AssociationSiteSetting`.`team_site_rosters`, `AssociationSiteSetting`.`team_site_links`, `AssociationSiteSetting`.`primary_color`, `AssociationSiteSetting`.`header_color`, `AssociationSiteSetting`.`text_color`, `AssociationSiteSetting`.`background_color`, `AssociationSiteSetting`.`logo_image`, `AssociationSiteSetting`.`home_background_image`, `AssociationSiteSetting`.`page_background_image`, `AssociationSiteSetting`.`favicon`, `AssociationSiteSetting`.`website_template_id`, `AssociationSiteSetting`.`website_template_settings_json`, `AssociationSiteSetting`.`executive_addon_name_override`, `AssociationSiteSetting`.`facebook`, `AssociationSiteSetting`.`twitter`, `AssociationSiteSetting`.`instagram`, `AssociationSiteSetting`.`tiktok`, `AssociationSiteSetting`.`youtube`, `AssociationSiteSetting`.`linkedin`, `AssociationSiteSetting`.`theme`, `AssociationSiteSetting`.`custom_domain`, `AssociationSiteSetting`.`allow_custom_team_sites`, `AssociationSiteSetting`.`show_games_only`, `AssociationSiteSetting`.`show_twitter_feed`, `AssociationSiteSetting`.`show_facebook_feed`, `AssociationSiteSetting`.`set_custom_domain`, `AssociationSiteSetting`.`google_analytics_stream_measurement_id`, `AssociationSiteSetting`.`google_tag_manager_id`, `AssociationSiteSetting`.`site_type`, `AssociationSiteSetting`.`editor_type`, `AssociationSiteSetting`.`wordpress_url`, `AssociationSiteSetting`.`first_opened_wizard`, `AssociationSiteSetting`.`first_run_wizard`, `AssociationSiteSetting`.`step`, `AssociationSiteSetting`.`step_label`, `AssociationSiteSetting`.`status`, `AssociationSiteSetting`.`created`, `AssociationSiteSetting`.`created_by`, `AssociationSiteSetting`.`modified`, `AssociationSiteSetting`.`modified_by` FROM `teamlinkt_dev8`.`associations` AS `Association` LEFT JOIN `teamlinkt_dev8`.`sports` AS `Sport` ON (`Association`.`default_sport_id` = `Sport`.`id`) LEFT JOIN `teamlinkt_dev8`.`association_site_settings` AS `AssociationSiteSetting` ON (`AssociationSiteSetting`.`association_id` = `Association`.`id`) WHERE `AssociationSiteSetting`.`site_alias` = 'smha' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `AssociationSitePage`.`id`, `AssociationSitePage`.`association_id`, `AssociationSitePage`.`name`, `AssociationSitePage`.`link`, `AssociationSitePage`.`content`, `AssociationSitePage`.`banner_content`, `AssociationSitePage`.`is_external`, `AssociationSitePage`.`external_link`, `AssociationSitePage`.`type`, `AssociationSitePage`.`parent_page_id`, `AssociationSitePage`.`sort_order`, `AssociationSitePage`.`show_weather`, `AssociationSitePage`.`page_background_image`, `AssociationSitePage`.`included_group_instances_json`, `AssociationSitePage`.`draft_json`, `AssociationSitePage`.`draft_top_html`, `AssociationSitePage`.`draft_main_html`, `AssociationSitePage`.`draft_sidebar_html`, `AssociationSitePage`.`draft_bottom_html`, `AssociationSitePage`.`published_json`, `AssociationSitePage`.`published_top_html`, `AssociationSitePage`.`published_main_html`, `AssociationSitePage`.`published_sidebar_html`, `AssociationSitePage`.`published_bottom_html`, `AssociationSitePage`.`imported_external_page_id`, `AssociationSitePage`.`views`, `AssociationSitePage`.`iframe_views`, `AssociationSitePage`.`summary_views`, `AssociationSitePage`.`summary_iframe_views`, `AssociationSitePage`.`edit_count`, `AssociationSitePage`.`status`, `AssociationSitePage`.`created`, `AssociationSitePage`.`modified`, `AssociationSitePage`.`created_by`, `AssociationSitePage`.`modified_by` FROM `teamlinkt_dev8`.`association_site_pages` AS `AssociationSitePage` WHERE `AssociationSitePage`.`association_id` = 10 AND `AssociationSitePage`.`status` = ('visible') ORDER BY `AssociationSitePage`.`sort_order` ASC | 11 | 11 | 3 | maybe slow |
SELECT `AssociationSitePage`.`id`, `AssociationSitePage`.`association_id`, `AssociationSitePage`.`name`, `AssociationSitePage`.`link`, `AssociationSitePage`.`content`, `AssociationSitePage`.`banner_content`, `AssociationSitePage`.`is_external`, `AssociationSitePage`.`external_link`, `AssociationSitePage`.`type`, `AssociationSitePage`.`parent_page_id`, `AssociationSitePage`.`sort_order`, `AssociationSitePage`.`show_weather`, `AssociationSitePage`.`page_background_image`, `AssociationSitePage`.`included_group_instances_json`, `AssociationSitePage`.`draft_json`, `AssociationSitePage`.`draft_top_html`, `AssociationSitePage`.`draft_main_html`, `AssociationSitePage`.`draft_sidebar_html`, `AssociationSitePage`.`draft_bottom_html`, `AssociationSitePage`.`published_json`, `AssociationSitePage`.`published_top_html`, `AssociationSitePage`.`published_main_html`, `AssociationSitePage`.`published_sidebar_html`, `AssociationSitePage`.`published_bottom_html`, `AssociationSitePage`.`imported_external_page_id`, `AssociationSitePage`.`views`, `AssociationSitePage`.`iframe_views`, `AssociationSitePage`.`summary_views`, `AssociationSitePage`.`summary_iframe_views`, `AssociationSitePage`.`edit_count`, `AssociationSitePage`.`status`, `AssociationSitePage`.`created`, `AssociationSitePage`.`modified`, `AssociationSitePage`.`created_by`, `AssociationSitePage`.`modified_by` FROM `teamlinkt_dev8`.`association_site_pages` AS `AssociationSitePage` WHERE `AssociationSitePage`.`association_id` = 10 AND `AssociationSitePage`.`status` IN ('visible', 'hidden') AND LOWER(`AssociationSitePage`.`link`) = 'schedule' ORDER BY `AssociationSitePage`.`sort_order` ASC LIMIT 1 | 1 | 1 | 1 | |