refactoring: create text constants for select queries