Thanks for the update!

I get this tho....

Invalid SQL:
SELECT COUNT(*) as total
FROM tutorials
WHERE tutcat ='7' and tutmodded = '1'
mysql error: Unknown column 'tutmodded' in 'where clause'

Run this query:
[sql]
ALTER TABLE tutorials ADD tutmodded INT(6)
[/SQL]

Yes, now it works!
But I lost all the tutorials already in there.....

Really? How odd. Did you do anything else?

No...
They just got zero'd out sort of...

If I look in the admin panel I can still see the stats, like there should be something there, but if I click the link for most viewed tutorial.... it takes me to view a tutorial that is not there.

They might be unmoderated. Go to the moderation page in the AdminCP, see if they are there.

No unmoderated tuts.
10 tutorials (0 unmoderated)

edit: and if I click edit tutorial in the ADminCP... I can read the actual tut

Run this query:
[SQL]
SELECT *
FROM tutorials
[/SQL]

See if there is a result. Hopefully they are still in the database.

That did not help...

If I enter tut manager - modify - I can see them listed. If I click a link - I do see the actual tutorial text... so I guess they are there...
Everything looks OK in the adminCP.

But did you get any results from the query?