-replaced all local sql queries with constants