consolidated queries