1
select `civicrm`.`civicrm_group`.`id` AS `id`,`civicrm`.`civicrm_group`.`name` AS `name`,`civicrm`.`civicrm_group`.`description` AS `description`,`civicrm`.`civicrm_group`.`source` AS `source`,`civicrm`.`civicrm_group`.`saved_search_id` AS `saved_search_id`,`civicrm`.`civicrm_group`.`is_active` AS `is_active`,`civicrm`.`civicrm_group`.`visibility` AS `visibility`,`civicrm`.`civicrm_group`.`where_clause` AS `where_clause`,`civicrm`.`civicrm_group`.`select_tables` AS `select_tables`,`civicrm`.`civicrm_group`.`where_tables` AS `where_tables`,`civicrm`.`civicrm_group`.`group_type` AS `group_type`,`civicrm`.`civicrm_group`.`cache_date` AS `cache_date`,`civicrm`.`civicrm_group`.`refresh_date` AS `refresh_date`,`civicrm`.`civicrm_group`.`parents` AS `parents`,`civicrm`.`civicrm_group`.`children` AS `children`,`civicrm`.`civicrm_group`.`is_hidden` AS `is_hidden`,`civicrm`.`civicrm_group`.`is_reserved` AS `is_reserved`,`civicrm`.`civicrm_group`.`created_id` AS `created_id`,`civicrm`.`civicrm_group`.`modified_id` AS `modified_id`,`civicrm`.`civicrm_group`.`title_fr_CA` AS `title` from `civicrm`.`civicrm_group`