Related posts by tags optimization

[René Olivo]

Hello everyone,

I'm trying to optimise a query where I have a posts table and when a post is shown I want to show other relevant posts sorted by tags frequency.

I have managed to do the query, but it shows TEMPORARY; FILESORT. If possible I want it to be just FILESORT.

Here's the code and table structure from the handy SQLFiddle:
http://sqlfiddle.com/#!2/3d163/6

Preferably I'd like the solution to be query wise since I have little control over the configuration file.

Thanks in advance :)