Untitled query #85695

SQL

SELECT
  DISTINCT CONCAT (
    'Category:',
    p1.page_title
  ),
  replace(
    p1.page_title,
    "Buildings_and_structures_in_",
    ""
  ),
  lle.ll_title
FROM
  page p1,
  langlinks lle
WHERE
  p1.page_namespace = 14
  AND p1.page_is_redirect = 0
  AND p1.page_title LIKE "Buildings_and_structures_in_%"
  AND p1.page_id NOT IN (
    SELECT
      cl_from
    FROM
      categorylinks
    WHERE
      cl_to IN (
        "Disambiguation_categories",
        "Wikipedia_soft_redirected_categories"
      )
  )
  AND p1.page_id NOT IN (
    SELECT
      ll_from
    FROM
      langlinks
    WHERE
      ll_from = p1.page_id
      AND ll_lang = "ar"
  )
  AND (
    (
      SELECT
        p2.page_id
      FROM
        page p2
      WHERE
        p2.page_is_redirect = 0
        AND p2.page_namespace IN (0)
        AND p2.page_title = replace(
          p1.page_title,
          "Buildings_and_structures_in_",
          ""
        )
    ) = lle.ll_from
  )
  AND lle.ll_lang = "ar"
GROUP BY
  p1.page_title
limit
  200
SQL

Checking query status...
