连接表中的mySQL ORDER BY

Ok, so i have the following schema and query which is very slow (when using real data) because of the ORDER BY:Ok, so i have the following schema and query wh