sablonsuz maddelerde imagelink

SQL

USE trwiki_p;
SELECT NOW();

select *
from page left join templatelinks on tl_from = page_id
left join imagelinks il_from = page_id
where page_namespace = 0
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...
