SELECT  p.NumeroPedido, cp.SortOrder + 1 AS Poz,  cp.Concepto ,d.Codigo, CONVERT(VARCHAR,d.Descripcion) as Descripcion, d.Texto, cp.Cantidad, ord = 0
FROM    EstadoSubModelosPAF AS esmp INNER JOIN
                         ContenidoPAF AS cp ON cp.Numero = esmp.Numero AND cp.Version = esmp.Version AND cp.Orden = esmp.Orden INNER JOIN
                         PAF AS p ON cp.Numero = p.Numero AND cp.Version = p.Version INNER JOIN
                         Dibujos as d ON cp.Concepto = d.Codigo
WHERE        (esmp.ProductionLot = '18071')
union all
SELECT  distinct p.NumeroPedido,  Poz = null,  Concepto = null... , ord = 1
FROM    EstadoSubModelosPAF AS esmp INNER JOIN
                         ContenidoPAF AS cp ON cp.Numero = esmp.Numero AND cp.Version = esmp.Version AND cp.Orden = esmp.Orden INNER JOIN
                         PAF AS p ON cp.Numero = p.Numero AND cp.Version = p.Version INNER JOIN
                         Dibujos as d ON cp.Concepto = d.Codigo
WHERE        (esmp.ProductionLot = '18071')
order by NumeroPedido, ord;