Fork of
Articles without images on arwiki
by FShbib
This query is marked as a draft
This query has been published
by Mess.
SQL
AخA
use itwiki_p;
SELECT page_title
FROM page
LEFT JOIN imagelinks ON il_from=page_id
WHERE page_namespace=0
AND page_is_redirect=0
AND il_from IS NULL
AND page_id IN
(SELECT ll_from
FROM langlinks
WHERE ll_lang = "en"
AND ll_title IN (
SELECT enwiki_p.page_title
FROM enwiki_p.page
LEFT JOIN enwiki_p.imagelinks ON enwiki_p.il_from=enwiki_p.page_id
WHERE enwiki_p.page_namespace=0
AND enwiki_p.page_is_redirect=0
AND NOT (enwiki_p.il_from IS NULL)))
AND page_id NOT IN
(SELECT cl_from
FROM categorylinks, pagelinks
WHERE cl_to = pl_title
AND pl_namespace = 14
AND pl_from = 4195411) /* Wikipedia:ConnectivityProjectInternationalization/ArticlesNotFormingValidLinks */
LIMIT 100;
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.