/** Test **/

SELECT page_id, page_title, page_is_new, page_touched, page_len, pp_value

FROM page_props

RIGHT JOIN (

SELECT page_id, page_title, page_is_new, page_touched, page_len

FROM `page` 

LEFT JOIN `categorylinks` ON ((cl_from = page_id)) 

WHERE cl_from IS NULL 

AND page_namespace = 14

AND page_is_redirect = 0 

LIMIT 2000

  ) AS pagetmp ON pp_page = pagetmp.page_id

AND pp_propname='wikibase_item'

LIMIT 2000

​