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.