USE fawikivoyage_p;

select page.page_title from page join (

SELECT  *

FROM  (SELECT * FROM page where page_id not in (SELECT ll_from FROM  langlinks) AND page_namespace = 0  AND page_is_redirect = 0) AS page

JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props where  page_id = pp_page ORDER BY pp_value)  as pppage where  not pppage.page_id=page.page_id AND page.page_namespace = 0  AND page.page_is_redirect = 0;

​