test wikidata - Quarry

SQL

USE rowiki_p;/*
SELECT * FROM page join categorylinks 
ON cl_from = page_id 
where page_title = "Juan_Albín"; #group by page_title

SELECT count(cl_to) FROM categorylinks join page
ON cl_from = page_id 
where page_title = "Juan_Albín"; #group by page_title
*/
SELECT page_title FROM page join categorylinks
ON cl_from = page_id
join templatelinks on page_id = tl_from and page_namespace = tl_from_namespace
where page_namespace = 0 and tl_namespace = 10 and tl_title = "dda" 
and count(cl_to) < 5; #group by page_title
SQL

Checking query status...
