- select count(b.IdStruttura) as conteggio from Principale b inner join Provincie inner join APT left join Localita on b.IdLocalita=Localita.IdLocalita inner join LocalitaZone on (LocalitaZone.IdLocalita=Localita.IdLocalita) inner join Zone on (LocalitaZone.IdZona=Zone.IdZona) where Localita.IdProvincia=Provincie.IdProvincia AND Localita.IdAPT=APT.IdAPT and b.CodStruttura = "049017STB0010" and Zone.Mottino = 'toscana' group by b.IdStruttura