I have this mysql query with the intention of joining in a single table the result of 5 queries, but in the final result only the result of the first select appears, the rest goes to zero, and does not give any error
select t.a, t.normals, t.sumneto, t.sumdto, t.vtamedia,
t.garantia, t.sumnetgar, t.sumdtogar, t.vtamediagar,
t.errores, t.sumneterr, t.sumdtoerr, t.vtamediaerr,
t.reparacions, t.sumnetrep, t.sumdtorep, t.vtamediarep,
t.promo1, t.sumnetpromo1, t.sumdtopromo1, t.vtamediapromo1,
t.promo2, t.sumnetpromo2, t.sumdtopromo2, t.vtamediapromo2 from
(
select encargos.vendedorVta as a, count(*) as normals, sum(encargos.impnetoVta) as sumneto, sum(encargos.impdtoVta) as sumdto, avg(encargos.impnetoVta) as vtamedia,
0 as garantia, 0 as sumnetgar, 0 as sumdtogar, 0 as vtamediagar,
0 as errores, 0 as sumneterr, 0 as sumdtoerr, 0 as vtamediaerr,
0 as reparacions, 0 as sumnetrep, 0 as sumdtorep, 0 as vtamediarep,
0 as promo1, 0 as sumnetpromo1, 0 as sumdtopromo1, 0 as vtamediapromo1,
0 as promo2, 0 as sumnetpromo2, 0 as sumdtopromo2, 0 as vtamediapromo2
from encargos
where encargos.fechaVta between '2017-11-01' and '2017-12-21' and encargos.promocionVta=0
group by encargos.vendedorVta
union all
select encargos.vendedorVta as a, 0 as normals, 0 as sumneto, 0 as sumdto, 0 as vtamedia,
count(*) as garantia, sum(encargos.impnetoVta) as sumnetgar, sum(encargos.impdtoVta) as sumdtogar, avg(encargos.impnetoVta) as vtamediagar,
0 as errores, 0 as sumneterr, 0 as sumdtoerr, 0 as vtamediaerr,
0 as reparacions, 0 as sumnetrep, 0 as sumdtorep, 0 as vtamediarep,
0 as promo1, 0 as sumnetpromo1, 0 as sumdtopromo1, 0 as vtamediapromo1,
0 as promo2, 0 as sumnetpromo2, 0 as sumdtopromo2, 0 as vtamediapromo2
from encargos
where encargos.fechaVta between '2017-11-01' and '2017-12-21' and encargos.promocionVta=0
group by encargos.vendedorVta
union all
select encargos.vendedorVta as a, 0 as normals, 0 as sumneto, 0 as sumdto, 0 as vtamedia,
0 as garantia, 0 as sumnetgar, 0 as sumdtogar, 0 as vtamediagar,
count(*) as errores, sum(encargos.impnetoVta) as sumneterr, sum(encargos.impdtoVta) as sumdtoerr, avg(encargos.impnetoVta) as vtamediaerr,
0 as reparacions, 0 as sumnetrep, 0 as sumdtorep, 0 as vtamediarep,
0 as promo1, 0 as sumnetpromo1, 0 as sumdtopromo1, 0 as vtamediapromo1,
0 as promo2, 0 as sumnetpromo2, 0 as sumdtopromo2, 0 as vtamediapromo2
from encargos
where encargos.fechaVta between '2017-11-01' and '2017-12-21' and encargos.promocionVta=3
group by encargos.vendedorVta
union all
select encargos.vendedorVta as a, 0 as normals, 0 as sumneto, 0 as sumdto, 0 as vtamedia,
0 as garantia, 0 as sumnetgar, 0 as sumdtogar, 0 as vtamediagar,
0 as errores, 0 as sumneterr, 0 as sumdtoerr, 0 as vtamediaerr,
count(*) as reparacions, sum(encargos.impnetoVta) as sumnetrep, sum(encargos.impdtoVta) as sumdtorep, avg(encargos.impnetoVta) as vtamediarep,
0 as promo1, 0 as sumnetpromo1, 0 as sumdtopromo1, 0 as vtamediapromo1,
0 as promo2, 0 as sumnetpromo2, 0 as sumdtopromo2, 0 as vtamediapromo2
from encargos
where encargos.fechaVta between '2017-11-01' and '2017-12-21' and encargos.promocionVta=3
group by encargos.vendedorVta
union all
select encargos.vendedorVta as a, 0 as normals, 0 as sumneto, 0 as sumdto, 0 as vtamedia,
0 as garantia, 0 as sumnetgar, 0 as sumdtogar, 0 as vtamediagar,
0 as errores, 0 as sumneterr, 0 as sumdtoerr, 0 as vtamediaerr,
0 as reparacions, 0 as sumnetrep, 0 as sumdtorep, 0 as vtamediarep,
count(*) as promo1, sum(encargos.impnetoVta) as sumnetpromo1, sum(encargos.impdtoVta) as sumdtopromo1, avg(encargos.impnetoVta) as vtamediapromo1,
0 as promo2, 0 as sumnetpromo2, 0 as sumdtopromo2, 0 as vtamediapromo2
from encargos
where encargos.fechaVta between '2017-11-01' and '2017-12-21' and encargos.promocionVta>3 and encargos.encargopralVta = 'S'
group by encargos.vendedorVta
union all
select encargos.vendedorVta as a, 0 as normals, 0 as sumneto, 0 as sumdto, 0 as vtamedia,
0 as garantia, 0 as sumnetgar, 0 as sumdtogar, 0 as vtamediagar,
0 as errores, 0 as sumneterr, 0 as sumdtoerr, 0 as vtamediaerr,
0 as reparacions, 0 as sumnetrep, 0 as sumdtorep, 0 as vtamediarep,
0 as promo1, 0 as sumnetpromo1, 0 as sumdtopromo1, 0 as vtamediapromo1,
count(*) as promo2, sum(encargos.impnetoVta) as sumnetpromo2, sum(encargos.impdtoVta) as sumdtopromo2, avg(encargos.impnetoVta) as vtamediapromo2
from encargos
where encargos.fechaVta between '2017-11-01' and '2017-12-21' and encargos.promocionVta>3 and encargos.encargopralVta = 'N'
group by encargos.vendedorVta
) t
group by t.a
order by t.a