vlan_test {

    if (&User-Name =~ /.+@(.+)/) {

        update control {
            Tmp-String-0 := "%{1}"
        }

        update reply {
            Tunnel-Type := VLAN
            Tunnel-Medium-Type := IEEE-802
            Tunnel-Private-Group-Id := "%{sql:SELECT vlan_id FROM tenant_subnets WHERE tenant_id='%{control:Tmp-String-0}'}"
        }
    }
}