Untitled query #21662

SQL

USE udmwiki_p;
SELECT CONCAT('# [[:Категория:',page_title,']], '), page_len
#SELECT DISTINCT page_title
FROM page
#LEFT JOIN page_props
#ON pp_page = page_id
WHERE page_namespace = 14 
AND page_is_redirect = 0
#AND tl_namespace = 10

#AND pp_propname != 'disambiguation'

AND page_id NOT IN (
  SELECT ll_from FROM langlinks AS ll WHERE ll_lang = "et" )

#AND page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname = 'disambiguation')

#AND page_id NOT IN (
#  SELECT cl_to FROM categorylinks AS cl WHERE cl_to != "Ньылпуос")
  
#AND page_id NOT IN (
#  SELECT cl_from FROM categorylinks AS cl WHERE cl_to NOT LIKE "Ньылпуос")
  


#AND pp_propname != 'wikibase_item'

/*
AND cat_title != 'Аннонаос'
AND cat_title != 'Аралияос'
AND cat_title != 'Араукарияос'
AND cat_title != 'Бадьъёс'
AND cat_title != 'Вубуртчин'
AND cat_title != 'Выжы_емышъёс'
AND cat_title != 'Емышъёс'
AND cat_title != 'Кызъёс'
AND cat_title != 'Лулпуос'
AND cat_title != 'Магнолияос'
AND cat_title != 'Ньылпуос'
AND cat_title != 'Орхидной_будосъёс'
AND cat_title != 'Писпуос'
AND cat_title != 'Пужымъёс'
AND cat_title != 'Сусыпуос'
AND cat_title != 'Сяськаос'
AND cat_title != 'Эмъюм_будосъёс'
AND cat_title != 'Топольёс' */

/*AND cl_title != 'Wiktionary-omdirigering'
AND tl_title != 'Förgrening'
AND tl_title != 'Förgrening_bas'
AND tl_title != 'Gren'
AND tl_title != 'Namnförgrening'
AND tl_title != 'Grensida'
AND tl_title != 'Förgreningssida'
AND tl_title != 'Disambig'
AND tl_title != 'Hndis'
AND tl_title != 'Gaffel'
AND tl_title != 'Namngrensida'*/

ORDER BY page_title ASC
LIMIT 500;
SQL

Checking query status...
