mysql> select c.id AS ID, c.title AS NUM, count(r.id) AS RANGES, sum(r.addr2-r.addr1+1) as IP_COUNT from contract as c left outer join ipn_user_range_1 as r on (r.cid = c.id) group by ID, NUM;
+-----+---------------------+--------+------------+
| ID  | NUM                 | RANGES | IP_COUNT   |
+-----+---------------------+--------+------------+
|   1 | 5072                |      2 |         12 |
|   2 | 5122                |      1 |          8 |
|   3 | 5022                |      1 |          8 |
|   4 | 5077                |      2 |         12 |