Show Results:

SELECT COUNT(DISTINCT main.id) FROM Tickets main CROSS JOIN Users Users_3 JOIN Groups Groups_1  ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Type = 'Requestor' ) AND ( Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2  ON ( CachedGroupMembers_2.MemberId = Users_3.id ) AND ( CachedGroupMembers_2.GroupId = Groups_1.id )  WHERE (Users_3.EmailAddress LIKE '%fttb-tv-netsupport@netcologne.de%') AND (main.Status != 'deleted') AND ( ( CachedGroupMembers_2.id IS NOT NULL ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)

+-------------------------+
| COUNT(DISTINCT main.id) |
+-------------------------+
|                     276 |
+-------------------------+
1 row in set (0.02 sec)


Search results grouped by Status (pre shrink_cgm_table.pl):

SELECT DISTINCT COUNT(main.id) AS id, main.Status AS status FROM Tickets main CROSS JOIN Users Users_3 JOIN Groups Groups_1  ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Type = 'Requestor' ) AND ( Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2  ON ( CachedGroupMembers_2.MemberId = Users_3.id ) AND ( CachedGroupMembers_2.GroupId = Groups_1.id )  WHERE (Users_3.EmailAddress LIKE '%fttb-tv-netsupport@netcologne.de%') AND (main.Status != 'deleted') AND ( ( CachedGroupMembers_2.id IS NOT NULL ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)  GROUP BY main.Status

+-----+----------+
| id  | status   |
+-----+----------+
| 118 | rejected |
| 430 | resolved |
|   4 | stalled  |
+-----+----------+
3 rows in set (0.02 sec)


Search results grouped by Status (post shrink_cgm_table.pl):

SELECT DISTINCT COUNT(main.id) AS id, main.Status AS status FROM Tickets main CROSS JOIN Users Users_3 JOIN Groups Groups_1  ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Type = 'Requestor' ) AND ( Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2  ON ( CachedGroupMembers_2.MemberId = Users_3.id ) AND ( CachedGroupMembers_2.GroupId = Groups_1.id )  WHERE (Users_3.EmailAddress LIKE '%fttb-tv-netsupport@netcologne.de%') AND (main.Status != 'deleted') AND ( ( CachedGroupMembers_2.id IS NOT NULL ) ) AND (main.Type = 'ticket') AND (main.EffectiveId = main.id)  GROUP BY main.Status

+-----+----------+
| id  | status   |
+-----+----------+
|  59 | rejected |
| 215 | resolved |
|   2 | stalled  |
+-----+----------+
3 rows in set (0.01 sec)