Count hands in DB?

[Gabethebabe]

Is there a way to count the number of hands I have stored in my database?
If it is, is it also possible to count the number of hands per stakes?

Thanks.

[e306]

http://208.109.95.123/faq/afmviewfaq.aspx?faqid=19

[Gabethebabe]

Kewl! Now how can I count just the NL100 hands, for example?

[e306]

you have to play around with the SQL-query.
if you know sql: do the same query, group by gametype and left join with "gametypes".

if you downt know how sql works, tell me and i'll look at the query tomorrow.

[Gabethebabe]

you have to play around with the SQL-query.
if you know sql: do the same query, group by gametype and left join with "gametypes".

if you downt know how sql works, tell me and i'll look at the query tomorrow.

I know some basic SQL, but at the moment we start with LEFT JOIN I´m afraid it´s out of my knowledge.

Im´interested in couting based on stakes and if possible on month, to know how much I´ve datamined in a month

[e306]

ok, that does it:

SELECT gametypes.gametypedescription,count(*) FROM pokerhands LEFT JOIN gametypes ON pokerhands.gametype_id = gametypes.gametype_id GROUP BY gametypes.gametypedescription