postgresql7.1 select l.link_id, l.url, count(c.link_id) as clicks from mail_links l inner join mail_link_mail_map m using (link_id) left outer join mail_link_clicks c using (mail_id, link_id) where m.mail_id = :mail_job_id group by l.link_id, l.url