test.sql

SELECT orco_pk_id, orco_fk_cuclapre, (orco_iva + orco_impespecifico + orco_total) AS total_orden,
(
    SELECT COUNT(*) FROM orden WHERE deor_fk_orco = orco_pk_id
) AS pagos, 
COALESCE(
    (SELECT SUM(deor_cantidad*deor_preciounitario-deor_descuento) AS total 
    FROM detalleorden 
    WHERE deor_fk_orco = orco_pk_id), 0
) AS total_detalle 
FROM `ordencompra` 
WHERE orco_fk_estado NOT IN (6,7) AND orco_fecha REGEXP '2014-01' LIMIT 2000