Replicas browser and optimizer
This query is marked as a draft
This query has been published
use hewiki_p; select page_title, page_namespace from page left join imagelinks on il_from=page_id left join ( select il_to from imagelinks group by il_to having count(il_from)>20 ) as blacklist on blacklist.il_to=imagelinks.il_to where page_namespace=0 and page_is_redirect=0 and blacklist.il_to is NULL group by page_id having max(length(imagelinks.il_to)) is NULL
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in