SELECT T0.data, ( SELECT TTO1.IdCampo, TTO1.pathOggetto, TTO1.numFoto, TTO1.layoutType, TT1.Testo FROM TBLContent TC LEFT JOIN TBLAssociaOggetti TTO1 ON TTO1.idArea = 66 AND TTO1.tipoOggetto < 3 AND TTO1.idCampo = TC.id AND TTO1.numFoto <= 3 LEFT JOIN TBLTestiOggetti TT1 ON TT1.idArea = TT1.idArea AND TT1.idCampo = TC.id AND TT1.progressivo = TTO1.progressivo AND TT1.Lingua = 01 AND TT1.Attiva = 1 WHERE TC.Id = T0.Id AND GETDATE() BETWEEN ISNULL(TC.visibleFromDate, GetDate()) AND ISNULL(TC.visibleToDate, GetDate()) ORDER BY TTO1.numFoto, TTO1.layoutType for xml path('content'), root ('root') ) AS Images,T0.id, dbo.getSEOUrlByContentId(T0.Id, 'IT', T1.testo, '/it/') AS SEOURL, T0.ERPLevel, T0.ERPCode, T0.ERPParentCode,T0.showData,T0.idPadre,T0.pageName,T1.testo As titolo,TTA.testo AS abstract FROM TBLContent T0 INNER JOIN TBLTesti T1 ON T1.idArea = 66 AND T1.idTipoTesto = 6 AND T1.idCampo = T0.id AND T1.idLingua = 01 AND T1.attiva = 1 LEFT JOIN TBLTesti TTA ON TTA.idArea = 66 AND TTA.idTipoTesto = 8 AND TTA.idCampo = T0.id AND TTA.idLingua = 01 WHERE 1 = 1 AND T0.id = 06668 AND GETDATE() BETWEEN ISNULL(T0.visibleFromDate, GetDate()) AND ISNULL(T0.visibleToDate, GetDate()) AND T0.sospendi<>1 ORDER BY T0.ordina,T0.data desc