:lv articles without :et language link

Fork of :lv articles without :et language link by Estopedist1

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

SQL

USE fiwiki_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 pp_page FROM page_props WHERE pp_propname = 'disambiguation')
#--
AND page_id NOT IN (SELECT tl_from FROM templatelinks AS tl WHERE 
tl_title LIKE "Taksonomia%" OR
                    tl_title LIKE "Lentokone")
#--
AND page_id NOT IN (SELECT cl_from FROM categorylinks AS cl WHERE 
cl_to LIKE "Vuonna_%_syntyneet" OR
cl_to LIKE "%Vuonna_%_kuolleet%" OR
cl_to LIKE "%_elokuvat" OR
cl_to LIKE "%_albumit" OR
                    cl_to LIKE "Vuoden_%_kappaleet")



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

SQL

Checking query status...