Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
:lv articles without :et language link
by
Estopedist1
This query is marked as a draft
This query has been published
by
Estopedist1
.
Toggle Highlighting
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 pp_page FROM page_props WHERE pp_propname = 'disambiguation') #-- AND page_id NOT IN (SELECT tl_from FROM templatelinks AS tl WHERE tl_to LIKE "BioTakso_infokaste" OR tl_to LIKE "Raķete") #-- 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 "%Futbol%" OR cl_to LIKE "%_datorspēles" OR cl_to LIKE "%_hokeja_klubi%" OR cl_to LIKE "%_gada_singli" OR cl_to LIKE "Antarkt%" OR cl_to LIKE "%_filmas" OR cl_to LIKE "%olimpiskajās_spēlēs" OR cl_to LIKE "_ezeri%" OR cl_to LIKE "%par_cilvēkiem%" OR cl_to LIKE "%par_astronomiju%" OR cl_to LIKE "%olimpiskās_spēles%" OR cl_to LIKE "%hokeju%") 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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...