Legg til og editer klubber

Utøvere

Medaljer og pallplasseringer

NM/UM-medaljer 2025 per person - oppsummert

Navn	# gull	# søv	# bronse
Georg William Fevang	0	1	1

/var/www/html/padling.juul.no/public_html/devs/include/class_club.php : 1005 ---- call:/devs/club.phpclubid=17 --- referer:  : string(35) "0 results from:
 Query failed: (0) "

/var/www/html/padling.juul.no/public_html/devs/include/class_nc.php : 208 ---- call:/devs/club.phpclubid=17 --- 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 : 208 ---- call:/devs/club.phpclubid=17 --- 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 : 208 ---- call:/devs/club.phpclubid=17 --- 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 : 208 ---- call:/devs/club.phpclubid=17 --- 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 : 1222 ---- call:/devs/club.phpclubid=17 --- referer:  : string(606) "SQL: 
SELECT clubid, club, SUM(NC_points) as sum
FROM (

(SELECT clubid, club, NC_points
FROM nc_2026
WHERE class = 2 AND cid NOT IN (-1)
)

UNION ALL

(SELECT clubid, club, NC_points
FROM nc_2026
WHERE class = 3 AND cid NOT IN (-1)
)

UNION ALL

(SELECT clubid, club, NC_points
FROM nc_2026
WHERE class = 4 AND cid NOT IN (-1)
)

UNION ALL

(SELECT clubid, club, NC_points
FROM nc_2026
WHERE class = 5 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 : 799 ---- call:/devs/club.phpclubid=17 --- referer:  : string(13629) "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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'male' AND class = 2 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'male' AND class = 2 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 500 AND gender = 'male' AND class = 2 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'female' AND class = 2 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'female' AND class = 2 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 500 AND gender = 'female' AND class = 2 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'male' AND class = 3 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'male' AND class = 3 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'male' AND class = 3 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'female' AND class = 3 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'female' AND class = 3 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'female' AND class = 3 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'male' AND class = 4 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'male' AND class = 4 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 1000 AND gender = 'male' AND class = 4 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'male' AND class = 4 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'female' AND class = 4 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'female' AND class = 4 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 1000 AND gender = 'female' AND class = 4 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'female' AND class = 4 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'male' AND class = 5 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'male' AND class = 5 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 1000 AND gender = 'male' AND class = 5 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'male' AND class = 5 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 200 AND gender = 'female' AND class = 5 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 500 AND gender = 'female' AND class = 5 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length = 1000 AND gender = 'female' AND class = 5 AND NC_points > 0  AND clubid = 17
    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,
        (@auto := IF(@lastCid=cid, @auto+1,
                    IF(@lastCid:=cid, 1, 1))
        ) indx
    FROM nc_2026, (SELECT @lastCid:=0, @auto:=1) A
    WHERE length > 1000 AND gender = 'female' AND class = 5 AND NC_points > 0  AND clubid = 17
    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 = 17
ORDER BY sc.StartId)) t1
GROUP BY cid
ORDER BY sum DESC having problems
Call was:  Table 'sprintDB_DEV.nc_2026' doesn't exist"

Utøvere

Medaljer og pallplasseringer

NM/UM-medaljer 2025 per person - oppsummert

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

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