what is the mysql query to remove topics& messages with less than x views

[ryansdistrict]

Helllo
my site is getting out of control
i want to run a mysql query that will remove all topics which have less than x views and from specific forum id
for example i want to remove topics with less than 5 views in the news forum whose id is 5
i want to remove topics form the database from both topics and messages tables which are under the condition mentioned

What is the query that does this

Thank you

[vbgamer45]

There is not an easy single sql query but you could use the removepost topic functions built in smf.
Do a lookup in the topics for the category id and remove the topics that have less than a certain amount of views in a topic.

If you do it via sql likely things won't be removed completely, stats wrong etc.