Category pages with both commonscat and wikidatacommons templates

SQL

USE huwiki_p;
SELECT page.page_title#, wdcat.tl_title, ccat.tl_title
FROM page
#inner join templatelinks as ccat
#on ccat.tl_from = page.page_id
#inner join templatelinks as wdcat
#on wdcat.tl_from = page.page_id
#WHERE page.page_namespace = 14
#and wdcat.tl_title = 'Wikidatacommons'
#and (ccat.tl_title = 'Commonscat' or ccat.tl_title = 'Commonskat')
WHERE page_namespace = 14 
	AND page_id IN (
    	SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 AND (tl_title = 'Commonscat' OR tl_title = 'Commonskat')
	)
    AND page_id IN (
    	SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 AND (tl_title = 'Wikidatacommons')
    );

SQL

Checking query status...