Utøvere

Medaljer og pallplasseringer

NM/UM-medaljer 2026 per person - oppsummert

Navn # gull # søv # bronse 
/var/www/html/padling.juul.no/public_html/devs/include/class_club.php : 1149 ---- call:/devs/club.phpclubid=1 --- referer:  : string(35) "0 results from:
 Query failed: (0) "

/var/www/html/padling.juul.no/public_html/devs/include/class_nc.php : 289 ---- call:/devs/club.phpclubid=1 --- referer:  : string(126) "SQL: 
SELECT DISTINCT cid
FROM `nc_2026`
WHERE class < 2 having problems
Call was:  Table 'sprintDB_DEV.nc_2026' doesn't exist"

/var/www/html/padling.juul.no/public_html/devs/include/class_nc.php : 289 ---- call:/devs/club.phpclubid=1 --- referer:  : string(126) "SQL: 
SELECT DISTINCT cid
FROM `nc_2026`
WHERE class < 3 having problems
Call was:  Table 'sprintDB_DEV.nc_2026' doesn't exist"

/var/www/html/padling.juul.no/public_html/devs/include/class_nc.php : 289 ---- call:/devs/club.phpclubid=1 --- referer:  : string(126) "SQL: 
SELECT DISTINCT cid
FROM `nc_2026`
WHERE class < 4 having problems
Call was:  Table 'sprintDB_DEV.nc_2026' doesn't exist"

/var/www/html/padling.juul.no/public_html/devs/include/class_nc.php : 289 ---- call:/devs/club.phpclubid=1 --- referer:  : string(126) "SQL: 
SELECT DISTINCT cid
FROM `nc_2026`
WHERE class < 5 having problems
Call was:  Table 'sprintDB_DEV.nc_2026' doesn't exist"

/var/www/html/padling.juul.no/public_html/devs/include/class_nc.php : 1331 ---- call:/devs/club.phpclubid=1 --- referer:  : string(890) "SQL: 
SELECT clubid, club, SUM(NC_points) as sum
FROM (

(SELECT clubid, club, NC_points
FROM nc_2026
WHERE class = 2  AND cid IN (SELECT CompetitorId FROM Competitors WHERE Birth <= 2013) AND cid NOT IN (-1)
)

UNION ALL

(SELECT clubid, club, NC_points
FROM nc_2026
WHERE class = 3  AND cid IN (SELECT CompetitorId FROM Competitors WHERE Birth <= 2013) AND cid NOT IN (-1)
)

UNION ALL

(SELECT clubid, club, NC_points
FROM nc_2026
WHERE class = 4  AND cid IN (SELECT CompetitorId FROM Competitors WHERE Birth <= 2013) AND cid NOT IN (-1)
)

UNION ALL

(SELECT clubid, club, NC_points
FROM nc_2026
WHERE class = 5  AND cid IN (SELECT CompetitorId FROM Competitors WHERE Birth <= 2013) AND cid NOT IN (-1)
)

UNION ALL

(SELECT clubid, club, NC_points
 FROM nc_2026_team
)

) t1 
GROUP BY clubid, club
ORDER BY sum DESC having problems
Call was:  Table 'sprintDB_DEV.nc_2026' doesn't exist"

NC sammendrag 2026
Utøvere og NC-poeng per klasse

/var/www/html/padling.juul.no/public_html/devs/include/class_club.php : 943 ---- call:/devs/club.phpclubid=1 --- referer:  : string(42776) "SQL: SELECT MIN(class) as class, cid, SUM(NC_points) as sum
FROM ((SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'male' AND class = 2 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 4) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'male' AND class = 2 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 4) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 500 AND gender = 'male' AND class = 2 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 4) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'female' AND class = 2 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 4) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'female' AND class = 2 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 4) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 500 AND gender = 'female' AND class = 2 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 4) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'male' AND class = 3 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'male' AND class = 3 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'male' AND class = 3 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'female' AND class = 3 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'female' AND class = 3 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'female' AND class = 3 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'male' AND class = 4 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'male' AND class = 4 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 1000 AND gender = 'male' AND class = 4 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'male' AND class = 4 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'female' AND class = 4 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'female' AND class = 4 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 1000 AND gender = 'female' AND class = 4 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'female' AND class = 4 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'male' AND class = 5 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'male' AND class = 5 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 1000 AND gender = 'male' AND class = 5 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'male' AND class = 5 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'female' AND class = 5 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'female' AND class = 5 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 1000 AND gender = 'female' AND class = 5 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT class, gender, cid, name, clubid, club, length, NC_points
FROM
    (SELECT class, gender, cid, name, clubid, club, length, NC_points as NC_points,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM (SELECT class, gender, cid, name, clubid, club, length, comp,
                CASE
                    WHEN SUM(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN 1 ELSE 0 END) > 0
                        THEN MAX(CASE WHEN raceid IN (SELECT Races.RaceId FROM Races JOIN RaceType ON Races.RaceType = RaceType.Id WHERE RaceType.RaceType IN ('Finale', 'Langløp')) THEN (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) ELSE 0 END)
                    ELSE MAX((CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END))
                END AS NC_points,
                MAX(COALESCE(ExcludeFromIndividualNC, 0)) AS ExcludeFromIndividualNC
            FROM nc_2026
            WHERE (CASE WHEN dns = 1 OR dsq = 1 THEN 0 WHEN dnf = 1 THEN 1 ELSE NC_points END) > 0
            GROUP BY class, gender, cid, name, clubid, club, length, comp) scored, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'female' AND class = 5 AND NC_points > 0 AND COALESCE(ExcludeFromIndividualNC, 0) = 0  AND clubid = 1
    ORDER BY class, cid, NC_points DESC) AS a
WHERE indx <= 3) UNION ALL (SELECT t.class, t.gender, c.CompetitorId as cid, CONCAT(c.FirstName, ' ', c.LastName) as name, Clubs.ClubId as clubid, Clubs.ClubName as club, t.length, ROUND(t.NC_points/r.numPadlers, 2) as NC_points
FROM StartingCompetitors sc
    JOIN Competitors c
        ON sc.Competitor=c.CompetitorId
    JOIN Clubs
        ON sc.Club = Clubs.ClubId
    JOIN nc_2026_team t
        ON sc.StartId = t.sid
    JOIN Races r
        ON t.raceid = r.RaceId
WHERE t.clubid = 1
ORDER BY sc.StartId)) t1
GROUP BY cid
ORDER BY sum DESC having problems
Call was:  Table 'sprintDB_DEV.nc_2026' doesn't exist"