Error en la sentencia SELECT DISTINCT sh.cedula cedulas, sh.nombres nombress, sh.apellidos apellidoss, sh.direccion direccions, 
        sh.telefono telefonos, sh.movil movils,
        net.cedula cedulan,ifnull( net.nombres,'') nombresn,ifnull( net.apellidos,'') apellidosn, net.gerente, ci.id as ciclo_id, ci.nombre, ca.numero, net.id as netid, ifnull( ger.id,0) gerid,
       ifnull( ger.cedula,'') cedulag,ifnull( ger.nombres,'') nombresg,ifnull( ger.apellidos,'') apellidosg,
        ifnull(p.valor,0) as cobrado, ifnull(s.pedido,0) + ifnull(dfd.pedido,0) as pedido, 
        ifnull(s.facturado,0) - ifnull(aj.diferencia,0) as facturado, 
        ifnull(dev.valor,0) as saldos, ifnull(z.facturado,0) as bazar, ifnull(z.pedido,0) as pedidobazar, 
        (em.descuento/100) as descuento, ifnull(dfd.facturado,0) as facturadodesc, ifnull(resta.valor,0) as devoluciones,
        d.nombre poblacion, d.grupo grupo, sh.pais_id as pais, sh.id as shid
        FROM pedido pd    
        INNER JOIN paisembarque e ON pd.paisembarque_id = e.id
        INNER JOIN embarque em ON em.id = e.embarque_id 
        INNER JOIN shopper sh ON sh.id = pd.shopper_id 
        INNER JOIN networker net ON net.id = sh.networker_id 
        INNER JOIN ciclo ci ON ci.id = pd.ciclo_id
        INNER JOIN campana ca ON ca.id = ci.campana_id
        inner join departamento d on d.id=sh.departamento_id
        LEFT JOIN networker ger ON ger.id = sh.gerentezona_id
        LEFT JOIN digitadofacturado s ON s.paisembarque_id = pd.paisembarque_id AND pd.shopper_id = s.shopper_id
        LEFT JOIN digitadofacturadobazar z ON z.paisembarque_id = pd.paisembarque_id AND pd.shopper_id = z.shopper_id
        LEFT JOIN digitadofacturadodescuento dfd ON dfd.paisembarque_id = pd.paisembarque_id AND pd.shopper_id = dfd.shopper_id
        LEFT JOIN ajusteregla aj ON pd.id = aj.pedido
        LEFT JOIN (SELECT shopper_id, ciclo_id, SUM(valor) as valor FROM pago WHERE tipo = 'ABONO' GROUP BY shopper_id, ciclo_id ) AS p ON p.ciclo_id = pd.ciclo_id AND p.shopper_id = pd.shopper_id
        LEFT JOIN (SELECT shopper_id, ciclo_id, SUM(valor) as valor FROM pago WHERE tipo != 'ABONO' GROUP BY shopper_id, ciclo_id ) AS dev ON dev.ciclo_id = pd.ciclo_id AND dev.shopper_id = pd.shopper_id 
        LEFT JOIN (SELECT pago.shopper_id, pago.ciclo_id, SUM(pago.valor) as valor 
        FROM pago INNER JOIN cambio ON cambio.id = pago.cambio_id WHERE cambio.tipo = 'DV' 
        GROUP BY pago.shopper_id, pago.ciclo_id) AS resta ON resta.ciclo_id = pd.ciclo_id 
        AND resta.shopper_id = pd.shopper_id 
        WHERE sh.pais_id=1 AND sh.id NOT IN (1,2,6,8)