Untitled query #73468

SQL

SELECT DISTINCT(page_title)
FROM templatelinks
JOIN page ON page_id = tl_from
LEFT JOIN imagelinks ON il_to = page_title
LEFT JOIN categorylinks ON cl_from = page_id
WHERE tl_namespace = 10
AND tl_title = 'שימוש הוגן'
AND page_namespace = 6
AND page_title NOT IN (
    SELECT DISTINCT(pl_title)
    FROM pagelinks
    WHERE pl_namespace = 0
)
AND (
    il_to IS NULL OR il_from_namespace <> 0
)
AND (
    cl_to IS NULL OR NOT EXISTS (
        SELECT 1
        FROM templatelinks
        WHERE tl_namespace = 10
        AND tl_title = 'שימוש הוגן'
        AND tl_from = cl_from
    )
);
SQL

Checking query status...
