Untitled query #18308

SQL

USE plwikisource_p;

SELECT 2*(SELECT COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Uwierzytelniona' AND page_namespace=100)+
       (SELECT COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Skorygowana' AND page_namespace=100) AS N;
USE dewikisource_p;
SELECT 2*(SELECT COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Fertig' AND page_namespace=102)+
       (SELECT COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Korrigiert' AND page_namespace=102) AS N;

USE plwikisource_p;
SELECT * FROM category WHERE cat_title='Uwierzytelniona' UNION
SELECT * FROM category WHERE cat_title='Skorygowana' UNION
SELECT * FROM category WHERE cat_title='Przepisana' UNION
SELECT * FROM category WHERE cat_title='Problemy';
SELECT 'Uwierzytelniona',COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Uwierzytelniona' AND page_namespace=100 UNION
SELECT 'Skorygowana',COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Skorygowana' AND page_namespace=100 UNION
SELECT 'Przepisana',COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Przepisana' AND page_namespace=100 UNION
SELECT 'Problemy',COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Problemy' AND page_namespace=100;
SELECT * FROM category WHERE cat_title='Indeks';
SELECT COUNT(*) FROM categorylinks WHERE cl_to='Indeks' AND cl_type='page';

USE dewikisource_p;
SELECT * FROM category WHERE cat_title='Fertig' UNION
SELECT * FROM category WHERE cat_title='Korrigiert' UNION
SELECT * FROM category WHERE cat_title='Unkorrigiert';
SELECT 'Fertig',COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Fertig' AND page_namespace=102 UNION
SELECT 'Korrigiert',COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Korrigiert' AND page_namespace=102 UNION
SELECT 'Unkorrigiert',COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Unkorrigiert' AND page_namespace=102;
SQL

Checking query status...
