Русскоязычный форум, посвященный фреймворку Kohana

select a.*, ifnull(count(b.id),0) as count_logo, ifnull(sum(c.cnt_ip),0) as all_views_logos
from users a
left join logo b
  on a.id=b.id_user
left join (select count(ip) as cnt_ip, logo_id from logo_views group by logo_id) c
  on b.id=c.logo_id
group by a.id