select device.id, count(distinct host_links.host_link_id) as cnt from
 device
 inner join host_links on device.id=host_links.device_id
 group by device.id;