I noticed a couple of queries in my slow query log. They have one thing in common:
AND p.POST_POSTED_TIME > '880798070' AND p.POST_POSTED_TIME < '1353751670'
This could be measurably improved by using BETWEEN:
AND p.POST_POSTED_TIME BETWEEN '880798070'AND '1353751670'