Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
ROdonnell-WMF
.
Toggle Highlighting
SQL
#In titles.csv #eswiki,3677679,0,31858,474795 #With SQL queries #eswiki,1878028,0,31196347,543132 USE eswiki_p; SELECT COUNT(*) AS Articles FROM page WHERE page_namespace = 0 AND page_is_redirect = 0; SELECT COUNT(img_name) AS Files FROM image; SELECT count(unique lt.lt_title) AS templates FROM templatelinks AS t INNER JOIN linktarget AS lt ON lt.lt_id = t.tl_target_id LEFT JOIN page AS p ON p.page_namespace = lt.lt_namespace AND p.page_title = lt.lt_title INNER JOIN page AS p2 ON t.tl_from = p2.page_id WHERE p.page_is_redirect = 0 AND lt.lt_namespace = 10 AND p2.page_namespace = 0; SELECT count(cat_id) as categories FROM category ;
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
.
Checking query status...