How many projects at each repository share URL's? (05-2011)

Description

This chart shows the number of projects at each repository that share URL's as of May 2011.

Visualization

SQL Script

RF-FM

SELECT COUNT( r.proj_unixname )
FROM rf_projects r
WHERE r.real_url LIKE "%freshmeat%"
AND datasource_id= <current>;


RF-OW

SELECT COUNT( r.proj_unixname )
FROM rf_projects r
WHERE r.real_url LIKE "%objectweb%"
AND datasource_id= <current>;


RF-FSF

SELECT COUNT( r.proj_unixname )
FROM rf_projects r
WHERE r.real_url LIKE "%fsf%"
AND datasource_id= <current>;


FM-RF

SELECT COUNT( f.project_id )
FROM fm_project_homepages f
WHERE f.real_url_homepage LIKE "%rubyforge%"
AND datasource_id= <current>;


FM-OW

SELECT COUNT( f.project_id )
FROM fm_project_homepages f
WHERE f.real_url_homepage LIKE "%objectweb%"
AND datasource_id= <current>;


FM-FSF

SELECT COUNT( f.project_id )
FROM fm_project_homepages f
WHERE f.real_url_homepage LIKE "%fsf%"
AND datasource_id= <current>;


OW-RF

SELECT COUNT( o.proj_unixname )
FROM ow_projects o
WHERE o.real_url LIKE "%rubyforge%"
AND datasource_id= <current>;


OW-FM

SELECT COUNT( o.proj_unixname )
FROM ow_projects o
WHERE o.real_url LIKE "%freshmeat%"
AND datasource_id= <current>;


OW-FSF

SELECT COUNT( o.proj_unixname )
FROM ow_projects o
WHERE o.real_url LIKE "%fsf%"
AND datasource_id= <current>;


FSF-RF

SELECT COUNT( proj_unixname )
FROM fsf_projects
WHERE real_url LIKE "%rubyforge%"
AND datasource_id= <current>;


FSF-FM

SELECT COUNT( proj_unixname )
FROM fsf_projects
WHERE real_url LIKE "%freshmeat%"
AND datasource_id= <current>;


FSF-OW

SELECT COUNT( proj_unixname )
FROM fsf_projects
WHERE real_url LIKE "%objectweb%"
AND datasource_id= <current>;