Articles in category with most langlinks on enwiki, missing from ltwiki

SQL

USE enwiki_p;

SELECT 
    count(*) ll_count, 
    CONCAT("[[:en:",page_title,"]]") title_en,
    (select CONCAT("[[:lt:",ll_title,"]]") from langlinks where ll_from = page_id and ll_lang = 'lt') title_lt,
    (select CONCAT("[[:d:",pp_value,"]]") from page_props where pp_page = page_id and pp_propname = 'wikibase_item') wb_item
  FROM
    page, langlinks
  WHERE
	page_title in (
      	SELECT page_title AS member
      	FROM categorylinks LEFT JOIN page ON (cl_from = page_id)
      	WHERE cl_to = "Mid-priority_mathematics_articles"
    ) and
    ll_from = page_id and
    page_namespace = 0
  GROUP BY
    page_id
  ORDER BY 
    ll_count desc, page_title
  LIMIT
    2050;

SQL

Checking query status...