Part 1

1. login to Admin Console
2. go to User Management → Users section
3. reset all filters (if there are any)
4. open Debugger
5. confirm, that grid count query looks like this:

SELECT COUNT(*) AS count
FROM 52x_Users
WHERE ((52x_Users.UserType = 0))
LIMIT 0,1 

Plan 2

1. open \UsersEventHandler::SetCustomQuery method for editing
   1. revert any non-committed changes
   2. add $object->addFilter('testing_filter', 'img.DefaultImg = 0'); line after $object variable was initialized
   3. save changes
2. login to Admin Console
3. go to User Management → Users section
4. reset all filters (if there are any)
5. open Debugger
6. confirm, that grid count query looks like this:

SELECT COUNT(*) AS count
FROM 52x_Users
LEFT JOIN 52x_CatalogImages img ON img.ResourceId = 52x_Users.ResourceId AND img.DefaultImg = 1
WHERE ((img.DefaultImg = 0) AND (52x_Users.UserType = 0))
LIMIT 0,1

Plan 3

1. open \UsersEventHandler::SetCustomQuery method for editing
   1. revert any non-committed changes
   2. add $object->AddGroupByField('img.ImageId'); line after $object variable was initialized
   3. save changes
2. login to Admin Console
3. go to User Management → Users section
4. reset all filters (if there are any)
5. open Debugger
6. confirm, that grid count query looks like this:

SELECT COUNT(*) AS count
FROM 52x_Users
LEFT JOIN 52x_CatalogImages img ON img.ResourceId = 52x_Users.ResourceId AND img.DefaultImg = 1
WHERE ((52x_Users.UserType = 0))
GROUP BY img.ImageId

v1.1

• changed SQLs in Part 2 and Part 3 to have (52x_Users.UserType = 0) in the WHERE clause