:lv articles without :et language link

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" OR
tl_title LIKE "Formula_1%" OR
                    tl_title LIKE "Televisiosarja%")
#--
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" OR
cl_to LIKE "%_järvet" OR
cl_to LIKE "%luvun_autot" OR
cl_to LIKE "%_kesäolympialaisissa_%" OR
cl_to LIKE "%_videopelit" OR
cl_to LIKE "%_ohjukset" OR #missiles
cl_to LIKE "%-yhtyeet" OR #ansamblid
cl_to LIKE "%_kaupungit" OR
cl_to LIKE "Syntymävuosi_puuttuu" OR
                    cl_to LIKE "%_kunnat")

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

Checking query status...
