added sql for most repository requests