For some reason, after adding 2 more `ORDER BY`, my query became very slow. Can someone help me to fix it? I really need to use the following `ORDER BY` clause:

```
ORDER BY candidates.user_id DESC, candidates.usr_type ASC, all_users.user_id DESC

```