Fork of
Gap in Geograph uploads
by Bjh21
This query is marked as a draft
This query has been published
by Bjh21.
SQL
AخA
select substr(cl_sortkey, 1, 6) as block, count(distinct cl_sortkey_prefix) as ngeographs from categorylinks
where cl_to = 'Images_from_Geograph_Britain_and_Ireland'
and cl_type = 'file'
AND cl_sortkey <' 04700000' group by block having ngeographs < 800;
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.