Ver originalSELECT usu.id idusuario,IFNULL( SUM( sim.importe ) , 0 ) impusu,IFNULL( SUM( sim.referidos ) , 0 ) refusu, '0' impsp, '0'refspFROM simulador simINNER JOIN usuarios usu ON sim.id_usuario = usu.idGROUP BY sim.id_usuarioORDER BY sim.id_usuario
Ver originalSELECT usu.id_sponsor, '0', '0', IFNULL(SUM( sim.importe ),0) , IFNULL(SUM( sim.referidos ),0) FROM simulador sim INNER JOIN usuarios usu ON sim.id_usuario = usu.id GROUP BY usu.id_sponsor ORDER BY usu.id_sponsor