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;
USE dewikisource_p;
SELECT (SELECT COUNT(*) FROM categorylinks WHERE cl_to='Fertig' AND cl_type='page')+
       (SELECT COUNT(*) FROM categorylinks WHERE cl_to='Korrigiert' AND cl_type='page') 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 WHERE cl_to='Uwierzytelniona' AND cl_type='page' UNION
SELECT 'Skorygowana',COUNT(*) FROM categorylinks WHERE cl_to='Skorygowana' AND cl_type='page' UNION
SELECT 'Przepisana',COUNT(*) FROM categorylinks WHERE cl_to='Przepisana' AND cl_type='page' UNION
SELECT 'Problemy',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' 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 cl_type='page' UNION
SELECT 'Korrigiert',COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Korrigiert' AND cl_type='page' UNION
SELECT 'Unkorrigiert',COUNT(*) FROM categorylinks JOIN page ON cl_from=page_id WHERE cl_to='Unkorrigiert' AND cl_type='page';
SELECT * FROM categorylinks JOIN page ON cl_from=page_id LIMIT 20;
SQL

Checking query status...
