I need to realize this query in DBIx - but it's no things in newbie head how to do it... SELECT net_name, COUNT(node_id) as dev_count FROM [dbo].[networks] nw LEFT JOIN nodes nd ON nw.net_id = nd.net_id GROUP BY net_name result: net_name dev_count -------- ---------- net1 7 ---- dr.eel