SQL Query to get view counts of Thread

[kh99]

Well, you could just get the "views" column from the thread table:

SELECT views FROM thread WHERE threadid=104216

But if you have the "Update Thread Views Immediately" setting set to No, then that count won't contain the views within the last hour. They're collected up in the threadviews table, then once an hour they're counted and added to the value in the thread table. So that query you have is just counting the views since the last time the Thread Views scheduled task ran.