pages requiring {{other uses}} template (arwiki)

Fork of pages requiring {{other uses}} template by Saeidpourbabak

This query is marked as a draft This query has been published by FShbib.

قائمة بالمقالات التي يوجد صفحات توضيح بنفس اسمها لكنها لا تستعمل قالب {{استعمالات أخرى}} للربطها بصفحة التوضيح..

SQL

USE fawiki_p;
SELECT DISTINCT CONCAT('# [[',page_title,']]'),CONCAT('، [[',page_title,' (ابهام‌زدایی)]]')
FROM page JOIN templatelinks ON tl_from=page_id
WHERE page_namespace=0
AND page_is_redirect=0
#AND page_title NOT LIKE "%(%"
AND page_id NOT IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation')
AND CONCAT(page_title,'_(توضيح)') IN (
  SELECT page_title
  FROM page
  WHERE page_id IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation')
  )
AND "استعمالات_أخرى" NOT IN (
  SELECT tl_title
  FROM templatelinks
  WHERE page_id=tl_from)
ORDER BY page_title;

SQL

Checking query status...