Untitled query #88141

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

SQL

SELECT 
    p.page_title AS Article
FROM 
    page AS p
JOIN 
    templatelinks AS tl1
    ON p.page_id = tl1.tl_from
JOIN 
    templatelinks AS tl2
    ON p.page_id = tl2.tl_from
WHERE 
    tl1.tl_target_id = (
        SELECT page_id 
        FROM page 
        WHERE page_namespace = 10 AND page_title = "Liens"
    )
    AND tl2.tl_target_id = (
        SELECT page_id 
        FROM page 
        WHERE page_namespace = 10 AND page_title = "Taxobox"
    )
    AND p.page_namespace = 0; -- Articles dans l'espace principal

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...