activity_of_bureaucrats

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

SQL

SELECT cl.cl_to
FROM categorylinks cl
LEFT JOIN (
    SELECT DISTINCT ll.ll_from AS page_id, page.page_title
    FROM langlinks ll
    JOIN page ON page.page_id = ll.ll_from
    WHERE ll.ll_lang = "ar"
    AND page.page_namespace = 14
) llp ON cl.cl_to = llp.page_title
WHERE llp.page_title IS NULL
LIMIT 5;

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...