SELECT * FROM 4am_comsysn.ageperso RIGHT JOIN (SELECT 4am_traficon.ts_horas.coduser,
            COUNT(DISTINCT 4am_traficon.ts_horas.codorden) AS orden,
            COUNT( 4am_traficon.ts_horas.corre) AS core,
            SUM( 4am_traficon.ts_horas.tothoras) AS horas, 4am_traficon.ts_horas.fecha
        FROM 4am_traficon.ts_horas
        GROUP BY 4am_traficon.ts_horas.coduser) tt_ts_horas ON 4am_comsysn.ageperso.codper = tt_ts_horas.coduser;