First lets locate possible bottlenecks (not neccessarily to do it in this order, but it’s neccessary to review it):

1)Are there unnecessary ugly joins that can be avoided by breaking huge...