Get players who have new hands since x

[MrFlibble]

I'm trying to get a list of players who have had new hands imported since a particular date. I've come up with this which works but is quite slow.

Code: Select all

SELECT DISTINCT holdem_hand_player_detail.id_player
FROM holdem_hand_player_statistics, holdem_hand_summary
WHERE holdem_hand_player_statistics.id_hand = holdem_hand_summary.id_hand
AND holdem_hand_summary.date_imported >= '2008-05-27 00:00:53'

Is there another better way to do it?

[WhiteRider]

You could do this easily with a Custom Report (or even just using the standard filters) and if you want it outside PT3 you can Export it..

[MrFlibble]

I'd like to do this directly from the database. If PT3 can do it a better way must it mean there is a better way to do it with a query?