SELECT        TOP (100) PERCENT T2.NumRegistraz, T2.DataRegistrazione, T1.IdDocumento, T1.IdLegameInterno, T1.NumProgrRiga, T1.RigaComponenteDb, T7.CodArt AS CodArt_mat, T7.DesArticolo, T1.DataCoperturaFab, 
                         T1.CodMagPrincipale, T1.CodAreaMagPrinc, T1.Quantita, T1.UnitaMisura, T1.RiferimentoCommessa, T3.DataInizioSched, T3.DataFineSched, T1.NumFase, T3.CodLavorazione, T4.CodRisorsaProd, T3.Stato, 
                         T1.NumPosComponente, T1.NumProgrRipartiz, T1.IdLegameInterno AS IdLegameInterno_1, CASE WHEN T1.VarianteArt = '' THEN T1.CodArt ELSE T1.CodArt + SPACE(1) + '/' + SPACE(1) + T1.VarianteArt END AS StpArticolo, 
                         CASE WHEN ISNULL(T8.VarianteArt, '') = '' THEN ISNULL(T8.CodArt, '') ELSE ISNULL(T8.CodArt, '') + SPACE(1) + '/' + SPACE(1) + ISNULL(T8.VarianteArt, '') END AS StpComposto, CASE ISNULL(T3.Stato, 0) 
                         WHEN 0 THEN 'DA PIANIFICARE' WHEN 1 THEN 'PIANIFICATA' WHEN 2 THEN 'AVVIATA IN PRODUZIONE' WHEN 3 THEN 'IN AVANZAMENTO' WHEN 4 THEN 'TERMINATA' WHEN 5 THEN 'SOSPESA' END AS DesStato, 
                         CASE WHEN ISNULL(T3.CodFornitoreTerzista, 0) <> 0 THEN CONVERT(VARCHAR(30), ISNULL(T3.CodFornitoreTerzista, 0)) + SPACE(1) + ISNULL(T6.RagSoc1, '') ELSE '' END AS DesForTer
FROM            dbo.OrdProduzRighe AS T1 WITH (NOLOCK) LEFT OUTER JOIN
                         dbo.DocElencoGen AS T2 WITH (NOLOCK) ON T2.IdDocumento = T1.IdDocumento AND T2.DBGruppo = T1.DBGruppo LEFT OUTER JOIN
                         dbo.OrdProduzRigheFasi AS T3 WITH (NOLOCK) ON T3.IdDocumento = T1.IdDocumento AND T3.IdRigaDoc = T1.IdLegameInterno AND T3.NumFase = T1.NumFase AND T3.DBGruppo = T1.DBGruppo LEFT OUTER JOIN
                         dbo.OrdProduzRisProdFase AS T4 WITH (NOLOCK) ON T4.IdDocumento = T3.IdDocumento AND T4.IdRigaDoc = T3.IdRigaDoc AND T4.IdRigaLavorazione = T3.IdRigaLavorazione AND T4.RifOrdNumProgrRiga = 1.00 AND 
                         T4.DBGruppo = T3.DBGruppo LEFT OUTER JOIN
                         dbo.ClientiFornitori AS T5 WITH (NOLOCK) ON T5.TipoAnagrafica = 2 AND T5.CodCliFor = T3.CodFornitoreTerzista AND T5.DBGruppo = T3.DBGruppo LEFT OUTER JOIN
                         dbo.AnagrGenIndirizzi AS T6 WITH (NOLOCK) ON T6.IdAnagGen = T5.IdAnagGen AND T6.NumProgr = 0 LEFT OUTER JOIN
                         dbo.EARANQVAR AS T7 WITH (NOLOCK) ON T7.CodArt = T1.CodArt AND T7.VarianteArt = T1.VarianteArt AND T7.DBGruppo = T1.DBGruppo LEFT OUTER JOIN
                         dbo.OrdProduzRighe AS T8 WITH (NOLOCK) ON T8.IdDocumento = T1.IdDocumento AND T8.IdRiga = T1.IdLegameInterno AND T8.RigaComponenteDb = 0 AND T8.DBGruppo = T1.DBGruppo
