WALLRACK

SELECT T2.Id as Id, T2.Ordina, T3.Testo AS Label, T1.Testo AS Valore FROM TBLAttributiContent T0 INNER JOIN TBLContent TC ON TC.Id = T0.IdContent INNER JOIN TBLTesti T1 ON T1.idArea = 66 AND T1.IdTipoTesto = 67 AND T1.IdCampo = T0.Id AND T1.IdLingua = 01 INNER JOIN TBLAttributi T2 ON T2.Id = T0.IdAttributo INNER JOIN TBLTesti T3 ON T3.idArea = 66 AND T3.IdTipoTesto = 66 AND T3.IdCampo = T2.Id AND T3.IdLingua = 01 WHERE T2.Deleted <> 1 AND T0.IdContent IN (22085) AND T2.ShowOnWebsite = 1 AND ISNULL(RTRIM(T1.Testo),'') <> '' ORDER BY T2.Ordina, T2.Id, TC.ordina, TC.data desc, TC.Id