+--------------------+------------+---------+| Name | 300YdGames | MaxPaYd |+--------------------+------------+---------+| Drew Brees | 13 | 419 || Tom Brady | 11 | 517 || Aaron Rodgers | 8 | 408 || Eli Manning | 8 | 420 || Matthew Stafford | 8 | 520 || Matt Ryan | 6 | 373 || Philip Rivers | 6 | 385 || Ben Roethlisberger | 5 | 365 || Tony Romo | 5 | 345 || Carson Palmer | 4 | 417 || Joe Flacco | 4 | 389 || Cam Newton | 3 | 432 || Mark Sanchez | 3 | 369 || Matt Hasselbeck | 3 | 358 || Michael Vick | 3 | 416 || Ryan Fitzpatrick | 3 | 369 || Andy Dalton | 2 | 373 || Jason Campbell | 2 | 344 || Jay Cutler | 2 | 312 || John Skelton | 2 | 315 || Josh Freeman | 2 | 342 || Kyle Orton | 2 | 304 || Matt Schaub | 2 | 416 || Rex Grossman | 2 | 314 || Sam Bradford | 2 | 331 || Tarvaris Jackson | 2 | 323 || Chad Henne | 1 | 416 || Christian Ponder | 1 | 381 || Colt McCoy | 1 | 350 || Dan Orlovsky | 1 | 353 || Kevin Kolb | 1 | 309 || Matt Flynn | 1 | 480 || T.J. Yates | 1 | 300 || Vince Young | 1 | 400 |+--------------------+------------+---------+34 rows in set (0.04 sec)
+---------------------+------------+---------+| Name | 100YdGames | MaxReYd |+---------------------+------------+---------+| Calvin Johnson | 8 | 244 || Wes Welker | 8 | 217 || Victor Cruz | 7 | 178 || Larry Fitzgerald | 6 | 149 || Steve Smith | 6 | 181 || Brandon Marshall | 5 | 143 || Jordy Nelson | 5 | 162 || Julio Jones | 5 | 131 || Rob Gronkowski | 5 | 160 || Roddy White | 5 | 147 || A.J. Green | 4 | 124 || Jimmy Graham | 4 | 132 || Malcom Floyd | 4 | 127 || Marques Colston | 4 | 145 || Mike Wallace | 4 | 144 || Vincent Jackson | 4 | 172 || Aaron Hernandez | 3 | 138 || Antonio Brown | 3 | 151 || Arian Foster | 3 | 119 || Darrius Heyward-Bey | 3 | 155 || Denarius Moore | 3 | 146 || Dwayne Bowe | 3 | 128 || Greg Jennings | 3 | 147 || Hakeem Nicks | 3 | 163 || Jeremy Maclin | 3 | 171 || Jerome Simpson | 3 | 152 || Laurent Robinson | 3 | 137 || Pierre Garcon | 3 | 150 || Reggie Wayne | 3 | 122 || Anquan Boldin | 2 | 145 || Brandon Lloyd | 2 | 136 || Brandon Pettigrew | 2 | 116 || Deion Branch | 2 | 129 || Demaryius Thomas | 2 | 144 || DeSean Jackson | 2 | 171 || Devery Henderson | 2 | 103 || Jared Cook | 2 | 169 || Jason Avant | 2 | 139 || Jason Witten | 2 | 110 || Kenny Britt | 2 | 136 || Nate Washington | 2 | 130 || Percy Harvin | 2 | 156 || Sidney Rice | 2 | 109 || Torrey Smith | 2 | 165 || Vernon Davis | 2 | 118 || Andre Johnson | 1 | 128 || Andre Roberts | 1 | 111 || Antonio Gates | 1 | 106 || Ben Obomanu | 1 | 107 || Brandon LaFell | 1 | 103 || Brent Celek | 1 | 156 || Damian Williams | 1 | 107 || Danario Alexander | 1 | 122 || Donald Jones | 1 | 101 || Doug Baldwin | 1 | 136 || Dustin Keller | 1 | 101 || Early Doucet | 1 | 105 || Eric Decker | 1 | 113 || Fred Davis | 1 | 105 || Greg Little | 1 | 131 || Harry Douglas | 1 | 133 || Jabar Gaffney | 1 | 115 || Jacoby Ford | 1 | 105 || James Casey | 1 | 126 || James Jones | 1 | 140 || Jason Hill | 1 | 118 || Joel Dreessen | 1 | 112 || Johnny Knox | 1 | 145 || Jonathan Stewart | 1 | 100 || Kellen Winslow | 1 | 132 || LaDainian Tomlinson | 1 | 116 || Leonard Hankerson | 1 | 106 || Matt Forte | 1 | 117 || Michael Crabtree | 1 | 120 || Michael Jenkins | 1 | 111 || Miles Austin | 1 | 143 || Owen Daniels | 1 | 100 || Robert Meachem | 1 | 119 || Roy Helu | 1 | 105 || Steve Breaston | 1 | 115 || Steve Johnson | 1 | 116 || Tony Gonzalez | 1 | 100 |+---------------------+------------+---------+82 rows in set (0.07 sec)
Thanks man, this saved me a buch of time, much appreciated.Rushing (note I didn't split by position, as Tebow is in this list):
+-----------------------+------------+---------+| Name | 100YdGames | MaxRuYd |+-----------------------+------------+---------+| Arian Foster | 7 | 158 || Willis McGahee | 7 | 163 || Fred Jackson | 6 | 121 || LeSean McCoy | 6 | 185 || Marshawn Lynch | 6 | 148 || Maurice Jones-Drew | 6 | 169 || Michael Turner | 6 | 172 || Ray Rice | 6 | 204 || Frank Gore | 5 | 141 || Reggie Bush | 5 | 203 || Ben Tate | 4 | 116 || Chris Johnson | 4 | 190 || Matt Forte | 4 | 205 || Ryan Mathews | 4 | 137 || Steven Jackson | 4 | 159 || Adrian Peterson | 3 | 175 || Cedric Benson | 3 | 121 || DeMarco Murray | 3 | 253 || Felix Jones | 3 | 115 || LeGarrette Blount | 3 | 127 || Roy Helu | 3 | 126 || Beanie Wells | 2 | 228 || Darren McFadden | 2 | 171 || Evan Royster | 2 | 132 || Michael Bush | 2 | 157 || Rashard Mendenhall | 2 | 146 || Shonn Greene | 2 | 129 || Ahmad Bradshaw | 1 | 104 || BenJarvus Green-Ellis | 1 | 136 || Brandon Jacobs | 1 | 101 || C.J. Spiller | 1 | 111 || Chris Ivory | 1 | 127 || Chris Ogbonnaya | 1 | 115 || Daniel Thomas | 1 | 107 || DeAngelo Williams | 1 | 115 || Donald Brown | 1 | 161 || Earnest Graham | 1 | 109 || Jackie Battle | 1 | 119 || Jahvid Best | 1 | 163 || Joe Webb | 1 | 109 || Jonathan Dwyer | 1 | 107 || Kahlil Bell | 1 | 121 || Kevin Smith | 1 | 140 || Marion Barber | 1 | 108 || Peyton Hillis | 1 | 112 || Ryan Torain | 1 | 135 || Tim Tebow | 1 | 118 || Toby Gerhart | 1 | 109 |+-----------------------+------------+---------+48 rows in set (0.07 sec)Receiving (also mix of RB, WR, TE):
+---------------------+------------+---------+| Name | 100YdGames | MaxReYd |+---------------------+------------+---------+| Calvin Johnson | 8 | 244 || Wes Welker | 8 | 217 || Victor Cruz | 7 | 178 || Larry Fitzgerald | 6 | 149 || Steve Smith | 6 | 181 || Brandon Marshall | 5 | 143 || Jordy Nelson | 5 | 162 || Julio Jones | 5 | 131 || Rob Gronkowski | 5 | 160 || Roddy White | 5 | 147 || A.J. Green | 4 | 124 || Jimmy Graham | 4 | 132 || Malcom Floyd | 4 | 127 || Marques Colston | 4 | 145 || Mike Wallace | 4 | 144 || Vincent Jackson | 4 | 172 || Aaron Hernandez | 3 | 138 || Antonio Brown | 3 | 151 || Arian Foster | 3 | 119 || Darrius Heyward-Bey | 3 | 155 || Denarius Moore | 3 | 146 || Dwayne Bowe | 3 | 128 || Greg Jennings | 3 | 147 || Hakeem Nicks | 3 | 163 || Jeremy Maclin | 3 | 171 || Jerome Simpson | 3 | 152 || Laurent Robinson | 3 | 137 || Pierre Garcon | 3 | 150 || Reggie Wayne | 3 | 122 || Anquan Boldin | 2 | 145 || Brandon Lloyd | 2 | 136 || Brandon Pettigrew | 2 | 116 || Deion Branch | 2 | 129 || Demaryius Thomas | 2 | 144 || DeSean Jackson | 2 | 171 || Devery Henderson | 2 | 103 || Jared Cook | 2 | 169 || Jason Avant | 2 | 139 || Jason Witten | 2 | 110 || Kenny Britt | 2 | 136 || Nate Washington | 2 | 130 || Percy Harvin | 2 | 156 || Sidney Rice | 2 | 109 || Torrey Smith | 2 | 165 || Vernon Davis | 2 | 118 || Andre Johnson | 1 | 128 || Andre Roberts | 1 | 111 || Antonio Gates | 1 | 106 || Ben Obomanu | 1 | 107 || Brandon LaFell | 1 | 103 || Brent Celek | 1 | 156 || Damian Williams | 1 | 107 || Danario Alexander | 1 | 122 || Donald Jones | 1 | 101 || Doug Baldwin | 1 | 136 || Dustin Keller | 1 | 101 || Early Doucet | 1 | 105 || Eric Decker | 1 | 113 || Fred Davis | 1 | 105 || Greg Little | 1 | 131 || Harry Douglas | 1 | 133 || Jabar Gaffney | 1 | 115 || Jacoby Ford | 1 | 105 || James Casey | 1 | 126 || James Jones | 1 | 140 || Jason Hill | 1 | 118 || Joel Dreessen | 1 | 112 || Johnny Knox | 1 | 145 || Jonathan Stewart | 1 | 100 || Kellen Winslow | 1 | 132 || LaDainian Tomlinson | 1 | 116 || Leonard Hankerson | 1 | 106 || Matt Forte | 1 | 117 || Michael Crabtree | 1 | 120 || Michael Jenkins | 1 | 111 || Miles Austin | 1 | 143 || Owen Daniels | 1 | 100 || Robert Meachem | 1 | 119 || Roy Helu | 1 | 105 || Steve Breaston | 1 | 115 || Steve Johnson | 1 | 116 || Tony Gonzalez | 1 | 100 |+---------------------+------------+---------+82 rows in set (0.07 sec)