:lv articles without :et language link

Fork of lvwiki articles without :et langlink by Edgars2007

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

SQL

USE lvwiki_p;
SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_id NOT IN (
  SELECT ll_from FROM langlinks WHERE ll_lang = "et")
#--
AND page_id NOT IN (SELECT tl_from FROM templatelinks AS tl WHERE 
tl_title LIKE "BioTakso_infokaste")
#--
AND page_id NOT IN (SELECT cl_from FROM categorylinks AS cl WHERE 
cl_to LIKE "%_dzimušie" OR 
cl_to LIKE "%_mirušie" OR 
cl_to LIKE "%_ciemi" OR
cl_to LIKE "Ielas_%" OR
cl_to LIKE "%_pagasts" OR
cl_to LIKE "%_upes" OR
cl_to LIKE "%_kosmiskie_aparāti" OR
cl_to LIKE "%_pilsētas" OR
cl_to LIKE "%_gada_albumi" OR
cl_to LIKE "%futbola_klubi%" OR
cl_to LIKE "gada_filmas" OR)

AND page_is_redirect = 0
ORDER BY RAND()
LIMIT 1000;

SQL

Checking query status...