Untitled query #21819

SQL

USE fawiki_p;
SELECT DISTINCT REPLACE(concat('بحث:',t.page_title),'_',' '), REPLACE(concat('بحث:',rd_title),'_',' '), REPLACE(concat('بحث:',tp.page_title),'_',' '), t.page_len
FROM page AS t JOIN page AS p ON t.page_title = p.page_title JOIN redirect ON p.page_id = rd_from JOIN page AS tp ON tp.page_title = t.page_title
WHERE t.page_namespace  = 1
AND t.page_is_redirect = 0
AND t.page_len > 0
AND p.page_namespace = 0
AND p.page_is_redirect = 1
AND rd_namespace = 0
AND tp.page_namespace = 1
AND tp.page_is_redirect = 0

AND t.page_title NOT LIKE "قنات_%"

/*

AND EXISTS (
  SELECT null
  FROM page AS p
  WHERE p.page_namespace = 0
  AND p.page_title = t.page_title
  AND p.page_is_redirect = 1
)
*/



AND t.page_title NOT IN (
  SELECT pl_title
  FROM pagelinks JOIN categorylinks ON cl_from = pl_from
  WHERE pl_from_namespace = 1
  AND pl_namespace = 1
  AND cl_to = 'صفحه‌های_دارای_جعبه_بحث‌شده_در_جای_دیگر'
  AND pl_title = t.page_title
)


/*
AND t.page_id IN (
  SELECT page_id
  FROM page JOIN templatelinks ON page_id = tl_from
  WHERE tl_from_namespace = 1
  AND (
    tl_title = 'ادغام_شد_در'
    OR tl_title = 'پیشینه_حذف'
  )
  AND tl_namespace = 10
#  AND page_len < 500
  )

*/
/*

AND t.page_id IN (
  SELECT page_id
  FROM page JOIN templatelinks ON page_id = tl_from
  WHERE tl_from_namespace = 1
  AND tl_title = 'پیشینه_حذف'
  AND tl_namespace = 10
#  AND page_len < 500
  )*/

/*
AND t.page_id IN (
  SELECT page_id
  FROM page JOIN templatelinks ON page_id = tl_from
  WHERE tl_from_namespace = 1
  AND tl_title = 'ادغام_شد_در'
  AND tl_namespace = 10
#  AND page_len < 500
  )*/

ORDER BY t.page_len DESC;
SQL

Checking query status...
