Articles sans entrée Wikidata

SQL

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;
SQL

Checking query status...
