SELECT TournamentYear, TournamentLocation, Division, Day1Place, Day1Caught, Day1NetWeight, Day1BigBass, Day2Place, Day2Caught, Day2NetWeight, Day2BigBass, Day3Place, Day3Caught, Day3NetWeight, Day3BigBass, TotalPlace, TotalCaught, TotalNetWeight, TotalBigBass FROM TOCMemberResults INNER JOIN TOCSchedule ON TOCSchedule.TOCScheduleID = TOCMemberResults.TOCScheduleID FROM TOCMemberResults INNER JOIN TOCSchedule ON TOCSchedule.TOCScheduleID = TOCMemberResults.TOCScheduleID WHERE FirstName LIKE 'Keith' AND LastName LIKE 'Jans' ORDER BY TOCSchedule.TOCScheduleID
tourney count= Keith Jans Angler Profile | Sportsmen Bassmasters
LogoSportsmen Bassmasters

Angler Profile

Keith Jans

Hometown

Savage, MN

Rookie Year

2014

Sportsmen Accolades

Sportsmen Tournament Results

8 tournaments

Date Location Place Caught Net
Weight
Big Bass Total
Points
2021-09-19Farm Island1300.000.002
2021-08-22German924.972.976
2021-06-20Koronis11510.483.263
2021-05-16Tetonka1500.000.002
2020-08-16Green (Chisago)1600.000.003
2020-07-19Maple959.082.6811
2020-06-21Green (Spicer)1146.052.293
2020-05-17Minnetonka945.992.229
Totals 20 36.57 39
Averages 2.50 4.57 4.88
to do load rest of tourney results into database
to do break by Year

MN B.A.S.S. Nation TOC Results

Day 1 Day 2 Day 3 Total
Date Location Division Place Caught Net Weight Big Bass Place Caught Net Weight Big Bass Place Caught Net Weight Big Bass Place Caught Net Weight Big Bass