completed query methods.