enwiki:Minor planets without trwiki interwikis

SQL

USE enwiki_p;
SELECT 
CONCAT("#[[",REPLACE(page_title,"_"," "),"]]"), 
CONCAT("[https://tr.wikipedia.org/wiki/Special:ContentTranslation?to=tr&page=",REPLACE(page_title,"_","+"),"&from=en]") as translatorlink,
page_len, page_props.pp_value, COUNT(ll_lang)
FROM page
INNER JOIN categorylinks ON
  cl_from = page_id
INNER JOIN page_props ON
   	page_id = page_props.pp_page AND
	page_props.pp_propname = "wikibase_item"
INNER JOIN langlinks ON page_id = ll_from AND ll_lang!='tr'
WHERE
  page_namespace = 0 AND
  cl_to = "Minor_planet_object_articles_(numbered)" AND
  page_id NOT IN (SELECT DISTINCT ll_from FROM langlinks WHERE ll_lang='tr') 
  GROUP BY page_title ORDER BY CAST(page_title AS int) ;
SQL

Checking query status...
