I ve got this query getting my forum so slow.
SELECT COUNT(*) AS count, contentid, varname FROM dbtech_thanks_entry AS entry, (SELECT postid FROM post WHERE threadid = 80911 AND visible IN (1) ) AS tmp WHERE entry.contenttype = 'post' AND entry.varname = 'likes' AND contentid = tmp.postid GROUP...