Untitled query #18308

SQL

USE plwikisource_p;

SELECT (SELECT COUNT(*) FROM categorylinks WHERE cl_to='Uwierzytelniona' AND cl_type='page')+
       (SELECT COUNT(*) FROM categorylinks WHERE cl_to='Skorygowana' AND cl_type='page') AS N;
SELECT * FROM revision JOIN page ON rev_page=page_id WHERE rev_comment RLIKE ' Skorygowana ' ORDER BY rev_timestamp DESC LIMIT 84;

SELECT * FROM category WHERE cat_title='Uwierzytelniona';
SELECT COUNT(*) FROM categorylinks WHERE cl_to='Uwierzytelniona' AND cl_type='page';
SELECT * FROM category WHERE cat_title='Skorygowana';
SELECT COUNT(*) FROM categorylinks WHERE cl_to='Skorygowana' AND cl_type='page';
SELECT * FROM category WHERE cat_title='Przepisana';
SELECT COUNT(*) FROM categorylinks WHERE cl_to='Przepisana' AND cl_type='page';
SELECT * FROM category WHERE cat_title='Problemy';
SELECT COUNT(*) FROM categorylinks WHERE cl_to='Problemy' AND cl_type='page';
SELECT * FROM category WHERE cat_title='Indeks';
SELECT COUNT(*) FROM categorylinks WHERE cl_to='Indeks' AND cl_type='page';
#SELECT * FROM categorylinks WHERE cl_to='Uwierzytelniona' LIMIT 3;

USE dewikisource_p;
SELECT * FROM category WHERE cat_title='Fertig';
SELECT COUNT(*) FROM categorylinks WHERE cl_to='Fertig' AND cl_type='page';
SELECT * FROM category WHERE cat_title='Korrigiert';
SELECT COUNT(*) FROM categorylinks WHERE cl_to='Korrigiert' AND cl_type='page';
SELECT * FROM category WHERE cat_title='Unkorrigiert';
SELECT COUNT(*) FROM categorylinks WHERE cl_to='Unkorrigiert' AND cl_type='page';
SQL

Checking query status...
