non-empty cat redirects

SQL

Use specieswiki_p;
Select page_title as "specieswiki page", count(cl_from) from page inner join categorylinks on page_title = cl_to
Where page_namespace = 14
And page_is_redirect = 1
Group by page_title;

Use enwiki_p;
Select page_title as "enwiki page", count(cl_from) from page inner join categorylinks on page_title = cl_to
Where page_namespace = 14
And page_is_redirect = 1
Group by page_title;

Use dewiki_p;
Select page_title as "dewiki page", count(cl_from) from page inner join categorylinks on page_title = cl_to
Where page_namespace = 14
And page_is_redirect = 1
Group by page_title;

Use frwiki_p;
Select page_title as "frwiki page", count(cl_from) from page inner join categorylinks on page_title = cl_to
Where page_namespace = 14
And page_is_redirect = 1
Group by page_title;

Use enwikibooks_p;
Select page_title as "enwikibooks page", count(cl_from) from page inner join categorylinks on page_title = cl_to
Where page_namespace = 14
And page_is_redirect = 1
Group by page_title;

Use ruwikibooks_p;
Select page_title as "ruwikibooks page", count(cl_from) from page inner join categorylinks on page_title = cl_to
Where page_namespace = 14
And page_is_redirect = 1
Group by page_title;

Use ruwikinews_p;
Select page_title as "ruwikinews page", count(cl_from) from page inner join categorylinks on page_title = cl_to
Where page_namespace = 14
And page_is_redirect = 1
Group by page_title;

#######

Use afwiki_p;
Select page_title as "afwiki page", count(cl_from) from page inner join categorylinks on page_title = cl_to
Where page_namespace = 14
And page_is_redirect = 1
Group by page_title;

Use metawiki_p;
Select page_title as "metawiki page", count(cl_from) from page inner join categorylinks on page_title = cl_to
Where page_namespace = 14
And page_is_redirect = 1
Group by page_title;
SQL

Checking query status...
