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
From Stuart:
SELECT COUNT (*) ess.email) LIKE 'john%') teamowner IS NOT NULL
EmailAddress .person IS NOT NULL
FROM (
SELECT Person.*
FROM Person
LEFT OUTER JOIN (
SELECT DISTINCT EmailAddress.person
FROM EmailAddress
WHERE lower(EmailAddr
AS EmailAddress ON Person.id = EmailAddress.person
WHERE
Person.
AND Person.visibility IN (1, 30)
AND (
OR Person.fti @@ ftq('john'))
ORDER BY displayname, name
LIMIT 100) AS whatever