mysql> select count(*) from trackers;
+----------+
| count(*) |
+----------+
|     1277 |
+----------+
1 row in set (0,00 sec)

mysql> select count(distinct tracker_id) from issues;
+----------------------------+
| count(distinct tracker_id) |
+----------------------------+
|                       1181 |
+----------------------------+
1 row in set (0,98 sec)

mysql> SELECT t.url as name, COUNT(DISTINCT(i.id)) AS issues
FROM  issues i, trackers t
WHERE i.tracker_id = t.id AND
i.submitted_on >= '2013-05-01' AND i.submitted_on < '2015-11-21'
GROUP BY t.url ORDER BY issues DESC;

mysql> SELECT COUNT(DISTINCT i.tracker_id) as repositories FROM issues i, trackers t WHERE i.tracker_id = t.id and i.submitted_on >= '2013-05-01';
+--------------+
| repositories |
+--------------+
|         1142 |
+--------------+
1 row in set (0,22 sec)

SELECT count(distinct(t.id)) as repositories 
FROM sh_mediawiki.profiles pro , issues i , people_uidentities pup , trackers t 
WHERE  i.submitted_on>='2013-05-01' AND  i.submitted_on<'2015-11-20' 
AND pro.name <> 'wm-bot' and pro.name <> 'jenkins-bot' and pro.uuid = pup.uuid and i.submitted_by = pup.people_id 
and pro.name <> 'Translation updater bot' and pro.name <> 'gerrit-wm' and pro.name <> 'wikibugs_' 
and pro.name <> 'Jenkins-mwext-sync' and pro.name <> 'wikibugs' and pro.name <> 'L10n-bot' 
and i.summary not like '%WIP%' and i.tracker_id = t.id and i.id not in
                       (select distinct(i.id) as issue_id
                       from issues i,
                            changes ch
                       where i.submitted_by = ch.changed_by and
                             i.id = ch.issue_id and
                             ch.field = 'status' and
                             ch.new_value = 'MERGED')
                     and pro.name <> 'Wikimedia Jenkins Bot' and pro.is_bot<>1