Liczba stron w przestrzeni Strona w pl.ws i de.ws

SQL

USE plwikisource_p;
SELECT NOW() AS czas, COUNT(*) AS ile FROM page WHERE page_namespace = 100;
SELECT cat_title, COUNT(*) AS ilosc
  FROM category JOIN categorylinks ON cat_title=cl_to
  WHERE cl_to IN ('Uwierzytelniona','Skorygowana') AND cl_type='page'
  GROUP BY cl_to;
SELECT 'RAZEM', SUM(ilosc) FROM (SELECT cat_title, COUNT(*) AS ilosc
  FROM category JOIN categorylinks ON cat_title=cl_to
  WHERE cl_to IN ('Uwierzytelniona','Skorygowana') AND cl_type='page'
  GROUP BY cl_to) AS A;

use dewikisource_p;
SELECT cat_title, COUNT(*) AS ilosc
  FROM category JOIN categorylinks ON cat_title=cl_to JOIN page ON page_id=cl_from
  WHERE cl_to IN ('Fertig','Korrigiert') AND cl_type='page' AND page_namespace=102
  GROUP BY cl_to;
SELECT 'RAZEM', SUM(ilosc) FROM (SELECT cat_title, COUNT(*) AS ilosc
  FROM category JOIN categorylinks ON cat_title=cl_to JOIN page ON page_id=cl_from
  WHERE cl_to IN ('Fertig','Korrigiert') AND cl_type='page' AND page_namespace=102
  GROUP BY cl_to) AS A;
SQL

Checking query status...
