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?