API tools faq
paste
Guest User

Untitled

a guest
May 22nd, 2018
196
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.34 KB | None | 0 0
raw download clone embed print report
  1. mysql> SELECT pen.*, pem.status, s.stat_repository_type, dn_player.first_name, dn_player.last_name, p.person_key, dn_team.full_name, t.team_key FROM stats s JOIN basketball_offensive_stats off ON s.stat_repository_id = off.id JOIN basketball_defensive_stats def ON s.stat_repository_id = def.id JOIN basketball_rebounding_stats reb ON s.stat_repository_id = reb.id JOIN teams t ON s.stat_membership_id = t.id JOIN persons p ON s.stat_holder_id = p.id JOIN events e ON s.stat_coverage_id = e.id JOIN display_names dn_player ON s.stat_holder_id = dn_player.entity_id JOIN display_names dn_team ON s.stat_membership_id = dn_team.entity_id join person_event_metadata pem on pem.person_id = p.id and pem.event_id = e.id JOIN penalty_stats pen ON s.stat_repository_id = pen.id WHERE s.stat_holder_type='persons' AND s.stat_coverage_type='events' AND e.event_key='l.nba.com-2011-e.16074' AND dn_player.entity_type='persons' AND dn_team.entity_type='teams' AND context = 'event';
  2. +--------+-------+---------+-------+---------+-----------------------------+------------+-----------+------------------+------------------+----------------+
  3. | id | count | type | value | status | stat_repository_type | first_name | last_name | person_key | full_name | team_key |
  4. +--------+-------+---------+-------+---------+-----------------------------+------------+-----------+------------------+------------------+----------------+
  5. | 241005 | 0 | minutes | 0 | starter | basketball_offensive_stats | Shawn | Marion | l.nba.com-p.368 | Dallas Mavericks | l.nba.com-t.16 |
  6. | 241005 | 0 | minutes | 0 | starter | basketball_rebounding_stats | Shawn | Marion | l.nba.com-p.368 | Dallas Mavericks | l.nba.com-t.16 |
  7. | 241000 | 0 | minutes | 0 | starter | basketball_defensive_stats | Shawn | Marion | l.nba.com-p.368 | Dallas Mavericks | l.nba.com-t.16 |
  8. | 241006 | 0 | minutes | 0 | starter | basketball_offensive_stats | Dirk | Nowitzki | l.nba.com-p.280 | Dallas Mavericks | l.nba.com-t.16 |
  9. | 241006 | 0 | minutes | 0 | starter | basketball_rebounding_stats | Dirk | Nowitzki | l.nba.com-p.280 | Dallas Mavericks | l.nba.com-t.16 |
  10. | 241001 | 1 | minutes | 2 | starter | basketball_defensive_stats | Dirk | Nowitzki | l.nba.com-p.280 | Dallas Mavericks | l.nba.com-t.16 |
  11. | 241007 | 0 | minutes | 0 | starter | basketball_offensive_stats | Brendan | Haywood | l.nba.com-p.143 | Dallas Mavericks | l.nba.com-t.16 |
  12. | 241007 | 0 | minutes | 0 | starter | basketball_rebounding_stats | Brendan | Haywood | l.nba.com-p.143 | Dallas Mavericks | l.nba.com-t.16 |
  13. | 241002 | 0 | minutes | 0 | starter | basketball_defensive_stats | Brendan | Haywood | l.nba.com-p.143 | Dallas Mavericks | l.nba.com-t.16 |
  14. | 241008 | 0 | minutes | 0 | starter | basketball_offensive_stats | Vince | Carter | l.nba.com-p.92 | Dallas Mavericks | l.nba.com-t.16 |
  15. | 241008 | 0 | minutes | 0 | starter | basketball_rebounding_stats | Vince | Carter | l.nba.com-p.92 | Dallas Mavericks | l.nba.com-t.16 |
  16. | 241003 | 2 | minutes | 4 | starter | basketball_defensive_stats | Vince | Carter | l.nba.com-p.92 | Dallas Mavericks | l.nba.com-t.16 |
  17. | 241009 | 1 | minutes | 2 | starter | basketball_offensive_stats | Delonte | West | l.nba.com-p.842 | Dallas Mavericks | l.nba.com-t.16 |
  18. | 241009 | 1 | minutes | 2 | starter | basketball_rebounding_stats | Delonte | West | l.nba.com-p.842 | Dallas Mavericks | l.nba.com-t.16 |
  19. | 241004 | 0 | minutes | 0 | starter | basketball_defensive_stats | Delonte | West | l.nba.com-p.842 | Dallas Mavericks | l.nba.com-t.16 |
  20. | 241010 | 0 | minutes | 0 | bench | basketball_offensive_stats | Jason | Terry | l.nba.com-p.111 | Dallas Mavericks | l.nba.com-t.16 |
  21. | 241010 | 0 | minutes | 0 | bench | basketball_rebounding_stats | Jason | Terry | l.nba.com-p.111 | Dallas Mavericks | l.nba.com-t.16 |
  22. | 241005 | 0 | minutes | 0 | bench | basketball_defensive_stats | Jason | Terry | l.nba.com-p.111 | Dallas Mavericks | l.nba.com-t.16 |
  23. | 241011 | 0 | minutes | 0 | bench | basketball_offensive_stats | Brian | Cardinal | l.nba.com-p.295 | Dallas Mavericks | l.nba.com-t.16 |
  24. | 241011 | 0 | minutes | 0 | bench | basketball_rebounding_stats | Brian | Cardinal | l.nba.com-p.295 | Dallas Mavericks | l.nba.com-t.16 |
  25. | 241006 | 0 | minutes | 0 | bench | basketball_defensive_stats | Brian | Cardinal | l.nba.com-p.295 | Dallas Mavericks | l.nba.com-t.16 |
  26. | 241012 | 0 | minutes | 0 | bench | basketball_offensive_stats | Ian | Mahinmi | l.nba.com-p.1027 | Dallas Mavericks | l.nba.com-t.16 |
  27. | 241012 | 0 | minutes | 0 | bench | basketball_rebounding_stats | Ian | Mahinmi | l.nba.com-p.1027 | Dallas Mavericks | l.nba.com-t.16 |
  28. | 241007 | 0 | minutes | 0 | bench | basketball_defensive_stats | Ian | Mahinmi | l.nba.com-p.1027 | Dallas Mavericks | l.nba.com-t.16 |
  29. | 241013 | 0 | minutes | 0 | bench | basketball_offensive_stats | Rodrigue | Beaubois | l.nba.com-p.1599 | Dallas Mavericks | l.nba.com-t.16 |
  30. | 241013 | 0 | minutes | 0 | bench | basketball_rebounding_stats | Rodrigue | Beaubois | l.nba.com-p.1599 | Dallas Mavericks | l.nba.com-t.16 |
  31. | 241008 | 0 | minutes | 0 | bench | basketball_defensive_stats | Rodrigue | Beaubois | l.nba.com-p.1599 | Dallas Mavericks | l.nba.com-t.16 |
  32. | 241014 | 0 | minutes | 0 | bench | basketball_offensive_stats | Lamar | Odom | l.nba.com-p.201 | Dallas Mavericks | l.nba.com-t.16 |
  33. | 241014 | 0 | minutes | 0 | bench | basketball_rebounding_stats | Lamar | Odom | l.nba.com-p.201 | Dallas Mavericks | l.nba.com-t.16 |
  34. | 241009 | 1 | minutes | 2 | bench | basketball_defensive_stats | Lamar | Odom | l.nba.com-p.201 | Dallas Mavericks | l.nba.com-t.16 |
  35. | 241015 | NULL | minutes | 0 | starter | basketball_offensive_stats | Paul | Pierce | l.nba.com-p.220 | Boston Celtics | l.nba.com-t.1 |
  36. | 241015 | NULL | minutes | 0 | starter | basketball_rebounding_stats | Paul | Pierce | l.nba.com-p.220 | Boston Celtics | l.nba.com-t.1 |
  37. | 241010 | 0 | minutes | 0 | starter | basketball_defensive_stats | Paul | Pierce | l.nba.com-p.220 | Boston Celtics | l.nba.com-t.1 |
  38. | 241016 | 0 | minutes | 0 | starter | basketball_offensive_stats | Kevin | Garnett | l.nba.com-p.339 | Boston Celtics | l.nba.com-t.1 |
  39. | 241016 | 0 | minutes | 0 | starter | basketball_rebounding_stats | Kevin | Garnett | l.nba.com-p.339 | Boston Celtics | l.nba.com-t.1 |
  40. | 241011 | 0 | minutes | 0 | starter | basketball_defensive_stats | Kevin | Garnett | l.nba.com-p.339 | Boston Celtics | l.nba.com-t.1 |
  41. | 241017 | 0 | minutes | 0 | starter | basketball_offensive_stats | Jermaine | O`Neal | l.nba.com-p.119 | Boston Celtics | l.nba.com-t.1 |
  42. | 241017 | 0 | minutes | 0 | starter | basketball_rebounding_stats | Jermaine | O`Neal | l.nba.com-p.119 | Boston Celtics | l.nba.com-t.1 |
  43. | 241012 | 0 | minutes | 0 | starter | basketball_defensive_stats | Jermaine | O`Neal | l.nba.com-p.119 | Boston Celtics | l.nba.com-t.1 |
  44. | 241018 | 0 | minutes | 0 | starter | basketball_offensive_stats | Ray | Allen | l.nba.com-p.179 | Boston Celtics | l.nba.com-t.1 |
  45. | 241018 | 0 | minutes | 0 | starter | basketball_rebounding_stats | Ray | Allen | l.nba.com-p.179 | Boston Celtics | l.nba.com-t.1 |
  46. | 241013 | 0 | minutes | 0 | starter | basketball_defensive_stats | Ray | Allen | l.nba.com-p.179 | Boston Celtics | l.nba.com-t.1 |
  47. | 241019 | 0 | minutes | 0 | starter | basketball_offensive_stats | Rajon | Rondo | l.nba.com-p.1085 | Boston Celtics | l.nba.com-t.1 |
  48. | 241019 | 0 | minutes | 0 | starter | basketball_rebounding_stats | Rajon | Rondo | l.nba.com-p.1085 | Boston Celtics | l.nba.com-t.1 |
  49. | 241014 | 0 | minutes | 0 | starter | basketball_defensive_stats | Rajon | Rondo | l.nba.com-p.1085 | Boston Celtics | l.nba.com-t.1 |
  50. | 241020 | 0 | minutes | 0 | bench | basketball_offensive_stats | Brandon | Bass | l.nba.com-p.1007 | Boston Celtics | l.nba.com-t.1 |
  51. | 241020 | 0 | minutes | 0 | bench | basketball_rebounding_stats | Brandon | Bass | l.nba.com-p.1007 | Boston Celtics | l.nba.com-t.1 |
  52. | 241015 | NULL | minutes | 0 | bench | basketball_defensive_stats | Brandon | Bass | l.nba.com-p.1007 | Boston Celtics | l.nba.com-t.1 |
  53. | 241021 | 1 | minutes | 2 | bench | basketball_offensive_stats | Keyon | Dooling | l.nba.com-p.712 | Boston Celtics | l.nba.com-t.1 |
  54. | 241021 | 1 | minutes | 2 | bench | basketball_rebounding_stats | Keyon | Dooling | l.nba.com-p.712 | Boston Celtics | l.nba.com-t.1 |
  55. | 241016 | 0 | minutes | 0 | bench | basketball_defensive_stats | Keyon | Dooling | l.nba.com-p.712 | Boston Celtics | l.nba.com-t.1 |
  56. | 241022 | 0 | minutes | 0 | bench | basketball_offensive_stats | Greg | Stiemsma | l.nba.com-p.1874 | Boston Celtics | l.nba.com-t.1 |
  57. | 241022 | 0 | minutes | 0 | bench | basketball_rebounding_stats | Greg | Stiemsma | l.nba.com-p.1874 | Boston Celtics | l.nba.com-t.1 |
  58. | 241017 | 0 | minutes | 0 | bench | basketball_defensive_stats | Greg | Stiemsma | l.nba.com-p.1874 | Boston Celtics | l.nba.com-t.1 |
  59. | 241023 | 0 | minutes | 0 | bench | basketball_offensive_stats | Mickael | Pietrus | l.nba.com-p.624 | Boston Celtics | l.nba.com-t.1 |
  60. | 241023 | 0 | minutes | 0 | bench | basketball_rebounding_stats | Mickael | Pietrus | l.nba.com-p.624 | Boston Celtics | l.nba.com-t.1 |
  61. | 241018 | 0 | minutes | 0 | bench | basketball_defensive_stats | Mickael | Pietrus | l.nba.com-p.624 | Boston Celtics | l.nba.com-t.1 |
  62. | 241024 | 1 | minutes | 2 | bench | basketball_offensive_stats | Avery | Bradley | l.nba.com-p.1889 | Boston Celtics | l.nba.com-t.1 |
  63. | 241024 | 1 | minutes | 2 | bench | basketball_rebounding_stats | Avery | Bradley | l.nba.com-p.1889 | Boston Celtics | l.nba.com-t.1 |
  64. | 241019 | 0 | minutes | 0 | bench | basketball_defensive_stats | Avery | Bradley | l.nba.com-p.1889 | Boston Celtics | l.nba.com-t.1 |
  65. | 241025 | 1 | minutes | 2 | bench | basketball_offensive_stats | Chris | Wilcox | l.nba.com-p.278 | Boston Celtics | l.nba.com-t.1 |
  66. | 241025 | 1 | minutes | 2 | bench | basketball_rebounding_stats | Chris | Wilcox | l.nba.com-p.278 | Boston Celtics | l.nba.com-t.1 |
  67. | 241020 | 0 | minutes | 0 | bench | basketball_defensive_stats | Chris | Wilcox | l.nba.com-p.278 | Boston Celtics | l.nba.com-t.1 |
  68. +--------+-------+---------+-------+---------+-----------------------------+------------+-----------+------------------+------------------+----------------+
  69. 63 rows in set (0.14 sec)
  70.  
  71. mysql>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!