follower_count.sql

select 
count(*) as follower_count,
c1.created_at, 
c1.vk_name,
concat('https://vk.com/club', c1.vk_id) AS url
from follower
inner join follower_club on follower_club.follower_id=follower.id
inner join club c1 on follower_club.club_id=c1.id
where exists(
select * from message 
inner join stage on message.stage_id=stage.id
inner join funnel on stage.funnel_id=funnel.id
inner join club c2 on funnel.club_id=c2.id
where 
(funnel.deleted=0)
and (stage.deleted=0)
and (c2.deleted=0)
and (c2.id=c1.id)
and (message.follower_id=follower.id)
)
group by c1.id
order by follower_count DESC