sablonsuz maddelerde imagelink

SQL

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();
SQL

Checking query status...
