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
Zife90
.
Toggle Highlighting
SQL
SELECT @i := @i + 1 AS rank, -- (SELECT pp_value FROM page_props WHERE pp_page = page_id AND pp_propname = 'wikibase_item') as wb_item, REPLACE(p.page_title, '_', ' ') as page_title, -- p.page_len, -- (SELECT count(*) FROM langlinks WHERE ll_from = p.page_id) as iw_count, CONCAT(SUBSTRING(rf.rev_timestamp, 1, 4), '-', SUBSTRING(rf.rev_timestamp, 5, 2), '-', SUBSTRING(rf.rev_timestamp, 7, 2), ' ', SUBSTRING(rf.rev_timestamp, 9, 2), ':', SUBSTRING(rf.rev_timestamp, 11, 2), ':', SUBSTRING(rf.rev_timestamp, 13, 2)) as created_at, rfa.actor_name as created_by, -- count(r.rev_id) as rev_count p.page_id, -- p.page_namespace, -- p.page_is_redirect, rf.rev_id, rf.rev_len FROM page p, revision r, revision rf, actor rfa, (SELECT @i := 0) AS rank WHERE r.rev_page = p.page_id and rf.rev_page = p.page_id and rf.rev_parent_id = 0 and rfa.actor_id = rf.rev_actor and p.page_namespace = 0 and p.page_is_redirect = 0 GROUP BY p.page_id ORDER BY p.page_id -- rf.rev_timestamp LIMIT 2 ;
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...