利用者‐会話:こいつぅ/カテゴリがスタブのみの記事

select distinct concat("* [[", page.page_title, "]]") from 
page, (select distinct cl_from from categorylinks where cl_to = 'スタブ') as stub_cl
left join (select distinct cl_from from categorylinks as nonstubcl where nonstubcl.cl_to != 'スタブ') as nonstubcl
    on stub_cl.cl_from = nonstubcl.cl_from
    where nonstubcl.cl_from is null
    and page.page_id = stub_cl.cl_from
    and page.page_is_redirect = 0
    and page_namespace = 0
    order by page.page_title
    into outfile 'stublist.ouput';