SELECT  * FROM    ( SELECT  ROW_NUMBER() OVER(ORDER BY Descrizione) AS ROW, * FROM    (SELECT  System_ID,descrizione,totD,totSP,prenotati,totale,OrdineCreazioneOrdine,QtaMinimaOrdine,QtaMassimaOrdine,QtaMassimaOrdine-totale AS da_ordinare,MAX(START_DATE) AS data_ultimo, SUM(QtaOriginale) AS matricole,COUNT(start_date) AS ordini FROM ( SELECT z.System_ID, z.descrizione,COALESCE(v.totD,0) AS totD,COALESCE(v.totSP,0) AS totSP, COALESCE((v.totD+v.totSP)-prenotati,0) AS totale,COALESCE(z.OrdineCreazioneOrdine,0) AS OrdineCreazioneOrdine,COALESCE(z.QtaMinimaOrdine,0) AS QtaMinimaOrdine,COALESCE(z.QtaMassimaOrdine,0) AS QtaMassimaOrdine,z.START_DATE,COALESCE(z.QtaOriginale,0) AS QtaOriginale,z.PR,z.Cap,z.citta,z.flagFiliale,COALESCE(z.prenotati,0) AS prenotati FROM (SELECT TB_ANA_Entita.System_ID, Descrizione, OrdineCreazioneOrdine, dbo.TB_OP_MagazzinoOrdini.QtaMinimaOrdine, dbo.TB_OP_MagazzinoOrdini.QtaMassimaOrdine,dbo.VIS_LISTA_ORDINI.START_DATE ,dbo.VIS_LISTA_ORDINI.QtaOriginale,TB_ANA_Entita.PR,TB_ANA_Entita.Cap,citta,FlagFiliale,(SELECT COUNT(*) FROM tb_Prenotazioni_Filiali WHERE tb_Prenotazioni_Filiali.EntitaS_ID=TB_ANA_Entita.system_ID AND tb_Prenotazioni_Filiali.stato='APERTO' AND tb_Prenotazioni_Filiali.DataFineValidita IS NULL ) AS prenotati FROM TB_ANA_Entita LEFT OUTER JOIN TB_OP_MagazzinoOrdini ON TB_ANA_Entita.System_ID = TB_OP_MagazzinoOrdini.EntitaS_ID AND TipoModelloS_ID=9  LEFT OUTER JOIN VIS_LISTA_ORDINI ON TB_ANA_Entita.System_ID = VIS_LISTA_ORDINI.EntitaMittenteS_ID ) z LEFT JOIN (SELECT S_ID , DescSoc, SUM(totD) AS totD, SUM(totSP) AS totSP FROM (SELECT E.System_ID AS S_ID, E.Descrizione AS DescSoc, COUNT(*) AS totD, 0 AS TotSP FROM Tb_op_magazzino M INNER JOIN tb_ana_entita E ON M.EntitaAttualeS_ID = E.System_ID WHERE M.Stato = 'D' AND M.DataFineValidita IS NULL AND E.FlagFiliale = '1' GROUP BY E.System_ID, E.Descrizione, M.Stato UNION SELECT E.System_ID AS S_ID, E.Descrizione AS DescSoc,0 AS TotD, COUNT(*) AS totSP FROM Tb_op_magazzino M INNER JOIN TB_OP_Ordini O ON M.Ticket = O.CodORdine INNER JOIN tb_ana_entita E ON O.EntitaMittenteS_ID = E.System_ID WHERE M.Stato = 'SP' AND M.DataFineValidita IS NULL AND E.FlagFiliale = '1' GROUP BY E.System_ID, E.Descrizione, M.Stato )A GROUP BY S_ID, DescSoc ) v ON z.system_ID=v.S_ID ) p  WHERE    FlagFiliale = 1 GROUP BY  System_ID, Descrizione, OrdineCreazioneOrdine, QtaMinimaOrdine, QtaMassimaOrdine,totD,totSP,totale,prenotati) AS Q1  ) AS tbl WHERE ROW >CONVERT(VARCHAR(9),0) AND ROW < CONVERT(VARCHAR(9),21)
v