Fork of
Small but well-interwikied - Indonesia
by HaEr48
This query is marked as a draft
This query has been published
by HaEr48.
SQL
x
use enwiki_p;
select
page_title, page_len, created from
(select min(r.rev_timestamp) created, page.page_id, page.page_title, page.page_len
from revision r, page
where
page.page_namespace = 0 and
page.page_is_redirect = 0 and
r.rev_page = page.page_id and
r.rev_timestamp < 20110000000000 and
page_len < 4000
group by 2 desc) as page
/* where exists (
select *
from categorylinks as cat
where cat.cl_from = page.page_id
and cat.cl_to like '%Indonesia%') */
limit 200
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.