Andy_Langton - 11:40 pm on May 15, 2012 (gmt 0)
Thanks for the reply :)
To follow your steps:
I don't really understand how I should be interpreting EXPLAIN, but it gives me the results below:
Extra Using where; Using temporary; Using filesort
I guess the problem is I need to index some of the affected columns?