removed distinct and added where clause