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 from dual;
select * from revision order by rev_timestamp limit 30;

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...
