ku.wiki talk pages without {{Serê gotûbêjê}}

Fork of it.wiki articles not having {{Controllo di autorità}} by Balyozxane

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

SQL

SELECT 
  CASE 
    WHEN page_namespace = 1 THEN CONCAT('Gotûbêj:', page_title)
    WHEN page_namespace = 5 THEN CONCAT('Gotûbêja Wîkîpediyayê:', page_title)
    WHEN page_namespace = 11 THEN CONCAT('Gotûbêja şablonê:', page_title)
    WHEN page_namespace = 15 THEN CONCAT('Gotûbêja kategoriyê:', page_title)
    WHEN page_namespace = 829 THEN CONCAT('Gotûbêja modulê:', page_title)
    ELSE page_title
  END AS full_page_title
FROM page
WHERE page_is_redirect = 0
  AND page_namespace IN (1,5,11,15,829)
  AND page_id NOT IN (
    SELECT tl_from FROM templatelinks JOIN linktarget ON tl_target_id = lt_id
    WHERE lt_namespace = 10
      AND lt_title IN (
        'Serê_gotûbêjê',
        'Talk_header'
      )
  )
  AND page_title NOT LIKE '%Arşîv%';

SQL

Checking query status...