Logging to file '/usr/lib/cgi-bin/round2bystate.txt' mysql> select s.statename, c.cand, v.vote from states s, cands c, votes v where v.stateid = s.stateid and v.candid = c.candid and v.roundid = 2 and v.votetype = "N" order by s.statename, c.cand; +----------------------+---------------+-------+ | statename | cand | vote | +----------------------+---------------+-------+ | Alabama | Abstain | 0.00 | | Alabama | David Cobb | 4.00 | | Alabama | JoAnne Beemon | 0.00 | | Alabama | Kent Mesplay | 0.00 | | Alabama | No Nominee | 0.00 | | Arizona | Abstain | 0.00 | | Arizona | David Cobb | 1.00 | | Arizona | JoAnne Beemon | 0.00 | | Arizona | Kent Mesplay | 1.00 | | Arizona | No Nominee | 2.00 | | Arkansas | Abstain | 0.00 | | Arkansas | David Cobb | 7.00 | | Arkansas | JoAnne Beemon | 0.00 | | Arkansas | Kent Mesplay | 0.00 | | Arkansas | No Nominee | 0.00 | | California | Abstain | 0.00 | | California | David Cobb | 35.00 | | California | JoAnne Beemon | 0.00 | | California | Kent Mesplay | 7.00 | | California | No Nominee | 90.00 | | Colorado | Abstain | 0.00 | | Colorado | David Cobb | 17.00 | | Colorado | JoAnne Beemon | 0.00 | | Colorado | Kent Mesplay | 0.00 | | Colorado | No Nominee | 5.00 | | Connecticut | Abstain | 0.00 | | Connecticut | David Cobb | 7.00 | | Connecticut | JoAnne Beemon | 0.00 | | Connecticut | Kent Mesplay | 0.00 | | Connecticut | No Nominee | 8.00 | | Delaware | Abstain | 0.00 | | Delaware | David Cobb | 7.00 | | Delaware | JoAnne Beemon | 0.00 | | Delaware | Kent Mesplay | 0.00 | | Delaware | No Nominee | 0.00 | | District of Columbia | Abstain | 0.00 | | District of Columbia | David Cobb | 7.00 | | District of Columbia | JoAnne Beemon | 0.00 | | District of Columbia | Kent Mesplay | 0.00 | | District of Columbia | No Nominee | 4.00 | | Florida | Abstain | 0.00 | | Florida | David Cobb | 3.00 | | Florida | JoAnne Beemon | 0.00 | | Florida | Kent Mesplay | 0.00 | | Florida | No Nominee | 20.00 | | Georgia | Abstain | 0.00 | | Georgia | David Cobb | 12.00 | | Georgia | JoAnne Beemon | 0.00 | | Georgia | Kent Mesplay | 0.00 | | Georgia | No Nominee | 0.00 | | Hawaii | Abstain | 0.00 | | Hawaii | David Cobb | 1.00 | | Hawaii | JoAnne Beemon | 0.00 | | Hawaii | Kent Mesplay | 0.00 | | Hawaii | No Nominee | 7.00 | | Idaho | Abstain | 0.00 | | Idaho | David Cobb | 3.00 | | Idaho | JoAnne Beemon | 0.00 | | Idaho | Kent Mesplay | 0.00 | | Idaho | No Nominee | 3.00 | | Illinois | Abstain | 0.00 | | Illinois | David Cobb | 11.00 | | Illinois | JoAnne Beemon | 0.00 | | Illinois | Kent Mesplay | 4.00 | | Illinois | No Nominee | 7.00 | | Indiana | Abstain | 0.00 | | Indiana | David Cobb | 7.00 | | Indiana | JoAnne Beemon | 0.00 | | Indiana | Kent Mesplay | 0.00 | | Indiana | No Nominee | 3.00 | | Iowa | Abstain | 1.00 | | Iowa | David Cobb | 7.00 | | Iowa | JoAnne Beemon | 0.00 | | Iowa | Kent Mesplay | 1.00 | | Iowa | No Nominee | 0.00 | | Kansas | Abstain | 0.00 | | Kansas | David Cobb | 0.00 | | Kansas | JoAnne Beemon | 0.00 | | Kansas | Kent Mesplay | 0.00 | | Kansas | No Nominee | 2.00 | | Louisiana | Abstain | 0.00 | | Louisiana | David Cobb | 4.00 | | Louisiana | JoAnne Beemon | 0.00 | | Louisiana | Kent Mesplay | 0.00 | | Louisiana | No Nominee | 5.00 | | Maine | Abstain | 0.00 | | Maine | David Cobb | 18.00 | | Maine | JoAnne Beemon | 0.00 | | Maine | Kent Mesplay | 0.00 | | Maine | No Nominee | 1.00 | | Maryland | Abstain | 1.00 | | Maryland | David Cobb | 6.00 | | Maryland | JoAnne Beemon | 0.00 | | Maryland | Kent Mesplay | 0.00 | | Maryland | No Nominee | 5.00 | | Massachussetts | Abstain | 0.00 | | Massachussetts | David Cobb | 10.00 | | Massachussetts | JoAnne Beemon | 0.00 | | Massachussetts | Kent Mesplay | 18.00 | | Massachussetts | No Nominee | 8.00 | | Michigan | Abstain | 0.00 | | Michigan | David Cobb | 11.00 | | Michigan | JoAnne Beemon | 6.00 | | Michigan | Kent Mesplay | 1.00 | | Michigan | No Nominee | 14.00 | | Minnesota | Abstain | 0.00 | | Minnesota | David Cobb | 18.00 | | Minnesota | JoAnne Beemon | 0.00 | | Minnesota | Kent Mesplay | 0.00 | | Minnesota | No Nominee | 10.00 | | Mississippi | Abstain | 0.00 | | Mississippi | David Cobb | 1.00 | | Mississippi | JoAnne Beemon | 0.00 | | Mississippi | Kent Mesplay | 0.00 | | Mississippi | No Nominee | 3.00 | | Missouri | Abstain | 0.00 | | Missouri | David Cobb | 11.00 | | Missouri | JoAnne Beemon | 0.00 | | Missouri | Kent Mesplay | 0.00 | | Missouri | No Nominee | 0.00 | | Montana | Abstain | 0.00 | | Montana | David Cobb | 7.00 | | Montana | JoAnne Beemon | 0.00 | | Montana | Kent Mesplay | 0.00 | | Montana | No Nominee | 0.00 | | Nebraska | Abstain | 0.00 | | Nebraska | David Cobb | 9.00 | | Nebraska | JoAnne Beemon | 0.00 | | Nebraska | Kent Mesplay | 0.00 | | Nebraska | No Nominee | 0.00 | | Nevada | Abstain | 0.00 | | Nevada | David Cobb | 0.00 | | Nevada | JoAnne Beemon | 0.00 | | Nevada | Kent Mesplay | 0.00 | | Nevada | No Nominee | 7.00 | | New Jersey | Abstain | 0.00 | | New Jersey | David Cobb | 4.00 | | New Jersey | JoAnne Beemon | 0.00 | | New Jersey | Kent Mesplay | 2.00 | | New Jersey | No Nominee | 11.00 | | New Mexico | Abstain | 0.00 | | New Mexico | David Cobb | 4.00 | | New Mexico | JoAnne Beemon | 0.00 | | New Mexico | Kent Mesplay | 0.00 | | New Mexico | No Nominee | 6.00 | | New York | Abstain | 0.00 | | New York | David Cobb | 8.00 | | New York | JoAnne Beemon | 2.00 | | New York | Kent Mesplay | 0.00 | | New York | No Nominee | 34.00 | | North Carolina | Abstain | 0.00 | | North Carolina | David Cobb | 8.00 | | North Carolina | JoAnne Beemon | 0.00 | | North Carolina | Kent Mesplay | 0.00 | | North Carolina | No Nominee | 2.00 | | Ohio | Abstain | 1.00 | | Ohio | David Cobb | 12.00 | | Ohio | JoAnne Beemon | 0.00 | | Ohio | Kent Mesplay | 5.00 | | Ohio | No Nominee | 4.00 | | Oklahoma | Abstain | 0.00 | | Oklahoma | David Cobb | 2.00 | | Oklahoma | JoAnne Beemon | 0.00 | | Oklahoma | Kent Mesplay | 0.00 | | Oklahoma | No Nominee | 2.00 | | Oregon | Abstain | 0.00 | | Oregon | David Cobb | 17.00 | | Oregon | JoAnne Beemon | 0.00 | | Oregon | Kent Mesplay | 0.00 | | Oregon | No Nominee | 2.00 | | Pennsylvania | Abstain | 0.00 | | Pennsylvania | David Cobb | 17.00 | | Pennsylvania | JoAnne Beemon | 0.00 | | Pennsylvania | Kent Mesplay | 1.00 | | Pennsylvania | No Nominee | 19.00 | | Rhode Island | Abstain | 0.00 | | Rhode Island | David Cobb | 8.00 | | Rhode Island | JoAnne Beemon | 0.00 | | Rhode Island | Kent Mesplay | 0.00 | | Rhode Island | No Nominee | 2.00 | | South Carolina | Abstain | 0.00 | | South Carolina | David Cobb | 9.00 | | South Carolina | JoAnne Beemon | 0.00 | | South Carolina | Kent Mesplay | 0.00 | | South Carolina | No Nominee | 0.00 | | Tennessee | Abstain | 0.00 | | Tennessee | David Cobb | 10.00 | | Tennessee | JoAnne Beemon | 0.00 | | Tennessee | Kent Mesplay | 0.00 | | Tennessee | No Nominee | 0.00 | | Texas | Abstain | 0.00 | | Texas | David Cobb | 34.00 | | Texas | JoAnne Beemon | 0.00 | | Texas | Kent Mesplay | 0.00 | | Texas | No Nominee | 1.00 | | Utah | Abstain | 0.00 | | Utah | David Cobb | 0.00 | | Utah | JoAnne Beemon | 0.00 | | Utah | Kent Mesplay | 0.00 | | Utah | No Nominee | 3.00 | | Vermont | Abstain | 0.00 | | Vermont | David Cobb | 0.00 | | Vermont | JoAnne Beemon | 0.00 | | Vermont | Kent Mesplay | 0.00 | | Vermont | No Nominee | 8.00 | | Virginia | Abstain | 0.00 | | Virginia | David Cobb | 8.00 | | Virginia | JoAnne Beemon | 0.00 | | Virginia | Kent Mesplay | 2.00 | | Virginia | No Nominee | 0.00 | | Washington | Abstain | 0.00 | | Washington | David Cobb | 12.00 | | Washington | JoAnne Beemon | 0.00 | | Washington | Kent Mesplay | 0.00 | | Washington | No Nominee | 9.00 | | Wisconsin | Abstain | 0.00 | | Wisconsin | David Cobb | 31.00 | | Wisconsin | JoAnne Beemon | 0.00 | | Wisconsin | Kent Mesplay | 1.00 | | Wisconsin | No Nominee | 1.00 | +----------------------+---------------+-------+ 220 rows in set (0.01 sec) mysql> notee;