use frwiki_p;

select count(*) from page left join page_props p on page_id=pp_page and pp_propname='wikibase_item' left join page_props p2 on page_id=p2.pp_page and  p2.pp_propname='disambiguation' where page_namespace=0 and page_is_redirect=0 and p.pp_page is null and p2.pp_page is null;

select page_title from page left join page_props p on page_id=pp_page and pp_propname='wikibase_item' left join page_props p2 on page_id=p2.pp_page and  p2.pp_propname='disambiguation' where page_namespace=0 and page_is_redirect=0 and p.pp_page is null and p2.pp_page is null limit 100;

select CONCAT('# [[', page_title, ']]') AS title from page left join page_props p on page_id=pp_page and pp_propname='wikibase_item' left join page_props p2 on page_id=p2.pp_page and  p2.pp_propname='disambiguation' where page_namespace=0 and page_is_redirect=0 and p.pp_page is null and p2.pp_page is null limit 100;

​