SELECT DISTINCT T0.data, ( SELECT DISTINCT * FROM ( SELECT DISTINCT TAss.idContentAssociated AS Id, TC.IdPadre FROM TBLAssociaContentContent TAss INNER JOIN TBLContent TC ON TC.Id = TAss.idContentAssociated AND TAss.idContent = T0.Id AND TAss.colonna = 'NN' UNION ALL SELECT DISTINCT TAss.idContent AS Id, TC.IdPadre FROM TBLAssociaContentContent TAss INNER JOIN TBLContent TC ON TC.Id = TAss.idContent AND TAss.idContentAssociated = T0.Id AND TAss.colonna = 'NN' ) TAssAll FOR XML path('content'), root('root')) AS AssociatedContents,T0.TextDark,T0.ordina, T0.Colore,T0.id,T0.showData,T0.idPadre,T0.pageName,T1.testo As titolo,TTS.testo AS Slogan,TTA.testo AS abstract,'' descrizione,TTO1.pathOggetto AS foto1,TTO2.pathOggetto AS foto2,TTO3.pathOggetto AS foto3,TT1.testo AS foto1txt,TT2.testo AS foto2txt,TT3.testo AS foto3txt 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 LEFT JOIN TBLTesti TTS ON TTS.idArea = 66 AND TTS.idTipoTesto = 60 AND TTS.idCampo = T0.id AND TTS.idLingua = 01 LEFT JOIN TBLAssociaOggetti TTO1 ON TTO1.idArea = 66 AND TTO1.tipoOggetto IN (1,2) AND TTO1.idCampo = T0.id AND TTO1.numFoto = 1 AND TTO1.Ordina < 2 LEFT JOIN TBLTestiOggetti TT1 ON TT1.idArea = TTO1.idArea AND TT1.idCampo = T0.id AND TT1.progressivo = TTO1.progressivo AND TT1.Lingua = 01 LEFT JOIN TBLAssociaOggetti TTO2 ON TTO2.idArea = 66 AND TTO2.tipoOggetto IN (1,2) AND TTO2.idCampo = T0.id AND TTO2.numFoto = 2 AND TTO2.Ordina < 2 LEFT JOIN TBLTestiOggetti TT2 ON TT2.idArea = TTO2.idArea AND TT2.idCampo = T0.id AND TT2.progressivo = TTO2.progressivo AND TT2.Lingua = 01 LEFT JOIN TBLAssociaOggetti TTO3 ON TTO3.idArea = 66 AND TTO3.tipoOggetto IN (1,2) AND TTO3.idCampo = T0.id AND TTO3.numFoto = 3 AND TTO3.Ordina < 2 LEFT JOIN TBLTestiOggetti TT3 ON TT3.idArea = TTO3.idArea AND TT3.idCampo = T0.id AND TT3.progressivo = TTO3.progressivo AND TT3.Lingua = 01 INNER JOIN TBLContent TP ON TP.Id = T0.IdPadre WHERE T0.idPadre = 0680 AND T0.sospendi<>1 AND TP.Sospendi <> 1 ORDER BY T0.ordina,T0.data desc