How to see total hand count for specific risks?

[4entourage]

Hey guys
How can I see a specific hand count for a certain risk?
I know
"Select count(*) from pokerhands" will give me a total overall count.

What I want to do is know how to find out how many
Ex 1: PLO - Heads Up Only - .25/.50 only
Ex 2: NLHE - 6 man only - $1/$2 only

etc
Bascially any type any risk any blind structure.
Anyone got a code I can just switch those figures and it can spit me out a number in query tool?

[morny]

i dont know how to write the sql query but this might help

in gametype TABLE pokergame = type of overall game
eg

pokergame = 1; Holdem
pokergame = 2; Omaha Hi
pokergame = 3; Omaha 08

pokergametype refers to the the gametype i.e NL, Limit, Rush etc

Think 1 is NL, 2 is limit etc wont be hard to figure out

Finally you can find out the limit via the bigblind amount in the same table, that tells you 50 for 50c or 100 for $1, if you want the more friendly output its in the gametypedescription column and that will show $0.50/1 nl etc

All that is in the gametype table. Hope it helps

[4entourage]

What is the command to extract hands by a specific number?
AKA I want to extract ONLY 200 hands?

[netsrak]

What do you mean with extract? Count the hands via SQL or export them from the database?