Interwiki nélküli sablonok

SQL

USE huwiki_p;
SELECT page_title FROM page
  LEFT JOIN templatelinks ON tl_from = page_id AND tl_namespace = 10 AND tl_title = 'Kat-redir'
  LEFT JOIN langlinks ON ll_from = page_id
WHERE page_namespace = 10
  AND NOT page_title LIKE 'Csonk%'
  AND NOT page_title LIKE 'Évfordulók%'
  AND NOT page_title LIKE 'Hasonló_nevű_viszonylatok%'
  AND NOT page_title LIKE 'Kezdőlap%'
  AND NOT page_title LIKE 'Koordináták%'
  AND NOT page_title LIKE 'Mérkőzés%'
  AND NOT page_title LIKE 'Mérkőzés%'
  AND NOT page_title LIKE 'Napképe%'
  AND NOT page_title LIKE 'Népesség%'
  AND NOT page_title LIKE 'Női_válogatott_mérkőzés%'
  AND NOT page_title LIKE 'Userbox%'
  AND NOT page_title LIKE 'Ünnepek%'
  AND NOT page_title LIKE 'Válogatott_mérkőzés%'
  AND NOT page_title LIKE 'Zászló%'
  AND NOT page_title LIKE '%olimpiai keret%'
  AND NOT page_title LIKE 'Legfrissebb%'
  AND page_is_redirect = 0
  AND tl_from IS NULL
  AND ll_from IS NULL;
SQL

Checking query status...
