How to work out who's multitabling from raw PT stats?

[BlueBear]

As a multi-tabler (12 tables) myself with a largish PT database, is there any statistical method that I can work approximately how many tables they are playing at one go from raw PT stats?

Feedback much appreciated.

[MSPChris]

A lot depends on the site you are collecting data from. If the site you're playing on support data collection, you can set your preferences so that you are filtering over only the past couple of hours.

Set the filter, and go to the Summary tab -- you can see how many sessions a player is playing at a given time. when you see a player with a large number of sessions, you can select that player to see exactly where and when they're playing, and how they are doing.

[MSPChris]

More....

Here's a postgres query that I use to identify big current losers -- you can sort this data differently to find multi-tablers, etc.

Notes on the query:

1) you will have to find the correct value for game_level_id in your own PT database (you can get that value from PT itself

2) sort the results on screen_name to find mulit-tablers, and more importantly, multi-tablers that are running badly.



SELECT session.session_id,
players.screen_name,
session.session_start,
session.session_end,
session.table_name,
game_level.game_level_desc,
session.seat_number,
session.amount_won as amt_won,
session.total_hands
FROM session, game_level, players, poker_sites
WHERE session.game_level_id = game_level.game_level_id AND
session.player_id = players.player_id AND
session.site_id = poker_sites.site_id AND ( session.game_level_id IN (18) ) AND ((session.session_start > '2007-04-05 17:00:00'))
order by table_name, amt_won

[MSPChris]

One more note....

The thing i hate about the query up above is that my [censored] screen name keep showing up at the top of the list.

I think it's a bug... but I'm working on it.... [img]/images/graemlins/smile.gif[/img]

[TheIrishThug]

Not tested, but should be what you need.

<font class="small">Code:</font><hr /><pre>SELECT session.session_id,
players.screen_name,
session.session_start,
session.session_end,
session.table_name,
game_level.game_level_desc,
session.seat_number,
session.amount_won as amt_won,
session.total_hands
FROM session, game_level, players, poker_sites
WHERE session.game_level_id = game_level.game_level_id AND
session.player_id = players.player_id AND
session.player_id &lt;&gt; (SELECT player_id FROM players WHERE screen_name = 'YOUR_SCREEN_NAME')
session.site_id = poker_sites.site_id AND ( session.game_level_id IN (18) ) AND ((session.session_start &gt; '2007-04-05 17:00:00'))
order by table_name, amt_won [/CODE]

[MSPChris]

Irish -- i'm really sorry....

Thank you for the help but if you notice the order by clause, i usually run it with amt_won sorted first...

because of the default sort order, the biggest losers show up at the top.

That's why my name is up there when I run the query... I meant the last post as a joke.

Thank you for taking the time to answer though. Again i'm sorry....

(I tried to PM this to you but your inbox was full....)

[TheIrishThug]

My reading comprehension, poor, imo.

Thanks for letting me know about the pm box.