Ver originalSELECT usuarios.*,COUNT(tmp_invite.tmp_id) AS total FROM usuarios LEFT JOIN tmp_invite ON usuarios.id = tmp_invite.who_invites WHERE pais >= 0 GROUP BY tmp_invite.who_invites ORDER BY total DESC LIMIT 0,30