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
Edgars2007
.
Toggle Highlighting
SQL
#http://quarry.wmflabs.org/query/1121 #use lvwiki_p; #SELECT * FROM user where user_registration > 20140700000000 AND user_editcount > 50; USE lvwiki_p; SELECT page_namespace,page_title,page_len FROM page WHERE #(page_namespace <> 3) and #(page_namespace % 2 =1 or page_namespace=4) page_namespace % 2 =1 # AND LOWER(page_title) NOT LIKE "%/archive%" AND LOWER(page_title) NOT LIKE "%/Arhīvs%" AND LOWER(page_title) NOT LIKE "%/arhīvs%" # AND LOWER(page_title) NOT LIKE "%/log%" AND page_len > 30000 ORDER BY page_len DESC; SELECT page_title,page_len FROM page WHERE #(page_namespace <> 3) and #(page_namespace % 2 =1 or page_namespace=4) page_namespace=4 # AND LOWER(page_title) NOT LIKE "%/archive%" AND LOWER(page_title) NOT LIKE "%/Arhīvs%" AND LOWER(page_title) NOT LIKE "%/arhīvs%" # AND LOWER(page_title) NOT LIKE "%/log%" AND page_len > 30000 ORDER BY page_len DESC;
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...