pedidos

SELECT
  Cliente.completo AS cliente,
  Cliente.codigo AS codigo,
  Cliente.direccion AS direccionCliente,
  Cliente.gps AS gpsCliente,
  Cliente.diaRecorrido AS diaRecorridoCliente,
  Pedido.*,
  0 AS renglones
FROM [staJDC].[dbo].Pedido AS Pedido
LEFT JOIN [staJDC].[dbo].MobileClientes AS Cliente
  ON Cliente.numintCliente = Pedido.clienteId
  AND Cliente.numintComercio = Pedido.comercioId
INNER JOIN (
  SELECT DISTINCT Renglon.pedidoId
  FROM [staJDC].[dbo].PedidoProducto AS Renglon
  INNER JOIN [staJDC].[dbo].PRDProductos AS Producto
    ON Producto.numint = Renglon.productoId
  INNER JOIN [staJDC].[dbo].SDPrsClientes AS Proveedor
    ON Proveedor.numint = Producto.PRVLink
    AND Proveedor.numint = 6360
  INNER JOIN [staJDC].[dbo].PRDRubros AS Rubro
    ON Rubro.numint = Producto.SubRubro
) Renglon
  ON Renglon.pedidoId = Pedido.id
WHERE
  Cliente.codigo IS NOT NULL
  AND CONVERT(DATETIME, Pedido.fecha, 120)
    BETWEEN CONVERT(DATETIME, '2018-01-22 00:00:00', 120)
    AND CONVERT(DATETIME, '2018-01-23 23:59:59', 120)
ORDER BY CONVERT(DATETIME, Pedido.fecha, 120) DESC