Search titles only
By:
Home
Forums
New posts
Search forums
Articles
New articles
New comments
Search articles
Pinball DB
Pinball Tables
Pinball Games
What's new
New posts
New articles
New profile posts
New article comments
Latest activity
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Welcome Back to Digital Pinball Fans -
please read this first
For latest updates, follow Digital Pinball Fans on
Facebook
and
Twitter
Home
Forums
Farsight Studios
The Pinball Arcade / Farsight Studios
Question about how Farsight tracks table sales
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="invitro" data-source="post: 220936" data-attributes="member: 446"><p>Here is some raw MySQL output that shows the rank ("max(rank)" below) of the lowest-ranked score for each table on 2015-05-06. (And glitchy or hacky scores can be seen, but I hope there are no errors here, or I'll have some work to do.)</p><p></p><p>TotAN must have A MILLION scores by now... which means at least a million registered usernames for TPA, excluding XBox platforms. (People can and do have >1 username, but I have no idea of the average # of usernames per person. I would guess it's under 1.5, though.)</p><p></p><p>[code]</p><p>mysql> select table_id, t.abbr, min(rank), max(score), max(rank), min(score) from tpa_leaderboard l join tpa_table t on l.table_id=t.id where date='2015-05-06' group by table_id;</p><p>+----------+----------+-----------+----------------+-----------+------------+</p><p>| table_id | abbr | min(rank) | max(score) | max(rank) | min(score) |</p><p>+----------+----------+-----------+----------------+-----------+------------+</p><p>| 0 | TotAN | 1 | 76512635720 | 973060 | 922 |</p><p>| 1 | RBIoN | 1 | 37300267340 | 253292 | 0 |</p><p>| 2 | ToM | 1 | 14078474451920 | 257704 | 10050 |</p><p>| 3 | BH | 1 | 1549025135 | 66368 | 309 |</p><p>| 4 | BoP | 1 | 73712835670 | 103479 | 50000 |</p><p>| 5 | MM | 1 | 4540350587400 | 112893 | 15000 |</p><p>| 6 | CV | 1 | 3257841420 | 86943 | 69880 |</p><p>| 7 | FH | 1 | 3099025010 | 57614 | 195000 |</p><p>| 8 | MB | 1 | 41308269070 | 77722 | 65720 |</p><p>| 9 | Gorgar | 1 | 1672055480 | 74602 | 40 |</p><p>| 10 | CftBL | 1 | 312505443610 | 78715 | 1000000 |</p><p>| 11 | BK | 1 | 458512640 | 73791 | 100 |</p><p>| 12 | HD3E | 1 | 2689815940 | 72341 | 1775960 |</p><p>| 13 | Taxi | 1 | 168394480 | 71347 | 1000 |</p><p>| 14 | EatPM | 1 | 2550483880 | 73525 | 13010 |</p><p>| 15 | NGG | 1 | 91354241750 | 75738 | 30000 |</p><p>| 16 | BigShot | 1 | 193278500 | 71357 | 10 |</p><p>| 17 | SS | 1 | 72455767980 | 70239 | 5490 |</p><p>| 18 | TZ | 1 | 214795450970 | 81707 | 1089370 |</p><p>| 19 | STTNG | 1 | 1890199057550 | 87240 | 100000 |</p><p>| 20 | AFM | 1 | 979134836240 | 88586 | 85000 |</p><p>| 21 | Genie | 1 | 739001170 | 63244 | 5200 |</p><p>| 22 | DrDude | 1 | 681963180 | 28461 | 24450 |</p><p>| 23 | FirePwr | 1 | 627774000 | 26973 | 1000 |</p><p>| 24 | CC | 1 | 3203482110 | 31996 | 74280 |</p><p>| 25 | CentPark | 1 | 211080 | 27773 | 31 |</p><p>| 26 | WWater | 1 | 99934777050 | 32511 | 55000 |</p><p>| 27 | SpSh | 1 | 76844330 | 28194 | 2000 |</p><p>| 28 | Centaur | 1 | 234567890 | 27211 | 200 |</p><p>| 29 | Pin*Bot | 1 | 202119730 | 27329 | 1020 |</p><p>| 30 | CP | 1 | 5344700720 | 29240 | 50 |</p><p>| 31 | WWind | 1 | 488079650 | 27301 | 130120 |</p><p>| 32 | Flight2K | 1 | 15158160 | 20771 | 8000 |</p><p>| 33 | GoinNuts | 1 | 25272190 | 20106 | 10000 |</p><p>| 34 | T2 | 1 | 45714166080 | 39601 | 128080 |</p><p>| 35 | HH | 1 | 33017260 | 25476 | 5000 |</p><p>| 36 | TeedOff | 1 | 91139885780 | 23649 | 530000 |</p><p>| 37 | Co1812 | 1 | 47805292750 | 21412 | 20000 |</p><p>| 38 | Victory | 1 | 825849980 | 20852 | 700 |</p><p>| 39 | CBW | 1 | 26193524970 | 21061 | 500000 |</p><p>| 40 | ElDor | 1 | 360053650 | 18833 | 500 |</p><p>| 41 | FT | 1 | 9999658190 | 20265 | 71230 |</p><p>| 42 | BRose | 1 | 80073912020 | 19453 | 205210 |</p><p>| 43 | BK2K | 1 | 71200687840 | 15413 | 6020 |</p><p>| 44 | WD | 1 | 706269894190 | 17969 | 7144090 |</p><p>| 45 | HS | 1 | 281058310 | 15315 | 7000 |</p><p>| 46 | JY | 1 | 11135004350 | 17140 | 180410 |</p><p>| 47 | LCA | 1 | 2414679870 | 12341 | 5000 |</p><p>| 48 | HRC | 1 | 20424874000 | 14040 | 125000 |</p><p>| 49 | Diner | 1 | 73998483500 | 12708 | 75000 |</p><p>| 50 | BSD | 1 | 63150296660 | 16381 | 917170 |</p><p>| 51 | PotO | 1 | 1399999999 | 8716 | 44630 |</p><p>| 52 | PZone | 1 | 5321064690 | 6940 | 260230 |</p><p>| 53 | ES | 1 | 44600654370 | 6805 | 134000 |</p><p>| 54 | SST | 1 | 19999999990 | 6955 | 2219910 |</p><p>| 55 | TAF | 1 | 69394785960 | 17539 | 550010 |</p><p>| 56 | Cyclone | 1 | 58138650 | 4429 | 32060 |</p><p>| 57 | J*B | 1 | 173189263390 | 3689 | 155692150 |</p><p>+----------+----------+-----------+----------------+-----------+------------+</p><p>58 rows in set (0.22 sec)</p><p>[/code]</p></blockquote><p></p>
[QUOTE="invitro, post: 220936, member: 446"] Here is some raw MySQL output that shows the rank ("max(rank)" below) of the lowest-ranked score for each table on 2015-05-06. (And glitchy or hacky scores can be seen, but I hope there are no errors here, or I'll have some work to do.) TotAN must have A MILLION scores by now... which means at least a million registered usernames for TPA, excluding XBox platforms. (People can and do have >1 username, but I have no idea of the average # of usernames per person. I would guess it's under 1.5, though.) [code] mysql> select table_id, t.abbr, min(rank), max(score), max(rank), min(score) from tpa_leaderboard l join tpa_table t on l.table_id=t.id where date='2015-05-06' group by table_id; +----------+----------+-----------+----------------+-----------+------------+ | table_id | abbr | min(rank) | max(score) | max(rank) | min(score) | +----------+----------+-----------+----------------+-----------+------------+ | 0 | TotAN | 1 | 76512635720 | 973060 | 922 | | 1 | RBIoN | 1 | 37300267340 | 253292 | 0 | | 2 | ToM | 1 | 14078474451920 | 257704 | 10050 | | 3 | BH | 1 | 1549025135 | 66368 | 309 | | 4 | BoP | 1 | 73712835670 | 103479 | 50000 | | 5 | MM | 1 | 4540350587400 | 112893 | 15000 | | 6 | CV | 1 | 3257841420 | 86943 | 69880 | | 7 | FH | 1 | 3099025010 | 57614 | 195000 | | 8 | MB | 1 | 41308269070 | 77722 | 65720 | | 9 | Gorgar | 1 | 1672055480 | 74602 | 40 | | 10 | CftBL | 1 | 312505443610 | 78715 | 1000000 | | 11 | BK | 1 | 458512640 | 73791 | 100 | | 12 | HD3E | 1 | 2689815940 | 72341 | 1775960 | | 13 | Taxi | 1 | 168394480 | 71347 | 1000 | | 14 | EatPM | 1 | 2550483880 | 73525 | 13010 | | 15 | NGG | 1 | 91354241750 | 75738 | 30000 | | 16 | BigShot | 1 | 193278500 | 71357 | 10 | | 17 | SS | 1 | 72455767980 | 70239 | 5490 | | 18 | TZ | 1 | 214795450970 | 81707 | 1089370 | | 19 | STTNG | 1 | 1890199057550 | 87240 | 100000 | | 20 | AFM | 1 | 979134836240 | 88586 | 85000 | | 21 | Genie | 1 | 739001170 | 63244 | 5200 | | 22 | DrDude | 1 | 681963180 | 28461 | 24450 | | 23 | FirePwr | 1 | 627774000 | 26973 | 1000 | | 24 | CC | 1 | 3203482110 | 31996 | 74280 | | 25 | CentPark | 1 | 211080 | 27773 | 31 | | 26 | WWater | 1 | 99934777050 | 32511 | 55000 | | 27 | SpSh | 1 | 76844330 | 28194 | 2000 | | 28 | Centaur | 1 | 234567890 | 27211 | 200 | | 29 | Pin*Bot | 1 | 202119730 | 27329 | 1020 | | 30 | CP | 1 | 5344700720 | 29240 | 50 | | 31 | WWind | 1 | 488079650 | 27301 | 130120 | | 32 | Flight2K | 1 | 15158160 | 20771 | 8000 | | 33 | GoinNuts | 1 | 25272190 | 20106 | 10000 | | 34 | T2 | 1 | 45714166080 | 39601 | 128080 | | 35 | HH | 1 | 33017260 | 25476 | 5000 | | 36 | TeedOff | 1 | 91139885780 | 23649 | 530000 | | 37 | Co1812 | 1 | 47805292750 | 21412 | 20000 | | 38 | Victory | 1 | 825849980 | 20852 | 700 | | 39 | CBW | 1 | 26193524970 | 21061 | 500000 | | 40 | ElDor | 1 | 360053650 | 18833 | 500 | | 41 | FT | 1 | 9999658190 | 20265 | 71230 | | 42 | BRose | 1 | 80073912020 | 19453 | 205210 | | 43 | BK2K | 1 | 71200687840 | 15413 | 6020 | | 44 | WD | 1 | 706269894190 | 17969 | 7144090 | | 45 | HS | 1 | 281058310 | 15315 | 7000 | | 46 | JY | 1 | 11135004350 | 17140 | 180410 | | 47 | LCA | 1 | 2414679870 | 12341 | 5000 | | 48 | HRC | 1 | 20424874000 | 14040 | 125000 | | 49 | Diner | 1 | 73998483500 | 12708 | 75000 | | 50 | BSD | 1 | 63150296660 | 16381 | 917170 | | 51 | PotO | 1 | 1399999999 | 8716 | 44630 | | 52 | PZone | 1 | 5321064690 | 6940 | 260230 | | 53 | ES | 1 | 44600654370 | 6805 | 134000 | | 54 | SST | 1 | 19999999990 | 6955 | 2219910 | | 55 | TAF | 1 | 69394785960 | 17539 | 550010 | | 56 | Cyclone | 1 | 58138650 | 4429 | 32060 | | 57 | J*B | 1 | 173189263390 | 3689 | 155692150 | +----------+----------+-----------+----------------+-----------+------------+ 58 rows in set (0.22 sec) [/code] [/QUOTE]
Verification
Post reply
Members online
No members online now.
Latest posts
Sale speculation thread
Latest: gameaddict4life
Yesterday at 12:46 AM
Pinball FX (4)
Master List of Issues: Pinball FX
Latest: gameaddict4life
Yesterday at 12:40 AM
Pinball FX (4)
Home
Forums
Farsight Studios
The Pinball Arcade / Farsight Studios
Question about how Farsight tracks table sales
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top