A few more query optimizations; Adds a default microsite url [MJ-369]