SQL
x
#use arwiki_p;
SELECT page_title
FROM arwiki_p.page
LEFT JOIN arwiki_p.langlinks
ON arwiki_p.langlinks.ll_from = arwiki_p.page.page_id
LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
ON pp_page = page_id
WHERE ll_title IS NULL
and pp_value IS NULL
and page_namespace = 0
and page_is_redirect = 0
# JOIN frwiki_p.page enp # (SELECT * FROM frwiki_p.page) AS enp
# ON page_title= enp.page_title
#and pp_value is null
limit 5;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.