Untitled query #76085

SQL

select 
  concat("[[:en:", page.page_title, "\|",page.page_title,"]]") as "المقال الإنجليزية", 
  # page.page_title as "المقال الانجليزية", 
  page_len as "حجم المقال في النسخة الإنجليزية",
  concat("[[", ll_title, "]]") as "المقال العربية"
  #ll_title as "المقال العربية"
from 
  categorylinks 
  inner join page on categorylinks.cl_from = page.page_id 
  inner join langlinks on langlinks.ll_from = page.page_id 
where 
  cl_to in ("Culture_in_Amman") 
  and cl_type like "page" 
  and page.page_namespace = 0 
  and ll_lang like "ar" 
  and trim(
    coalesce(ll_title, '')
  ) <> ''
  order by page_len desc
  limit 1000
SQL

Checking query status...
