changed select statements to explicitly name fields