Fork of Mainspace articles without talk pages by Anerka
This query is marked as a draft This query has been published by Sridhar G.

SQL

​x
 
SELECT DISTINCT concat("# [[",page_title,"]]") as sayfalar
FROM    page AS article
WHERE   article.page_is_redirect=0
        AND article.page_namespace=0
        AND NOT EXISTS
        (
            SELECT 1
            FROM    page AS talkpage
            WHERE   talkpage.page_title=article.page_title
            AND     talkpage.page_namespace=1
            LIMIT 1
        )
        AND NOT EXISTS
        (
            SELECT 1
            FROM    page_props AS props
            WHERE   props.pp_propname = 'disambiguation'
            AND     props.pp_page = article.page_id
            LIMIT 1
        )
​
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
All SQL code is licensed under CC0 License.

Checking query status...