USE trwiki_p;

SELECT NOW();

​

select concat("tr.wikipedia.org/wiki?curid=",page_id) as url, page_title, il_to, count(*)

from page 

join imagelinks on il_from = page_id

left join templatelinks on tl_from = page_id

where page_namespace = 0 and tl_from is null

and not exists (select * from image where img_name = il_to)

group by page_id -- having count(*) = 1

order by count(*) desc

limit 100

;

select now();

select *, count(*)

from templatelinks tl

where tl.tl_from_namespace = 0

and tl.tl_namespace in ("10") -- 10, 828

and tl.tl_from not in (select tl2.tl_from from templatelinks tl2 where tl2.tl_title in ("Bilgi_kutusu","Mt_kutusu") and tl2.tl_namespace = 10)

group by tl.tl_title having count(*) > 10000

order by tl.tl_namespace desc, count(*) desc

limit 100

;

select now();