SELECT
    *,
    @contador_tramo := @contador_tramo + 1 AS linhaTramo, Insc
FROM
    (SELECT @contador_tramo := 0) AS nada,
    (
        SELECT
            Lista.Insc,
            Lista.userID,
            Lista.userName,
            Lista.userNick,
            Lista.userEquipa,
            Lista.userFotoUrl,
            Lista.Pesqueiro1,
            Lista.Pesqueiro2,
            COALESCE(X1.TotalN, 0) AS TotalN,
            COALESCE(X1.TotalKg, 0) AS TotalKg,
            COALESCE(X1.MAior, 0) AS MAior,
            COALESCE(X1.Comprimento, 0) AS Comprimento
        FROM
            (
                SELECT
                    pi.idPescador AS Insc,
                    u.userID,
                    u.userName,
                    u.userNick,
                    u.userEquipa,
                    u.userFotoUrl,
                    COALESCE(sf.sec1, 0) AS Pesqueiro1,
                    COALESCE(sf.sec2, 0) AS Pesqueiro2
                FROM
                    bf_Prova_Inscricao AS pi
                INNER JOIN bf_user AS u ON pi.idPescador = u.userID
                INNER JOIN seccao_feeder AS sf ON u.userID = sf.id_pescador AND pi.idProva = sf.id_prova
                WHERE
                    pi.idProva IN (25, 139)
                    AND pi.estado = 'Aprovado'
                    AND sf.sec2 = 1
                    AND sf.id_prova IN (25, 139)
            ) AS Lista
        LEFT JOIN
            (
                SELECT
                    p.id_pescador AS Insc2,
                    COUNT(p.`id_captura`) AS TotalN,
                    SUM(p.`kg`) AS TotalKg,
                    MAX(p.cm) AS MAior,
                    ROUND(AVG(p.cm)) AS Comprimento
                FROM
                    bf_peixes AS p
                INNER JOIN seccao_feeder AS sf ON p.id_pescador = sf.id_pescador AND p.id_prova = sf.id_prova
                WHERE
                    p.id_prova IN (25, 139)
                    AND p.validade = 0
                    AND sf.sec2 = 1
                GROUP BY
                    p.id_pescador
            ) AS X1 ON X1.Insc2 = Lista.Insc
        ORDER BY
            COALESCE(X1.TotalKg, 0) DESC,
            COALESCE(X1.MAior, 0) DESC
    ) AS ResultadoFinal
ORDER BY
    TotalKg DESC,
    MAior DESC