SQL
AخA
use lvwiki_p;
SELECT tl.tl_from, (SELECT
min(rev_timestamp)
FROM revision
WHERE rev_page = page_id and min(rev_timestamp)>20150531235959)
FROM page p
#JOIN revision
#ON rev_page = page_id
join templatelinks tl on tl.tl_namespace=10 and tl.tl_from_namespace=0 and tl.tl_from=p.page_id
WHERE tl.tl_title="Universitātes_infokaste" and#page_len > 175000
#AND page_title NOT LIKE "%/%"
#AND
page_namespace = 0
#AND rev_timestamp =
#ORDER BY page_len, page_namespace ASC;
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.