All Top 10 Matrix Note: The IRT went to a pure points driven system for determining the champions starting with the 1981-82 season. Prior to that,
the winner of the NRC Nationals tournament was declared the 'Pro tour Winner.' As a result, this matrix will only show the champion and runner-up from
these National Championship tourneys from 1975-1981. This 'shortchanges' players from the 1970s for sure but we have no other way to give them top 10
credit when there wasn't really an official points system being used.
We have included the early IRA National Championships events for the purposes of this report (in 1975 and 1976),
fairly or not. There were 'competing' pro tours early on in the sport's history, and the 1976 IRA championship was missing all the top NRC players. But the
1975 event was a full draw and resulted in a 3rd 'pro title' for Brumfield (he claims 5 'titles' in all including two amateur titles).
This explains the one National title for Jerry Hilecher, who won the 1976 IRA Nationals
We are missing full top 10 lists from a couple of seasons: 1982-83 and 1989-90. When we find them, we'll load them in.
Player |
Ttl Seasons with Appearances |
Total Career Top 10s |
#1 Finishes |
#2 Finishes |
#3 Finishes |
#4 Finishes |
#5 Finishes |
#6 Finishes |
#7 Finishes |
#8 Finishes |
#9 Finishes |
#10 Finishes |
# Finishes outside top10 |
SQL execute failed, SQL is select rank from rankings where player='Rojas, Jose' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Rojas, Jose'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Rojas, Jose', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Rojas, Jose' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Hawthorne, Andy' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Hawthorne, Andy'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Hawthorne, Andy', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Hawthorne, Andy' and season > '1980-1' and `rank` <=' at line 1
SQL execute failed, SQL is select rank from rankings where player='Williams, Mitch' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Williams, Mitch'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Williams, Mitch', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Williams, Mitch' and season > '1980-1' and `rank` <=' at line 1
SQL execute failed, SQL is select rank from rankings where player='Crowther, Chris' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Crowther, Chris'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Crowther, Chris', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Crowther, Chris' and season > '1980-1' and `rank` <=' at line 1
SQL execute failed, SQL is select rank from rankings where player='Croft, Ben' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Croft, Ben'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Croft, Ben', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Croft, Ben' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Vanderson, Shane' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Vanderson, Shane'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Vanderson, Shane', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Vanderson, Shane' and season > '1980-1' and `rank` <' at line 1
SQL execute failed, SQL is select rank from rankings where player='Mannino, Jason' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Mannino, Jason'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Mannino, Jason', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Mannino, Jason' and season > '1980-1' and `rank` <=1' at line 1
SQL execute failed, SQL is select rank from rankings where player='Carson, Rocky' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Carson, Rocky'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Carson, Rocky', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Carson, Rocky' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Huczek, Jack' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Huczek, Jack'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Huczek, Jack', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Huczek, Jack' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Waselenchuk, Kane' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Waselenchuk, Kane'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Waselenchuk, Kane', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Waselenchuk, Kane' and season > '1980-1' and `rank` ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Thoerner, Jason' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Thoerner, Jason'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Thoerner, Jason', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Thoerner, Jason' and season > '1980-1' and `rank` <=' at line 1
SQL execute failed, SQL is select rank from rankings where player='Beltran, Alvaro' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Beltran, Alvaro'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Beltran, Alvaro', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Beltran, Alvaro' and season > '1980-1' and `rank` <=' at line 1
SQL execute failed, SQL is select rank from rankings where player='Swain, Cliff' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Swain, Cliff'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Swain, Cliff', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Swain, Cliff' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Guidry, Mike' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Guidry, Mike'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Guidry, Mike', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Guidry, Mike' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Robinson, Derek' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Robinson, Derek'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Robinson, Derek', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Robinson, Derek' and season > '1980-1' and `rank` <=' at line 1
SQL execute failed, SQL is select rank from rankings where player='Tucker, Josh' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Tucker, Josh'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Tucker, Josh', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Tucker, Josh' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Ellis, John' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Ellis, John'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Ellis, John', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Ellis, John' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Doyle, Tim' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Doyle, Tim'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Doyle, Tim', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Doyle, Tim' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Fowler, Dan' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Fowler, Dan'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Fowler, Dan', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Fowler, Dan' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Monchik, Sudsy' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Monchik, Sudsy'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Monchik, Sudsy', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Monchik, Sudsy' and season > '1980-1' and `rank` <=1' at line 1
SQL execute failed, SQL is select rank from rankings where player='Karp, Adam' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Karp, Adam'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Karp, Adam', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Karp, Adam' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Roberts, Andy' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Roberts, Andy'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Roberts, Andy', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Roberts, Andy' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Ray, Mike' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Ray, Mike'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Ray, Mike', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Ray, Mike' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Kachtik, Drew' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Kachtik, Drew'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Kachtik, Drew', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Kachtik, Drew' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Clouse, Woody' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Clouse, Woody'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Clouse, Woody', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Clouse, Woody' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Katz, Aaron' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Katz, Aaron'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Katz, Aaron', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Katz, Aaron' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Gonzalez, Ruben' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Gonzalez, Ruben'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Gonzalez, Ruben', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Gonzalez, Ruben' and season > '1980-1' and `rank` <=' at line 1
SQL execute failed, SQL is select rank from rankings where player='Newman, Jack' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Newman, Jack'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Newman, Jack', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Newman, Jack' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Harnett, Bret' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Harnett, Bret'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Harnett, Bret', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Harnett, Bret' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Johnson, Dave' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Johnson, Dave'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Johnson, Dave', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Johnson, Dave' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Yellen, Mike' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Yellen, Mike'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Yellen, Mike', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Yellen, Mike' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Obremski, Dan' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Obremski, Dan'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Obremski, Dan', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Obremski, Dan' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Hawkes, Brian' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Hawkes, Brian'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Hawkes, Brian', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Hawkes, Brian' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Inoue, Egan' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Inoue, Egan'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Inoue, Egan', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Inoue, Egan' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Hogan, Marty' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Hogan, Marty'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Hogan, Marty', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Hogan, Marty' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Brysman, Corey' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Brysman, Corey'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Brysman, Corey', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Brysman, Corey' and season > '1980-1' and `rank` <=1' at line 1
SQL execute failed, SQL is select rank from rankings where player='Andrews, Ed' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Andrews, Ed'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Andrews, Ed', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Andrews, Ed' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Peck, Gregg' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Peck, Gregg'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Peck, Gregg', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Peck, Gregg' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Price, Gerry' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Price, Gerry'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Price, Gerry', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Price, Gerry' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Lerner, Steve (CA)' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Lerner, Steve (CA)'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Lerner, Steve (CA)', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Lerner, Steve (CA)' and season > '1980-1' and `rank`' at line 1
SQL execute failed, SQL is select rank from rankings where player='Peck, Dave' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Peck, Dave'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Peck, Dave', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Peck, Dave' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Hilecher, Jerry' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Hilecher, Jerry'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Hilecher, Jerry', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Hilecher, Jerry' and season > '1980-1' and `rank` <=' at line 1
SQL execute failed, SQL is select rank from rankings where player='Oliver, Scott' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Oliver, Scott'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Oliver, Scott', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Oliver, Scott' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Wagner, Rich' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Wagner, Rich'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Wagner, Rich', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Wagner, Rich' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='McCoy, Craig' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='McCoy, Craig'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='McCoy, Craig', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='McCoy, Craig' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Thomas, Donny' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Thomas, Donny'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Thomas, Donny', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Thomas, Donny' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Egerman, John' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Egerman, John'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Egerman, John', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Egerman, John' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Moreno, Javier' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Moreno, Javier'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Moreno, Javier', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Moreno, Javier' and season > '1980-1' and `rank` <=1' at line 1
SQL execute failed, SQL is select rank from rankings where player='Pratt, Charlie' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Pratt, Charlie'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Pratt, Charlie', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Pratt, Charlie' and season > '1980-1' and `rank` <=1' at line 1
SQL execute failed, SQL is select rank from rankings where player='Herrera, Anthony' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Herrera, Anthony'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Herrera, Anthony', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Herrera, Anthony' and season > '1980-1' and `rank` <' at line 1
SQL execute failed, SQL is select rank from rankings where player='Carson, Tony' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Carson, Tony'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Carson, Tony', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Carson, Tony' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='De La Rosa, Daniel' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='De La Rosa, Daniel'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='De La Rosa, Daniel', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='De La Rosa, Daniel' and season > '1980-1' and `rank`' at line 1
SQL execute failed, SQL is select rank from rankings where player='Allen, Jansen' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Allen, Jansen'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Allen, Jansen', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Allen, Jansen' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Rojas, Marco' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Rojas, Marco'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Rojas, Marco', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Rojas, Marco' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Mercado, Mario' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Mercado, Mario'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Mercado, Mario', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Mercado, Mario' and season > '1980-1' and `rank` <=1' at line 1
SQL execute failed, SQL is select rank from rankings where player='Franco, Sebastian' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Franco, Sebastian'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Franco, Sebastian', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Franco, Sebastian' and season > '1980-1' and `rank` ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Camacho, Felipe' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Camacho, Felipe'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Camacho, Felipe', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Camacho, Felipe' and season > '1980-1' and `rank` <=' at line 1
SQL execute failed, SQL is select rank from rankings where player='Green, Mike' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Green, Mike'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Green, Mike', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Green, Mike' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Gelhaus, Kelly' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Gelhaus, Kelly'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Gelhaus, Kelly', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Gelhaus, Kelly' and season > '1980-1' and `rank` <=1' at line 1
SQL execute failed, SQL is select rank from rankings where player='Jelso, Tony' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Jelso, Tony'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Jelso, Tony', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Jelso, Tony' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Parrilla, Andree' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Parrilla, Andree'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Parrilla, Andree', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Parrilla, Andree' and season > '1980-1' and `rank` <' at line 1
SQL execute failed, SQL is select rank from rankings where player='Horn, David' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Horn, David'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Horn, David', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Horn, David' and season > '1980-1' and `rank` <=10
' at line 1
SQL execute failed, SQL is select rank from rankings where player='Murray, Samuel' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Murray, Samuel'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Murray, Samuel', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Murray, Samuel' and season > '1980-1' and `rank` <=1' at line 1
SQL execute failed, SQL is select rank from rankings where player='Landa, Alejandro' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Landa, Alejandro'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Landa, Alejandro', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Landa, Alejandro' and season > '1980-1' and `rank` <' at line 1
SQL execute failed, SQL is select rank from rankings where player='Montoya, Rodrigo' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Montoya, Rodrigo'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Montoya, Rodrigo', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Montoya, Rodrigo' and season > '1980-1' and `rank` <' at line 1
SQL execute failed, SQL is select rank from rankings where player='Bredenbeck, Jake' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Bredenbeck, Jake'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Bredenbeck, Jake', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Bredenbeck, Jake' and season > '1980-1' and `rank` <' at line 1
SQL execute failed, SQL is select rank from rankings where player='Moscoso, Conrrado' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Moscoso, Conrrado'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Moscoso, Conrrado', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Moscoso, Conrrado' and season > '1980-1' and `rank` ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Portillo, Eduardo' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Portillo, Eduardo'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Portillo, Eduardo', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Portillo, Eduardo' and season > '1980-1' and `rank` ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Manilla, Adam' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Manilla, Adam'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Manilla, Adam', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Manilla, Adam' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Acuna, Andres' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Acuna, Andres'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Acuna, Andres', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Acuna, Andres' and season > '1980-1' and `rank` <=10' at line 1
SQL execute failed, SQL is select rank from rankings where player='Natera, Alan' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Natera, Alan'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Natera, Alan', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Natera, Alan' and season > '1980-1' and `rank` <=10 ' at line 1
SQL execute failed, SQL is select rank from rankings where player='Brumfield, Charlie' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Brumfield, Charlie'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Brumfield, Charlie', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Brumfield, Charlie' and season > '1980-1' and `rank`' at line 1
SQL execute failed, SQL is select rank from rankings where player='Bledsoe, Davey' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Bledsoe, Davey'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Bledsoe, Davey', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Bledsoe, Davey' and season > '1980-1' and `rank` <=1' at line 1
SQL execute failed, SQL is select rank from rankings where player='Serot, Steve' and season > '1980-1' and `rank` <=10
union all
select 1
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.winner='Serot, Steve'
union all
select 2
from tourneys t, results r where t.major_flag='Y' and t.season <= '1980-1' and t.tmp_date=r.tmp_date and t.event=r.event and r.round=2
and r.loser='Serot, Steve', Error from DB is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rankings where player='Serot, Steve' and season > '1980-1' and `rank` <=10 ' at line 1
Swain, Cliff |
35 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
35 |
Gonzalez, Ruben |
32 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
32 |
Carson, Rocky |
28 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
28 |
Beltran, Alvaro |
25 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
25 |
Clouse, Woody |
23 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
23 |
Waselenchuk, Kane |
23 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
23 |
Moreno, Javier |
22 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
22 |
Hogan, Marty |
22 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
22 |
Ray, Mike |
22 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
22 |
Landa, Alejandro |
20 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
20 |
Crowther, Chris |
20 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
20 |
Green, Mike |
18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
18 |
Pratt, Charlie |
18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
18 |
Price, Gerry |
17 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
17 |
Yellen, Mike |
17 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
17 |
Mannino, Jason |
17 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
17 |
Guidry, Mike |
17 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
17 |
Vanderson, Shane |
17 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
17 |
Ellis, John |
17 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
17 |
Fowler, Dan |
17 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
17 |
Harnett, Bret |
16 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
16 |
Doyle, Tim |
16 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
16 |
De La Rosa, Daniel |
16 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
16 |
Camacho, Felipe |
15 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
15 |
Franco, Sebastian |
15 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
15 |
Peck, Dave |
15 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
15 |
Hilecher, Jerry |
15 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
15 |
Hawthorne, Andy |
15 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
15 |
Croft, Ben |
15 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
15 |
Roberts, Andy |
15 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
15 |
Monchik, Sudsy |
14 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
14 |
Lerner, Steve (CA) |
14 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
14 |
Robinson, Derek |
14 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
14 |
Parrilla, Andree |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Acuna, Andres |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Herrera, Anthony |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Carson, Tony |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Thoerner, Jason |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Bredenbeck, Jake |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Murray, Samuel |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Obremski, Dan |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Horn, David |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Newman, Jack |
13 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13 |
Allen, Jansen |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
Manilla, Adam |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
Peck, Gregg |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
Wagner, Rich |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
Williams, Mitch |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
Huczek, Jack |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
Karp, Adam |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
Kachtik, Drew |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
Katz, Aaron |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
Johnson, Dave |
12 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
12 |
McCoy, Craig |
11 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
11 |
Tucker, Josh |
11 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
11 |
Inoue, Egan |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
10 |
Thomas, Donny |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
9 |
Bledsoe, Davey |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
9 |
Jelso, Tony |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
9 |
Mercado, Mario |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
9 |
Andrews, Ed |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
9 |
Rojas, Jose |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
9 |
Egerman, John |
9 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
9 |
Hawkes, Brian |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
8 |
Brysman, Corey |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
8 |
Montoya, Rodrigo |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
8 |
Brumfield, Charlie |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
8 |
Serot, Steve |
8 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
8 |
Gelhaus, Kelly |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
7 |
Rojas, Marco |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
7 |
Moscoso, Conrrado |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
7 |
Portillo, Eduardo |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
7 |
Oliver, Scott |
7 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
7 |
Natera, Alan |
6 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
6 |
click here to go back to the Report Select page