GilaMonster (8/9/2014)

---

faisalfarouqi (8/9/2014)

---

I would also request that if some suggestions around refactoring or maybe reordering of joins could be made to retrieve data quickly.

Reordering of joins won't do a thing, the order of joins does not matter. Refactoring's not currently indicated, the obvious problem needs to be addressed first.