SQL
AخA
use lvwiki_p;
SELECT *#p.page_title, min(r.rev_timestamp)
FROM page p
JOIN revision r
ON r.rev_page = p.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
p.page_namespace = 0
#having min(r.rev_timestamp)>20150531235959
limit 40;
#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.