Query taking too long to execute.

I understand. I just want to know if there is an issue with the table aliasing and joins which is drastically effecting the query performance.