added staticmethods for common queries