This query is marked as a draft This query has been published by Talueses.

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.

Checking query status...