Usuário:Rui Malheiro/Orfãos
Origem: Wikipédia, a enciclopédia livre.
drop table if exists aaa;
create table aaa
select distinct b.cur_id as 'aaa_id'
from cur a, links, cur b
where
a.cur_id=l_from and
l_to=b.cur_id and
a.cur_namespace=0 and
b.cur_namespace=0;
create index aaa_id on aaa (aaa_id);
select concat('# [[',cur_title,']]')
from cur left join aaa on cur_id=aaa_id
where
aaa_id is null and
cur_namespace=0 and
not cur_is_redirect and
cur_text not like '%{{d_sambig%'
