SELECT
  `cc`.`unique_id`,
  `cc`.`name`,
  `cc`.`display_name`,
  `cc`.`sanitized_name`,
  `cc`.`source`,
  `cc`.`description`,
  `cc`.`settings`,
  `cc`.`config`,
  `cc`.`contact_addressbook`,
  `cc`.`contact_groupname`,
  `cc`.`creation`,
  `cc_wn`.`circle_id` AS `cc_wn_circle_id`,
  `cc_wn`.`member_id` AS `cc_wn_member_id`,
  `cc_wn`.`single_id` AS `cc_wn_single_id`,
  `cc_wn`.`user_id` AS `cc_wn_user_id`,
  `cc_wn`.`instance` AS `cc_wn_instance`,
  `cc_wn`.`user_type` AS `cc_wn_user_type`,
  `cc_wn`.`level` AS `cc_wn_level`,
  `cc_wn`.`status` AS `cc_wn_status`,
  `cc_wn`.`note` AS `cc_wn_note`,
  `cc_wn`.`contact_id` AS `cc_wn_contact_id`,
  `cc_wn`.`cached_name` AS `cc_wn_cached_name`,
  `cc_wn`.`cached_update` AS `cc_wn_cached_update`,
  `cc_wn`.`contact_meta` AS `cc_wn_contact_meta`,
  `cc_wn`.`joined` AS `cc_wn_joined`,
  `cc_wn_on`.`unique_id` AS `cc_wn_on_unique_id`,
  `cc_wn_on`.`name` AS `cc_wn_on_name`,
  `cc_wn_on`.