acorn Posted August 13, 2014 Share Posted August 13, 2014 Hey guys I got a bug in my bonnet today to deal with some code bugs on the top 50 page SQL queries. As a result I fixed a few things that have been bugging me and updated the www.gripsport.org site with the latest code. New features include the option to look at all gripper events combined, top 15 places in weight class listings, and finally combining masters class lifters results with regular weight class without having to set them different. I will still need to go in and clean up results on that last one that had been set to non masters class version in order to display correctly. Let me know if you see any thing funky. - Aaron 5 Quote Link to comment Share on other sites More sharing options...
Electron Posted August 14, 2014 Share Posted August 14, 2014 Wooo! Awesome work man, I like looking at that site. 1 Quote Link to comment Share on other sites More sharing options...
acorn Posted August 14, 2014 Author Share Posted August 14, 2014 Sorry site link did not show up in previous post. Http://www.gripsport.org Quote Link to comment Share on other sites More sharing options...
Tank Andrade Posted August 14, 2014 Share Posted August 14, 2014 Thanks Aaron Quote Link to comment Share on other sites More sharing options...
Andrew P Posted August 14, 2014 Share Posted August 14, 2014 Thank you. It looks great. Quote Link to comment Share on other sites More sharing options...
Electron Posted August 14, 2014 Share Posted August 14, 2014 Last night I found a few bugs, but I went to sleep before I reported them to you. The only one to survive my memory is while viewing the combined gripper page, it's unable to load the page using pounds. I'll let you know about the others if I can recall them. Quote Link to comment Share on other sites More sharing options...
Electron Posted August 14, 2014 Share Posted August 14, 2014 Last night I found a few bugs, but I went to sleep before I reported them to you. The only one to survive my memory is while viewing the combined gripper page, it's unable to load the page using pounds. I'll let you know about the others if I can recall them. /home/jeddball/public_html/gripsport.org/recordlist_top50.php on line 35 Quote Link to comment Share on other sites More sharing options...
acorn Posted August 15, 2014 Author Share Posted August 15, 2014 Thanks i'll check out the cause when I get back from vacation in a few days. Quote Link to comment Share on other sites More sharing options...
bwwm Posted August 16, 2014 Share Posted August 16, 2014 Hi Aaron - you're sql needs some tuning on the combined grippers list. It doesn't keep the correct associated set for the pounds listed (unless you're now giving me credit for the attempt on the 156# gripper at AZCGS ;-) ). Hope you're having a great vacation! 40 Martin Braun Grippers Parallel Set USA 156.40lbs AZCG V 2012 Mens 120k Quote Link to comment Share on other sites More sharing options...
acorn Posted August 16, 2014 Author Share Posted August 16, 2014 It sounds like its not doing the page reload correctly for that to regen the sql set appropriately. Will check when I get back. Quote Link to comment Share on other sites More sharing options...
acorn Posted August 18, 2014 Author Share Posted August 18, 2014 (edited) Last night I found a few bugs, but I went to sleep before I reported them to you. The only one to survive my memory is while viewing the combined gripper page, it's unable to load the page using pounds. I'll let you know about the others if I can recall them. /home/jeddball/public_html/gripsport.org/recordlist_top50.php on line 35 This should be fixed. Took me half the day to figure out the cause. Hi Aaron - you're sql needs some tuning on the combined grippers list. It doesn't keep the correct associated set for the pounds listed (unless you're now giving me credit for the attempt on the 156# gripper at AZCGS ;-) ). Hope you're having a great vacation!40 Martin Braun Grippers Parallel Set USA 156.40lbsAZCG V 2012 Mens 120k I think this should be fixed as well but had to do a 2nd GROUP BY on the Event to keep the associated set connected. The result is it shows the Max performances in each possible gripper event for each athlete. So for example best result in 20mm block set grippers and parallel set grippers if an athlete has done both and both would be ranked in the list where they came. Not exactly what I originally envisioned for this section but the SQL to constrain it the way I wanted without buggyness on the outliers was beyond my current knowledge. Also fixed all the Masters class performances listings that I could find in the database. So they should show in the list now if an age was entered in the results. Still an issue with handedness on some of the performances when 2 results are entered for a contest but I will see what I can do. Please let me know if you see anything else and I have expanded the viewable datasets to 75 temporarily for the top 50 area. Next steps will be to get some pagination code written to look beyond the top 50 if wanted. - Aaron Edited August 18, 2014 by acorn Quote Link to comment Share on other sites More sharing options...
acorn Posted August 19, 2014 Author Share Posted August 19, 2014 btw, if anyone had interest in more extended sets of data let me know and I can see what I can come up with for you. - Aaron Quote Link to comment Share on other sites More sharing options...
bwwm Posted August 19, 2014 Share Posted August 19, 2014 Nice work Aaron! Quote Link to comment Share on other sites More sharing options...
Electron Posted August 19, 2014 Share Posted August 19, 2014 Aaron, 3-lift total rankings will be the best thing ever. I wish I had the technical know how to help out. You rock, man! Quote Link to comment Share on other sites More sharing options...
bencrush Posted August 19, 2014 Share Posted August 19, 2014 (edited) Edit: Removed. Edited August 19, 2014 by bencrush Quote Link to comment Share on other sites More sharing options...
acorn Posted August 19, 2014 Author Share Posted August 19, 2014 Aaron, 3-lift total rankings will be the best thing ever. I wish I had the technical know how to help out. You rock, man! I whipped up a quick query. This would be Top 100 All time totals for Grippers (either block set or parallel or CCS), 2HP Euro, and Axle DL by Total. Andrew Durniat 917.06 Adam Glass 870.05 Jedd Johnson 849.35 Kody Burns 824.86 Juha Harju 824.80 Aaron Corcorran 822.43 Brad Ardrey 819.70 Eric Roussin 798.86 Paul Knight 790.55 Ryan Johnson 775.71 Brent Barbe 774.21 Matt Brouse 771.39 Rex Hubbard 768.32 Eric Milfeld 752.77 Daniel Reinard 751.71 Chris Mathison 737.91 Chris Rice 735.29 Malcolm Majesky 732.98 Jeremy Hartman 731.60 Brandon Gerber 724.52 Mike Coats 721.81 JT Straussner 721.80 Taylor Holmes 719.82 Cesare Ricchezza 719.74 Tommy Jennings 716.90 Martin Braun 715.49 Pasi Mehtälä 706.82 Chris Castanon 705.91 Jon Vance 705.90 Nick Rosendaul 704.32 Nick Pivato 700.83 Lucas Raymond 697.91 Jeff Parker 697.09 Robert Miller 693.76 Brandon Azevedo 688.34 Cody Musselwhite 687.39 Derek Graybill 683.85 John Wojciechowski 681.23 Ryan Maier 677.79 Jeremy Copley 677.71 Alexey Tyukalov 673.35 Joe Costa 672.56 Igor Kupinsky 664.03 Matti Harju 662.45 Mark DeSouza 658.78 Joe Goodin 656.31 Matt Massaro 656.21 Zach Jacobs 655.10 Andrew Pantke 650.46 Kevin Emery 649.95 Casey Emery 649.73 Ryan Pitts 648.94 Christian Hanabergh 647.94 Luke Rose 646.93 Austin Acree 642.79 Jason Steeves 641.87 Greg Gorecki 639.35 Bob Sundin 638.41 Timo Tuukkanen 637.79 Michael Hann 636.55 Nick Bronkall 633.92 Russ Farver 631.19 Rich MacLean 630.22 Thomas Scibelli 625.84 J.L. Holdsworth 625.67 Dave Thornton 624.08 Brett Aved 618.00 Matt Cannon 616.16 Dave Dellanave 613.23 Stew Rosendaul 612.61 Jacob Layer 610.24 Zach Lister 609.26 Darrin Shallman 607.25 Joel Davies 604.03 Aaron Jacobs 601.38 Zach Coulter 593.80 Jake Chaknova 583.55 Justin Kaye 582.53 Jeff Staudt 581.98 Ivan Beritashvili 578.09 Chuck Penzenik 573.31 Maxim Merkulov 573.21 Ivan Pupchenko 573.21 Ian Gillaspie 571.33 Parris Janusek 566.61 Greg Griffin 565.93 Mike Sheehan 562.68 Yori Skutt 558.65 Cody Sherrod 552.40 Brent Bogress 550.71 Shane Musselwhite 545.20 Joe Yunker 544.66 Emiliano Lake-Herrera 543.22 Alexey Pritula 539.67 Jeff Neely 538.71 Jacob Eggleton 534.20 Kevin Collen 530.16 Hans Florine 524.37 Vitaly Andreev 523.15 Sean Dockery 521.19 Quote Link to comment Share on other sites More sharing options...
jvance Posted August 19, 2014 Share Posted August 19, 2014 Aaron, 3-lift total rankings will be the best thing ever. I wish I had the technical know how to help out. You rock, man! I whipped up a quick query. This would be Top 100 All time totals for Grippers (either block set or parallel or CCS), 2HP Euro, and Axle DL by Total. Andrew Durniat 917.06 Adam Glass 870.05 Jedd Johnson 849.35 Kody Burns 824.86 Juha Harju 824.80 Aaron Corcorran 822.43 Brad Ardrey 819.70 Eric Roussin 798.86 Paul Knight 790.55 Ryan Johnson 775.71 Brent Barbe 774.21 Matt Brouse 771.39 Rex Hubbard 768.32 Eric Milfeld 752.77 Daniel Reinard 751.71 Chris Mathison 737.91 Chris Rice 735.29 Malcolm Majesky 732.98 Jeremy Hartman 731.60 Brandon Gerber 724.52 Mike Coats 721.81 JT Straussner 721.80 Taylor Holmes 719.82 Cesare Ricchezza 719.74 Tommy Jennings 716.90 Martin Braun 715.49 Pasi Mehtälä 706.82 Chris Castanon 705.91 Jon Vance 705.90 Nick Rosendaul 704.32 Nick Pivato 700.83 Lucas Raymond 697.91 Jeff Parker 697.09 Robert Miller 693.76 Brandon Azevedo 688.34 Cody Musselwhite 687.39 Derek Graybill 683.85 John Wojciechowski 681.23 Ryan Maier 677.79 Jeremy Copley 677.71 Alexey Tyukalov 673.35 I am fairly certain this is just axle and pinch, scary Joe Costa 672.56 Igor Kupinsky 664.03 Matti Harju 662.45 Mark DeSouza 658.78 Joe Goodin 656.31 Matt Massaro 656.21 Zach Jacobs 655.10 Andrew Pantke 650.46 Kevin Emery 649.95 Casey Emery 649.73 Ryan Pitts 648.94 Christian Hanabergh 647.94 Luke Rose 646.93 Austin Acree 642.79 Jason Steeves 641.87 Greg Gorecki 639.35 Bob Sundin 638.41 Timo Tuukkanen 637.79 Michael Hann 636.55 Nick Bronkall 633.92 Russ Farver 631.19 Rich MacLean 630.22 Thomas Scibelli 625.84 J.L. Holdsworth 625.67 Dave Thornton 624.08 Brett Aved 618.00 Matt Cannon 616.16 Dave Dellanave 613.23 Stew Rosendaul 612.61 Jacob Layer 610.24 Zach Lister 609.26 Darrin Shallman 607.25 Joel Davies 604.03 Aaron Jacobs 601.38 Zach Coulter 593.80 Jake Chaknova 583.55 Justin Kaye 582.53 Jeff Staudt 581.98 Ivan Beritashvili 578.09 Chuck Penzenik 573.31 Maxim Merkulov 573.21 Ivan Pupchenko 573.21 Ian Gillaspie 571.33 Parris Janusek 566.61 Greg Griffin 565.93 Mike Sheehan 562.68 Yori Skutt 558.65 Cody Sherrod 552.40 Brent Bogress 550.71 Shane Musselwhite 545.20 Joe Yunker 544.66 Emiliano Lake-Herrera 543.22 Alexey Pritula 539.67 Jeff Neely 538.71 Jacob Eggleton 534.20 Kevin Collen 530.16 Hans Florine 524.37 Vitaly Andreev 523.15 Sean Dockery 521.19 Quote Link to comment Share on other sites More sharing options...
acorn Posted August 19, 2014 Author Share Posted August 19, 2014 (edited) Same list with additional constraints for weight class. All time, weight class other than Open, and Totals. Andrew Durniat 910.44 Mens 105k Andrew Durniat 892.54 Mens 120k Adam Glass 870.05 Mens 105k Kody Burns 824.86 Mens 93k Aaron Corcorran 819.19 Mens 120k Juha Harju 815.92 Mens 120k+ Jedd Johnson 815.27 Mens 120k Jedd Johnson 814.65 Mens 105k Jedd Johnson 814.08 Mens 120k+ Brad Ardrey 796.17 Mens 120k+ Eric Roussin 790.14 Mens 105k Brent Barbe 774.21 Mens 105k Eric Roussin 764.40 Mens 93k Paul Knight 761.74 Mens 105k Matt Brouse 749.89 Mens 120k+ Daniel Reinard 749.51 Mens 105k Kody Burns 744.88 Mens 83k Matt Brouse 740.99 Mens 120k Chris Rice 735.29 Mens 93k, Masters 60-69 Malcolm Majesky 732.98 Mens 120k Jeremy Hartman 731.60 Mens 105k Daniel Reinard 731.09 Mens 93k Chris Mathison 725.71 Mens 120k+ Brandon Gerber 724.52 Mens 105k Brent Barbe 723.86 Mens 93k JT Straussner 721.80 Mens 105k Eric Milfeld 720.84 Mens 83k Eric Milfeld 720.29 Mens 93k Cesare Ricchezza 719.74 Mens 120k Paul Knight 719.43 Mens 93k Tommy Jennings 716.90 Mens 105k Martin Braun 715.49 Mens 120k Ryan Johnson 714.54 Mens 120k Chris Castanon 705.91 Mens 120k+ Jon Vance 705.90 Mens 93k Nick Pivato 700.83 Mens 120k+ Eric Milfeld 699.73 Mens 74k Lucas Raymond 697.91 Mens 93k Nick Rosendaul 697.03 Mens 120k Robert Miller 693.76 Mens 120k+ Brandon Azevedo 688.34 Mens 120k+ Cody Musselwhite 687.39 Mens 105k Derek Graybill 683.85 Mens 93k John Wojciechowski 681.23 Mens 120k+ Brandon Gerber 678.95 Mens 93k Ryan Maier 677.79 Mens 120k Jeremy Copley 677.71 Mens 93k Alexey Tyukalov 673.35 Mens 120k Joe Costa 672.56 Mens 120k+ Igor Kupinsky 664.03 Mens 120k+ Joe Goodin 656.31 Mens 105k Matt Massaro 656.21 Mens 93k Zach Jacobs 655.10 Mens 105k Andrew Pantke 650.46 Mens 105k Casey Emery 649.73 Mens 83k Ryan Pitts 648.94 Mens 83k Christian Hanabergh 647.94 Mens 120k Luke Rose 646.93 Mens 120k+ Matti Harju 644.28 Mens 93k Austin Acree 642.79 Mens 105k Mark DeSouza 642.51 Mens 93k Greg Gorecki 639.35 Mens 120k Timo Tuukkanen 637.79 Mens 120k Tommy Jennings 637.04 Mens 93k Michael Hann 636.55 Mens 74k Jason Steeves 636.37 Mens 120k Nick Bronkall 633.92 Mens 105k Brad Ardrey 632.48 Mens 120k Russ Farver 631.19 Mens 120k Rich MacLean 630.22 Mens 120k Thomas Scibelli 625.84 Mens 105k J.L. Holdsworth 625.67 Mens 120k Dave Thornton 622.28 Mens 105k Kevin Emery 619.20 Mens 83k Brett Aved 618.00 Mens 93k Dave Dellanave 613.23 Mens 93k Stew Rosendaul 612.61 Mens 83k Jacob Layer 610.24 Mens 93k Zach Lister 608.40 Mens 120k Darrin Shallman 607.25 Mens 74k Joel Davies 604.03 Mens 83k Aaron Jacobs 601.38 Mens 105k Zach Coulter 593.80 Mens 83k Chris Rice 586.90 Mens 105k, Masters 60-69 Justin Kaye 582.53 Mens 120k+ Jeff Staudt 581.98 Mens 105k Casey Emery 581.70 Mens 93k Zach Lister 581.32 Mens 120k+ Ivan Beritashvili 578.09 Mens 93k Jake Chaknova 576.94 Mens 83k Matt Cannon 576.70 Mens 66k Chuck Penzenik 573.31 Mens 83k Maxim Merkulov 573.21 Mens 105k Ivan Pupchenko 573.21 Mens 105k Ian Gillaspie 571.33 Mens 105k Greg Griffin 565.93 Mens 93k Mike Sheehan 562.68 Mens 105k Yori Skutt 558.65 Mens 59k Cody Sherrod 552.40 Mens 93k Brent Bogress 550.71 Mens 83k Edited August 19, 2014 by acorn Quote Link to comment Share on other sites More sharing options...
acorn Posted August 19, 2014 Author Share Posted August 19, 2014 (edited) Same with just NAGS (USA and Canada athletes) Andrew Durniat 910.44 Mens 105k Andrew Durniat 892.54 Mens 120k Adam Glass 870.05 Mens 105k Kody Burns 824.86 Mens 93k Aaron Corcorran 819.19 Mens 120k Jedd Johnson 815.27 Mens 120k Jedd Johnson 814.65 Mens 105k Jedd Johnson 814.08 Mens 120k+ Brad Ardrey 796.17 Mens 120k+ Eric Roussin 790.14 Mens 105k Brent Barbe 774.21 Mens 105k Eric Roussin 764.40 Mens 93k Paul Knight 761.74 Mens 105k Matt Brouse 749.89 Mens 120k+ Daniel Reinard 749.51 Mens 105k Kody Burns 744.88 Mens 83k Matt Brouse 740.99 Mens 120k Chris Rice 735.29 Mens 93k, Masters 60-69 Malcolm Majesky 732.98 Mens 120k Jeremy Hartman 731.60 Mens 105k Daniel Reinard 731.09 Mens 93k Chris Mathison 725.71 Mens 120k+ Brandon Gerber 724.52 Mens 105k Brent Barbe 723.86 Mens 93k JT Straussner 721.80 Mens 105k Eric Milfeld 720.84 Mens 83k Eric Milfeld 720.29 Mens 93k Cesare Ricchezza 719.74 Mens 120k Paul Knight 719.43 Mens 93k Tommy Jennings 716.90 Mens 105k Martin Braun 715.49 Mens 120k Ryan Johnson 714.54 Mens 120k Chris Castanon 705.91 Mens 120k+ Jon Vance 705.90 Mens 93k Nick Pivato 700.83 Mens 120k+ Eric Milfeld 699.73 Mens 74k Lucas Raymond 697.91 Mens 93k Nick Rosendaul 697.03 Mens 120k Robert Miller 693.76 Mens 120k+ Brandon Azevedo 688.34 Mens 120k+ Cody Musselwhite 687.39 Mens 105k Derek Graybill 683.85 Mens 93k John Wojciechowski 681.23 Mens 120k+ Brandon Gerber 678.95 Mens 93k Ryan Maier 677.79 Mens 120k Jeremy Copley 677.71 Mens 93k Joe Costa 672.56 Mens 120k+ Joe Goodin 656.31 Mens 105k Matt Massaro 656.21 Mens 93k Zach Jacobs 655.10 Mens 105k Andrew Pantke 650.46 Mens 105k Casey Emery 649.73 Mens 83k Ryan Pitts 648.94 Mens 83k Christian Hanabergh 647.94 Mens 120k Luke Rose 646.93 Mens 120k+ Austin Acree 642.79 Mens 105k Mark DeSouza 642.51 Mens 93k Greg Gorecki 639.35 Mens 120k Tommy Jennings 637.04 Mens 93k Michael Hann 636.55 Mens 74k Jason Steeves 636.37 Mens 120k Nick Bronkall 633.92 Mens 105k Brad Ardrey 632.48 Mens 120k Russ Farver 631.19 Mens 120k Rich MacLean 630.22 Mens 120k Thomas Scibelli 625.84 Mens 105k J.L. Holdsworth 625.67 Mens 120k Dave Thornton 622.28 Mens 105k Kevin Emery 619.20 Mens 83k Brett Aved 618.00 Mens 93k Dave Dellanave 613.23 Mens 93k Stew Rosendaul 612.61 Mens 83k Jacob Layer 610.24 Mens 93k Zach Lister 608.40 Mens 120k Darrin Shallman 607.25 Mens 74k Joel Davies 604.03 Mens 83k Aaron Jacobs 601.38 Mens 105k Zach Coulter 593.80 Mens 83k Chris Rice 586.90 Mens 105k, Masters 60-69 Justin Kaye 582.53 Mens 120k+ Jeff Staudt 581.98 Mens 105k Casey Emery 581.70 Mens 93k Zach Lister 581.32 Mens 120k+ Jake Chaknova 576.94 Mens 83k Matt Cannon 576.70 Mens 66k Chuck Penzenik 573.31 Mens 83k Ian Gillaspie 571.33 Mens 105k Greg Griffin 565.93 Mens 93k Mike Sheehan 562.68 Mens 105k Yori Skutt 558.65 Mens 59k Cody Sherrod 552.40 Mens 93k Brent Bogress 550.71 Mens 83k Parris Janusek 546.81 Mens 120k Joe Yunker 544.66 Mens 120k Emiliano Lake-Herrera 543.22 Mens 120k Shane Musselwhite 543.20 Mens 93k Christian Hanabergh 527.21 Mens 120k+ Kevin Collen 526.21 Mens 120k Sean Dockery 521.19 Mens 105k Isaiah Hubert 518.20 Mens 120k Edited August 19, 2014 by acorn Quote Link to comment Share on other sites More sharing options...
acorn Posted August 19, 2014 Author Share Posted August 19, 2014 By Class -NAGS (USA and Cananda) Athletes 59Kg Yori Skutt 558.65 Mens 59k Mike Brown 459.31 Mens 59k 66Kg Matt Cannon 576.70 Mens 66k C-A Chartrand-Lefebvre 507.23 Mens 66k Matt Delgado 477.08 Mens 66k Connor Everton 441.35 Mens 66k David Martinez 346.89 Mens 66k 74Kg Eric Milfeld 699.73 Mens 74k Michael Hann 636.55 Mens 74k Darrin Shallman 607.25 Mens 74k Shayne Scantland 496.80 Mens 74k Steve Callahan 488.10 Mens 74k Matt Cannon 451.42 Mens 74k James Neidlinger 441.74 Mens 74k Jacob Eggleton 420.20 Mens 74k Nick Delgado 255.71 Mens 74k Jon Little 229.12 Mens 74k Robby Sparango 229.05 Mens 74k Denmark Tordil 227.20 Mens 74k 83Kg Kody Burns 744.88 Mens 83k Eric Milfeld 720.84 Mens 83k Casey Emery 649.73 Mens 83k Ryan Pitts 648.94 Mens 83k Kevin Emery 619.20 Mens 83k Stew Rosendaul 612.61 Mens 83k Joel Davies 604.03 Mens 83k Zach Coulter 593.80 Mens 83k Jake Chaknova 576.94 Mens 83k Chuck Penzenik 573.31 Mens 83k Brent Bogress 550.71 Mens 83k Jacob Eggleton 510.48 Mens 83k Maverick McDowell 489.49 Mens 83k Bob Sundin 484.76 Mens 83k, Masters 50-59 Darren Schilberg 452.35 Mens 83k Josh Freeman 436.03 Mens 83k Kong Lo 349.88 Mens 83k Bob Sundin 334.94 Mens 83k Quote Link to comment Share on other sites More sharing options...
acorn Posted August 19, 2014 Author Share Posted August 19, 2014 By Class - All Time NAGS (USA and Cananda) Athletes. 3 Lift Totals 93Kg Kody Burns 824.86 Mens 93k Eric Roussin 764.40 Mens 93k Chris Rice 735.29 Mens 93k, Masters 60-69 Daniel Reinard 731.09 Mens 93k Brent Barbe 723.86 Mens 93k Eric Milfeld 720.29 Mens 93k Paul Knight 719.43 Mens 93k Jon Vance 705.90 Mens 93k Lucas Raymond 697.91 Mens 93k Derek Graybill 683.85 Mens 93k Brandon Gerber 678.95 Mens 93k Jeremy Copley 677.71 Mens 93k Matt Massaro 656.21 Mens 93k Mark DeSouza 642.51 Mens 93k Tommy Jennings 637.04 Mens 93k Brett Aved 618.00 Mens 93k Dave Dellanave 613.23 Mens 93k Jacob Layer 610.24 Mens 93k Casey Emery 581.70 Mens 93k Greg Griffin 565.93 Mens 93k 105Kg Andrew Durniat 910.44 Mens 105k Adam Glass 870.05 Mens 105k Jedd Johnson 814.65 Mens 105k Eric Roussin 790.14 Mens 105k Brent Barbe 774.21 Mens 105k Paul Knight 761.74 Mens 105k Daniel Reinard 749.51 Mens 105k Jeremy Hartman 731.60 Mens 105k Brandon Gerber 724.52 Mens 105k JT Straussner 721.80 Mens 105k Tommy Jennings 716.90 Mens 105k Cody Musselwhite 687.39 Mens 105k Joe Goodin 656.31 Mens 105k Zach Jacobs 655.10 Mens 105k Andrew Pantke 650.46 Mens 105k Austin Acree 642.79 Mens 105k Nick Bronkall 633.92 Mens 105k Thomas Scibelli 625.84 Mens 105k Dave Thornton 622.28 Mens 105k Aaron Jacobs 601.38 Mens 105k 120kg Andrew Durniat 892.54 Mens 120k Aaron Corcorran 819.19 Mens 120k Jedd Johnson 815.27 Mens 120k Matt Brouse 740.99 Mens 120k Malcolm Majesky 732.98 Mens 120k Cesare Ricchezza 719.74 Mens 120k Martin Braun 715.49 Mens 120k Ryan Johnson 714.54 Mens 120k Nick Rosendaul 697.03 Mens 120k Ryan Maier 677.79 Mens 120k Christian Hanabergh 647.94 Mens 120k Greg Gorecki 639.35 Mens 120k Jason Steeves 636.37 Mens 120k Brad Ardrey 632.48 Mens 120k Russ Farver 631.19 Mens 120k Rich MacLean 630.22 Mens 120k J.L. Holdsworth 625.67 Mens 120k Zach Lister 608.40 Mens 120k Parris Janusek 546.81 Mens 120k Joe Yunker 544.66 Mens 120k 120Kg+ Jedd Johnson 814.08 Mens 120k+ Brad Ardrey 796.17 Mens 120k+ Matt Brouse 749.89 Mens 120k+ Chris Mathison 725.71 Mens 120k+ Chris Castanon 705.91 Mens 120k+ Nick Pivato 700.83 Mens 120k+ Robert Miller 693.76 Mens 120k+ Brandon Azevedo 688.34 Mens 120k+ John Wojciechowski 681.23 Mens 120k+ Joe Costa 672.56 Mens 120k+ Luke Rose 646.93 Mens 120k+ Justin Kaye 582.53 Mens 120k+ Zach Lister 581.32 Mens 120k+ Christian Hanabergh 527.21 Mens 120k+ Jason Steeves 449.14 Mens 120k+ Dave Schaal 413.79 Mens 120k+ Stephen Ruby 368.32 Mens 120k+ Eli Thomas 213.27 Mens 120k+ John Eaton 210.70 Mens 120k+ Quote Link to comment Share on other sites More sharing options...
jvance Posted August 19, 2014 Share Posted August 19, 2014 VERY cool Aaron! 1 Quote Link to comment Share on other sites More sharing options...
acorn Posted August 19, 2014 Author Share Posted August 19, 2014 (edited) Also did the current counts 585 Athletes from 17 countries represented in the database. 150 Contests results entered with nearly 4000 individual result values entered. Hopefully these totals lists will give you stats junkies something to keep you occupied for the rest of the day. - Aaron Edited August 19, 2014 by acorn 1 Quote Link to comment Share on other sites More sharing options...
acorn Posted August 19, 2014 Author Share Posted August 19, 2014 (edited) Ok last one I promise. According to the standards set forth in the most recent qualifications for NAGS championship these athletes all time scores have made Elite status. Note: This is all time in the database, not just in last 2 yrs only scores. It is possible an athlete's highest all time scores may be higher if their highest scores predate the contests that are in the database. I know I am one of those with a higher all time best on the axle lift pre-dating our weight classes, etc Here are the standards: 120k+ - 840 None yet 120k - 800 Andrew Durniat 892.54 Mens 120k Aaron Corcorran 819.19 Mens 120k Jedd Johnson 815.27 Mens 120k 105k - 770 Andrew Durniat 910.44 Mens 105k Adam Glass 870.05 Mens 105k Jedd Johnson 814.65 Mens 105k Eric Roussin 790.14 Mens 105k Brent Barbe 774.21 Mens 105k 93k - 730 Kody Burns 824.86 Mens 93k Eric Roussin 764.40 Mens 93k Chris Rice 735.29 Mens 93k, Masters 60-69 Daniel Reinard 731.09 Mens 93k 83k - 690 Kody Burns 744.88 Mens 83k Eric Milfeld 720.84 Mens 83k 74k - 640 Eric Milfeld 699.73 Mens 74k 66k - 585 None Yet 59k - 530 Yori Skutt 558.65 Mens 59k Edited August 19, 2014 by acorn Quote Link to comment Share on other sites More sharing options...
Jedd Johnson Posted August 20, 2014 Share Posted August 20, 2014 Hey Aaron, I just want to say thanks for the work you have done on this stuff. Quite amazing my man. Thank you! 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.