SQL dotaz v Nette nevrací žádný záznam, v Admineru funguje

Zdravim, mam takovejhle dotaz, ktery v Admineru funguje a vrati 10 zaznamu:

        $sql = "SET @rownum=0;
                SELECT sub.team_id, sub.point_sum, @rownum := @rownum + 1 AS position
                  FROM
                    ( SELECT
                      stp.team_id,
                      stp.point_sum
                    FROM
                      `season_team_point` stp
                    LEFT JOIN team t on stp.team_id = t.id
                    WHERE
                        stp.season_id = 1
                        and t.category_id = 2
                    ORDER BY
                      stp.point_sum DESC,
                      stp.time_sum ASC) AS sub,
                      (SELECT @rownum := 0) r";

Kdyz ho vykonam v Nertte database, nevrati zadny zaznam:

        $stmt = $this->getDbContext()->query( $sql );
        dump( $stmt->dump() );
        dump( $stmt->getRowCount() );
        exit();

Netusi nekdo co delam spatne?