Need to optimize a MySQL query See it here: http://pastebin.com/hTD17gau The problem is, EXPLAIN says: Using where; Using temporary; Using filesort Also the query takes a long time. Need to speed… (Budget: $30-$250 USD, Jobs: Joomla, MySQL, PHP)
