add class methods for common queries