select
    srvq.server_id,
    srvq.server_ip,
    srvq.server_name,
    count(srvq.value) as nr_vlanuri from
(select
    pppoebuc.pppoe_servers.server_id,
    pppoebuc.pppoe_servers.server_ip,
    pppoebuc.pppoe_servers.server_name,
    pppoe_config.config_multiple_values.tag_id,
   pppoe_config. config_multiple_values.value
    from pppoe_servers
inner join pppoe_config.config_multiple_values
    on pppoe_config.config_multiple_values.server_id=pppoebuc.pppoe_servers.server_id
where zona_id=1610 and tag_id=4) as srvq
group by
    srvq.server_id,
    srvq.server_ip,
    srvq.server_name,
    srvq.tag_id;