Reflecting to client changes in APIs an Db

Improvement in few queries, adding new queries, updating table.