Doc of templates which are in Dokumentace šablon category and at least one another category

SQL

use cswiki_p;
select concat("Šablona:", page_title) from page where page_title like "%/doc" and page_namespace=10 and page_id in (select cl_from from categorylinks where cl_to="Dokumentace_šablon" and cl_from in (select cl_from from categorylinks group by cl_from having count(*) <=2)) limit 5;

select * from categorylinks where cl_from in (select page_id from page where page_namespace=10 and page_title="Commonscat_v_tabulce/doc");

select * from categorylinks where cl_from in (select page_id from page where page_namespace=10 and page_title="Commonscat_v_tabulce/doc") group by cl_from having count(*) <2;

SQL

Checking query status...