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
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.