Projet:Restauration lien rouge/Script/Plus de liens rouges

Un article de Wikipédia, l'encyclopédie libre.

drop table most_red_link;

select count(crushed_links.id) as count, crushed_art.orig_title as title into most_red_link
from crushed_links, cur, crushed_art
where cur.cur_id = crushed_links.id
and cur_id = crushed_art.id
and cur_namespace = 0
group by crushed_art.orig_title
having count(crushed_links.id) > 200      
order by 1 desc;