Untitled query #18308

SQL

USE zhwikibooks_p;
select * from page where page_id=15790;
select * from categorylinks where cl_to = 'Blender 3D︰从入门到精通';
SELECT * FROM page JOIN categorylinks ON page_id=cl_page AND cl_to LIKE '% %';
/*
use plwikisource_p;
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='Nieskorygowana';
select count(*) from categorylinks where cl_to='Nieskorygowana' 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;
*/
SQL

Checking query status...
