Vecās smilšu kastes

SQL

use lvwiki_p;
select concat("[[:Lietotājs:",p.page_title,"]]"), p.page_len,
	concat("[//lv.wikipedia.org/w/index.php?title={{FULLPAGENAMEE:Lietotājs:",p.page_title,"}}&action=history Vēsture]"),
	concat("[//lv.wikipedia.org/w/index.php?title={{FULLPAGENAMEE:Lietotājs:",p.page_title,"}}&action=delete&wpReason=Veca%20smilšu%20kaste Dzēst]"),
	concat("[https://lv.wikipedia.org/w/index.php?title={{FULLPAGENAMEE:{{TALKPAGENAME:Lietotāja diskusija:{{ROOTPAGENAME:Lietotājs:",p.page_title,"}}}}}}&action=edit&section=new&preload=Veidne:Lpd-smilšu_kaste&preloadtitle=Smilšu%20kaste Diskusija]"),
    r.rev_timestamp
from page p
join revision r on r.rev_id=page_latest
where p.page_namespace = 2 and p.page_title like '%kaste%'
		and r.rev_timestamp<20150000000000
order by r.rev_timestamp asc, p.page_len asc
#limit 10;# or page_title like '%/smilšu kaste%';
#select page_title from page where page_namespace = 0 and page_title like '%:%' and page_title not like '%:_%';
SQL

Checking query status...
