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 ?
FROM xf_post AS post
LEFT JOIN xf_thread AS thread ON (thread.thread_id=post.thread_id)
WHERE thread.node_id != '23'