Fork of
lvwiki articles without :et langlink
by Edgars2007
This query is marked as a draft
This query has been published
by Estopedist1.
SQL
x
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.