SQL result in template?

[MDK]

Sooo new I need a pro to help me here

I have this SQL query where the results should be used in a template for some forum stats I want to display.
How do I get a variable which I can use in that particular template ?
Thanks

Query:
SELECT COUNT(*)
FROM xf_post AS post
LEFT JOIN xf_thread AS thread ON (thread.thread_id=post.thread_id)
WHERE thread.node_id != '23'

 

[wang]

This would require a custom add on. Basically you will have to add the query in the model file, then in the controller file you can call it and then register the variable so you can use it in the template.