Replicas browser and optimizer
Number of galleries on Wikimedia Commons with 1 or 2 images
This query is marked as a draft
This query has been published
As originally written by User:Bawolff
use commonswiki_p; SELECT count(*) FROM ( SELECT page_title FROM page left outer join imagelinks on il_from = page_id WHERE page_namespace = 0 and page_is_redirect = 0 group by page_title having count( il_to ) = 0 ) a;
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