বছর অনুসারে বাংলা উইকিপিডিয়ায় নিবন্ধ তৈরি

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

SQL

SELECT	count(*)
FROM	page AS article
WHERE	article.page_is_redirect=0
		AND	article.page_namespace=0
        AND page_len > 20000
		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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...