Could someone more DB-savvy than I please create a SQL script to be used in pgAdmin's quety tool which will return tourney ID numbers of those which list a table type of N/A?

I've noticed that tourneys with incomplete summaries seem to return this table type until updated with complete summaries, and the inc summary script I found elsewhere is not 100% accurate. TIA

The query you want is:

select id_tourney from tourney_holdem_summary where id_table_type = 0;

Hmmm...doesn't seem to work. I only have 2 incomplete summaries at the moment, and this query returns 168 results, all 3-digit numbers.

That query works correctly for me.
Make sure the correct database is expanded in PGAdmin then click the SQL icon in the PGAdmin toolbar, paste the query into the top section and click the play icon.

Ok, I figured it out.

Kraada's original query (which helped me get on the right track -- thanks!) seems to return PT3's tourney number (1 for first tourney recorded, 2 for second, etc., I am assuming). I need the tourney ID's from the sites themselves.

Also, the reason I am getting so many more results than expected is because of old FTP tourneys in my DB. I should have realized this before since I only want PS Tourneys in the results.

So, I re-worked it like this to return PS tourney numbers only:

select tourney_holdem_summary.tourney_no
from tourney_holdem_summary where id_table_type = 0
AND tourney_holdem_summary.id_site in (100)

Crude, but works like a champ so far!

Thanks for your help, guys. I know I suck at DB stuff, so I appreciate your patience.

Cool - glad you got what you want!