USE trwiki_p;

/*

select concat("tr.wikipedia.org/wiki?curid=",il_from) as url, il_to, count(*) from imagelinks where il_from_namespace = 0

​

group by il_from, il_to having count(*)>1

order by count(*) desc

;

*/

select concat("tr.wikipedia.org/wiki?curid=",pl_from) as url, pl_title, count(*) from pagelinks where pl_from_namespace = 0 

​

and  pl_title rlike ".ks.z" and pl_title not rlike "m"

group by pl_from, pl_title having count(*)>1

order by count(*) desc

;

​

​