SQL
AخA
Use eswiki_p;
SELECT ns_name, page_title
FROM page AS pg1
AND pg1.page_namespace = ns_id
JOIN templatelinks AS tl
ON pg1.page_id = tl.tl_from
WHERE pg1.page_namespace = 14
AND tl.tl_namespace = 10
AND tl.tl_title = 'Wikiviajes_por_Venezuela_2014'
AND EXISTS (SELECT 1
FROM page AS pg2
JOIN categorylinks AS cl
ON pg2.page_id = cl.cl_from
WHERE pg2.page_namespace = 0
AND pg1.page_title = cl.cl_to);
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.