clientes.sql

select fancy_name, (select name from cities where id = persons.addr_city_id) as city, addr_uf, 
(select count(*) from ctes where owner_id = persons.id and created_at >= '2015-06-01 00:00:00') as ctes, 
(select count(*) from incomes where owner_id = persons.id and created_at >= '2015-06-01 00:00:00') as incomes 
from persons 
where owner_id is null
and ((select count(*) from ctes where owner_id = persons.id and created_at >= '2015-06-01 00:00:00') > 0
or (select count(*) from incomes where owner_id = persons.id and created_at >= '2015-06-01 00:00:00') > 0);