updated sql queries, eliminated SELECT * queries and replaced with listed fields.
Also tables which contain columns like "update, delete" have to have table alias.