Comment 2 for bug 399964

From Stuart:

SELECT COUNT (*)
FROM (
  SELECT Person.*
  FROM Person
  LEFT OUTER JOIN (
      SELECT DISTINCT EmailAddress.person
      FROM EmailAddress
      WHERE lower(EmailAddress.email) LIKE 'john%')
      AS EmailAddress ON Person.id = EmailAddress.person
  WHERE
      Person.teamowner IS NOT NULL
      AND Person.visibility IN (1, 30)
      AND (
          EmailAddress.person IS NOT NULL
          OR Person.fti @@ ftq('john'))
  ORDER BY displayname, name
  LIMIT 100) AS whatever