Fork of Largest AfD talk pages by JPxG
This query is marked as a draft This query has been published by JPxG.

SQL

AخA
 
SELECT COUNT(*) FROM page WHERE page_namespace='4'
# 0  /  1 main | 2  /  3 user | 4  /  5 wkpd | 6  /  7 file | 8  /  9 mdwk | 10 / 11 tmpl
# 12 / 13 help | 14 / 15 cat  | 100/101 port | 118/119 drft | 710/711 ttxt | 828/829 modu
# 2300/2301 gadg 2302/2303 gdef -1 spec -2 medi
AND page_title NOT LIKE 'Articles_for_deletion/Log/%'
AND page_title LIKE 'Articles_for_deletion/%';
SELECT COUNT(*) FROM page WHERE page_namespace='4'
AND page_title NOT LIKE 'Votes_for_deletion/Log/%'
AND page_title LIKE 'Votes_for_deletion/%';
#SELECT page_title FROM page WHERE page_namespace='4'
#AND    page_title NOT LIKE 'Articles_for_deletion/Log/%'
#AND page_title LIKE 'Articles_for_deletion/%/';
#SELECT page_title FROM page WHERE page_namespace='4'
#AND    page_title NOT LIKE 'Articles_for_deletion/Log/%'
#AND page_title LIKE 'Articles_for_deletion/%/%emp';
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...