Query optimization

Any hint? I’m really stuck in trying to optimize this server.