4 | SELECT `CoSetting`.`id`, `CoSetting`.`co_id`, `CoSetting`.`enable_nsf_demo`, `CoSetting`.`disable_expiration`, `CoSetting`.`disable_ois_sync`, `CoSetting`.`group_validity_sync_window`, `CoSetting`.`garbage_collection_interval`, `CoSetting`.`enable_normalization`, `CoSetting`.`enable_empty_cou`, `CoSetting`.`invitation_validity`, `CoSetting`.`permitted_fields_name`, `CoSetting`.`required_fields_addr`, `CoSetting`.`required_fields_name`, `CoSetting`.`t_and_c_login_mode`, `CoSetting`.`sponsor_eligibility`, `CoSetting`.`theme_stacking`, `CoSetting`.`sponsor_co_group_id`, `CoSetting`.`default_co_pipeline_id`, `CoSetting`.`elect_strategy_primary_name`, `CoSetting`.`co_dashboard_id`, `CoSetting`.`co_theme_id`, `CoSetting`.`global_search_limit`, `CoSetting`.`created`, `CoSetting`.`modified`, `CoSetting`.`group_create_admin_only`, `CoSetting`.`person_picker_email_type`, `CoSetting`.`person_picker_identifier_type`, `CoSetting`.`person_picker_display_types`, `CoTheme`.`id`, `CoTheme`.`co_id`, `CoTheme`.`name`, `CoTheme`.`hide_title`, `CoTheme`.`hide_footer_logo`, `CoTheme`.`css`, `CoTheme`.`header`, `CoTheme`.`footer`, `CoTheme`.`created`, `CoTheme`.`modified`, `CoTheme`.`co_theme_id`, `CoTheme`.`revision`, `CoTheme`.`deleted`, `CoTheme`.`actor_identifier` FROM `access_registry_dev`.`cm_co_settings` AS `CoSetting` LEFT JOIN `access_registry_dev`.`cm_co_themes` AS `CoTheme` ON (`CoSetting`.`co_theme_id` = `CoTheme`.`id`) INNER JOIN `access_registry_dev`.`cm_cos` AS `Co` ON (`CoSetting`.`co_id`=`Co`.`id`) WHERE `Co`.`name` = 'COmanage' AND `Co`.`status` = 'A' LIMIT 1 | | 1 | 1 | 1 |