select distinct page_title

from change_tag

inner join change_tag_def 

on ct_tag_id = ctd_id

inner join revision

on rev_id  = ct_rev_id

inner join page 

on page_id = rev_page

where page_namespace = 0

and page_is_redirect = 0 

and (ctd_name like "contenttranslation-v2" 

     or ctd_name like "contenttranslation")

and (page_id not in (select pp_page from page_props where pp_page = page_id and pp_propname = "wikibase_item")

     or page_id not in (select ll_from from langlinks where ll_from = page_id));