How can I optimize a slow MySQL query involving multiple large tables