sablonsuz maddelerde imagelink

SQL

USE trwiki_p;
SELECT NOW();

select *
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
order by count(*) desc

limit 100
;



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

Checking query status...
