select T_GPS_OBJECT_SUBSCRIPTIONS."SUBSCRIPTION_ID",T_GPS_OBJECT_SUBSCRIPTIONS."OBJECT_ID",T_GPS_OBJECT_SUBSCRIPTIONS."USER_ID",T_GPS_OBJECT_SUBSCRIPTIONS."STATUS",T_GPS_OBJECT_SUBSCRIPTIONS."DISPLAY_NAME",T_GPS_OBJECT_SUBSCRIPTIONS."IS_FIXED_WIDGET",T_GPS_OBJECT_SUBSCRIPTIONS."ORDER_ID" from (select T_USERS.User_Id from TAS.T_ROLES T_ROLES,TAS.T_USERS T_USERS,TAS.T_USER_ROLES where T_USERS.user_id = T_USER_ROLES.user_id and T_ROLES.role_id = T_USER_ROLES.role_id and T_USERS.User_Id NOT IN (1004,3057,2207,433,382,1905,1037,412,385) and t_roles.role_name = 'EIS_EMPLOYEE') Users, T_GPS_OBJECT_SUBSCRIPTIONS T_GPS_OBJECT_SUBSCRIPTIONS where T_GPS_OBJECT_SUBSCRIPTIONS.Object_Id in (61,47,1) AND T_GPS_OBJECT_SUBSCRIPTIONS.user_id= Users.user_id