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 = 015 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, 'EN', T1.testo, '/en/') 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 = 015 AND T1.attiva = 1 LEFT JOIN TBLTesti TTA ON TTA.idArea = 66 AND TTA.idTipoTesto = 8 AND TTA.idCampo = T0.id AND TTA.idLingua = 015 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
12/25/2017
I am 100x100 Xmas

Every day we put our soul and our passion to give you solutions, ideas, inspirations and answers that are up to your aspettiative and maybe something more.
At Christmas we also put on our face.
Best wishes from all of us at Skema.