WHERE        (T1.RigaComponenteDb = 1) AND (1 = 1) AND (ISNULL(T2.CodTipoDoc, 0) BETWEEN 0 AND 999) AND (ISNULL(T2.PeriodoRifNumeraz, 0.00) BETWEEN 0.00 AND 999999.00) AND (ISNULL(T2.CodSerie, 0) BETWEEN 0 AND 
                         99999) AND (T1.DataInizioProd BETWEEN CONVERT(DATETIME, '1800-01-01', 102) AND CONVERT(DATETIME, '2099-12-31', 102)) AND (T1.DataTermine BETWEEN CONVERT(DATETIME, '1800-01-01', 102) AND 
                         CONVERT(DATETIME, '2099-12-31', 102)) AND (ISNULL(T8.CodArt, '') BETWEEN '' AND 'zzzzzzzzzzzzzzzzzzzzzzzzz') AND (ISNULL(T8.VarianteArt, '') BETWEEN '' AND 
                         'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz') AND (ISNULL(T8.CodMagPrincipale, '') BETWEEN '' AND 'zzzz') AND (T1.RiferimentoCommessa BETWEEN '' AND 'zzzzzzzzzzzzzzz') AND (T1.CodArt BETWEEN 
                         '' AND 'zzzzzzzzzzzzzzzzzzzzzzzzz') AND (T1.VarianteArt BETWEEN '' AND 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz') AND (T1.CodMagPrincipale BETWEEN '' AND 'zzzz') AND 
                         (ISNULL(T4.CodRisorsaProd, '') BETWEEN '' AND 'zzzzzzzzzzzzzzzzzzzzzzzzz') AND (ISNULL(T3.CodLavorazione, '') = 'A01') AND (ISNULL(T3.CodFornitoreTerzista, 0) BETWEEN 0 AND 99999999) AND (ISNULL(T3.Stato, 0) 
                         BETWEEN 0 AND 2) AND (T1.DBGruppo = 'NT') AND (ISNULL(T2.DataRegistrazione, CONVERT(DATETIME, '1800-01-01', 102)) BETWEEN CONVERT(DATETIME, '1800-01-01', 102) AND CONVERT(DATETIME, '2099-12-31', 102)) OR
                         (T1.RigaComponenteDb = 1) AND (ISNULL(T2.CodTipoDoc, 0) BETWEEN 0 AND 999) AND (ISNULL(T2.PeriodoRifNumeraz, 0.00) BETWEEN 0.00 AND 999999.00) AND (ISNULL(T2.CodSerie, 0) BETWEEN 0 AND 99999) AND 
                         (T1.DataInizioProd BETWEEN CONVERT(DATETIME, '1800-01-01', 102) AND CONVERT(DATETIME, '2099-12-31', 102)) AND (T1.DataTermine BETWEEN CONVERT(DATETIME, '1800-01-01', 102) AND CONVERT(DATETIME, 
                         '2099-12-31', 102)) AND (ISNULL(T8.CodArt, '') BETWEEN '' AND 'zzzzzzzzzzzzzzzzzzzzzzzzz') AND (ISNULL(T8.VarianteArt, '') BETWEEN '' AND 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz') AND 
                         (ISNULL(T8.CodMagPrincipale, '') BETWEEN '' AND 'zzzz') AND (T1.RiferimentoCommessa BETWEEN '' AND 'zzzzzzzzzzzzzzz') AND (T1.CodArt BETWEEN '' AND 'zzzzzzzzzzzzzzzzzzzzzzzzz') AND 
                         (T1.VarianteArt BETWEEN '' AND 'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz') AND (T1.CodMagPrincipale BETWEEN '' AND 'zzzz') AND (ISNULL(T4.CodRisorsaProd, '') BETWEEN '' AND 
                         'zzzzzzzzzzzzzzzzzzzzzzzzz') AND (ISNULL(T3.CodLavorazione, '') = 'PRP1') AND (ISNULL(T3.CodFornitoreTerzista, 0) BETWEEN 0 AND 99999999) AND (ISNULL(T3.Stato, 0) BETWEEN 0 AND 2) AND 
                         (ISNULL(T2.DataRegistrazione, CONVERT(DATETIME, '1800-01-01', 102)) BETWEEN CONVERT(DATETIME, '1800-01-01', 102) AND CONVERT(DATETIME, '2099-12-31', 102)) AND (T1.NumFase > 0.00)
ORDER BY StpArticolo, T1.DataCoperturaFab, LEFT(CONVERT(VARCHAR(30), ISNULL(T2.PeriodoRifNumeraz, 0.00)), 4) + '.' + CONVERT(VARCHAR(30), ISNULL(T2.CodSerie, 0)) + '.' + CONVERT(VARCHAR(30), ISNULL(T2.NumRegistraz, 0)) 
                         + SPACE(1) + REPLACE(CONVERT(VARCHAR(30), T1.NumProgrRiga), '.', ',')