SELECT COUNT(DISTINCT "cvwo_people"."id") FROM "cvwo_people"
INNER JOIN "lions_people" ON "lions_people"."cvwo_person_id" = "cvwo_people"."id"
INNER JOIN "lions_people_region_profiles" ON "lions_people_region_profiles"."person_id" = "lions_people"."id"
INNER JOIN "lions_people" "lions_people_cvwo_people" ON "lions_people_cvwo_people"."cvwo_person_id" = "cvwo_people"."id"

LEFT OUTER JOIN "cvwo_people_contacts" ON "cvwo_people_contacts"."person_id" = "cvwo_people"."id"
LEFT OUTER JOIN "cvwo_contacts" ON "cvwo_contacts"."id" = "cvwo_people_contacts"."contact_id" AND "cvwo_contacts"."deleted_at" IS NULL
LEFT OUTER JOIN "lions_regions" ON "lions_regions"."id" = "lions_people_region_profiles"."region_id"
LEFT OUTER JOIN "lions_befriendees_living_conditions" ON "lions_befriendees_living_conditions"."cvwo_person_id" = "cvwo_people"."id"
LEFT OUTER JOIN "lions_befriendees_vulnerability_healths" ON "lions_befriendees_vulnerability_healths"."cvwo_person_id" = "cvwo_people"."id"
LEFT OUTER JOIN "cvwo_people_addresses" ON "cvwo_people_addresses"."person_id" = "cvwo_people"."id" AND "cvwo_people_addresses"."is_primary" = $1
LEFT OUTER JOIN "cvwo_addresses" ON "cvwo_addresses"."id" = "cvwo_people_addresses"."address_id" AND "cvwo_addresses"."deleted_at" IS NULL
LEFT OUTER JOIN "lions_people" "lions_people_cvwo_people_join" ON "lions_people_cvwo_people_join"."cvwo_person_id" = "cvwo_people"."id"
LEFT OUTER JOIN "lions_people_region_profiles" "people_region_profiles_cvwo_people_join" ON "people_region_profiles_cvwo_people_join"."person_id" = "lions_people_cvwo_people_join"."id"
LEFT OUTER JOIN "lions_people_case_histories" ON "lions_people_case_histories"."people_region_profile_id" = "people_region_profiles_cvwo_people_join"."id"
    AND (lions_people_case_histories.case_change_type = 3)
WHERE "cvwo_people"."deleted_at" IS NULL
AND "lions_people"."actable_type" IN ('Admin::Befriendee', 'Admin::CentreBefriendee')
AND "lions_people_region_profiles"."region_id" IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39)
AND "lions_people_cvwo_people"."actable_type" IN ('Admin::Befriender', 'Admin::Befriendee')
AND "cvwo_people"."id" IN (
    SELECT "lions_people"."cvwo_person_id" FROM "lions_people" WHERE "lions_people"."id" IN (
        SELECT "lions_people_region_profiles"."person_id" FROM "lions_people_region_profiles" WHERE "lions_people_region_profiles"."is_active" = $2)
    )
AND "cvwo_people"."id" IN (
    SELECT "lions_people"."cvwo_person_id" FROM "lions_people" WHERE "lions_people"."id" IN (
        SELECT "lions_people_region_profiles"."person_id" FROM "lions_people_region_profiles" WHERE "lions_people_region_profiles"."id" IN (
            SELECT "lions_people_case_histories"."people_region_profile_id" FROM "lions_people_case_histories"
            WHERE (lions_people_case_histories.case_change_type = 3))))
AND ((("cvwo_people"."name" ILIKE '%%' OR "cvwo_people"."identity_document" ILIKE '%%') OR "cvwo_contacts"."value" ILIKE '%%') OR exists(SELECT "lions_people_region_profiles".* FROM "lions_people_region_profiles" INNER JOIN "lions_people" ON "lions_people"."id" = "lions_people_region_profiles"."person_id" INNER JOIN "lions_regions" ON "lions_regions"."id" = "lions_people_region_profiles"."region_id" WHERE ("lions_people"."cvwo_person_id" = "cvwo_people"."id" AND "lions_regions"."zone_code" ILIKE '%%')))