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
IKhitron
.
Toggle Highlighting
SQL
USE hewiki_p; SELECT CASE page_namespace WHEN -2 THEN "מדיה" WHEN -1 THEN "מיוחד" WHEN 0 THEN ":" WHEN 1 THEN "שיחה" WHEN 2 THEN "משתמש" WHEN 3 THEN "שיחת משתמש" WHEN 4 THEN "ויקיפדיה" WHEN 5 THEN "שיחת ויקיפדיה" WHEN 6 THEN "קובץ" WHEN 7 THEN "שיחת קובץ" WHEN 8 THEN "מדיה ויקי" WHEN 9 THEN "שיחת מדיה ויקי" WHEN 10 THEN "תבנית" WHEN 11 THEN "שיחת תבנית" WHEN 12 THEN "עזרה" WHEN 13 THEN "שיחת עזרה" WHEN 14 THEN "קטגוריה" WHEN 15 THEN "שיחת קטגוריה" WHEN 100 THEN "פורטל" WHEN 101 THEN "שיחת פורטל" WHEN 118 THEN "טיוטה" WHEN 119 THEN "שיחת טיוטה" WHEN 828 THEN "יחידה" WHEN 829 THEN "שיחת יחידה" ELSE "אחרים" END as 'מרחב השם', page_title as 'שם הדף', COUNT(revision.rev_id) as 'מספר השינויים', COUNT(DISTINCT(rev_user)) as 'מספר העורכים' FROM page JOIN revision ON page.page_id = revision.rev_page WHERE page_len = 0 AND page_namespace <> 2 AND page_namespace <> 3 AND NOT (page_namespace = 8 AND page_title = 'Sitenotice') GROUP BY revision.rev_page
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...