مقالات مترجمة بواسطة أداة ترجمة المحتوى، وغير مرتبطة بوصلة لغات

SQL

select distinct CONCAT('[[',page_Title,']]') as 'عنوان المقالة', page_len as 'حجم المقالة',ctd_id
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))      	     ;

SQL

Checking query status...