Smerp

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 178 to server version: 5.0.24

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT COUNT(fu.url)
    ->     FROM projects p LEFT OUTER JOIN builds b USING (projectId)
    ->                     LEFT OUTER JOIN publishedReleases pr USING (pubreleaseId)
    ->                     LEFT OUTER JOIN buildFiles bf USING (buildId)
    ->                     LEFT OUTER JOIN buildFilesUrlsMap USING (fileId)
    ->                     LEFT OUTER JOIN filesUrls fu USING (urlId)
    ->     WHERE (pr.timePublished IS NOT NULL OR b.timeCreated < 1157651187 OR b.timeCreated IS NULL)
    ->         AND fu.urltype = 0
    ->         AND p.hidden = 0;
+---------------+
| COUNT(fu.url) |
+---------------+
|          3827 | 
+---------------+
1 row in set (0.18 sec)

mysql> SELECT COUNT(fu.url)
    ->     FROM projects p LEFT OUTER JOIN builds b USING (projectId)
    ->                     LEFT OUTER JOIN publishedReleases pr USING (pubreleaseId)
    ->                     LEFT OUTER JOIN buildFiles bf USING (buildId)
    ->                     LEFT OUTER JOIN buildFilesUrlsMap USING (fileId)
    ->                     LEFT OUTER JOIN filesUrls fu USING (urlId)
    ->     WHERE pr.timePublished IS NOT NULL OR (b.timeCreated < 1157651187 OR b.timeCreated IS NULL)
    ->         AND fu.urltype = 0
    ->         AND p.hidden = 0;
+---------------+
| COUNT(fu.url) |
+---------------+
|          3843 | 
+---------------+
1 row in set (0.20 sec)