SQL
x
#use commonswiki_p;
set @cat1:="All_media_needing_categories_as_of_20%";
set @cat2:="Media_needing_category_review_as_of_%";
set @cat3:="Photos_from_Panoramio_needing_categories_as_of_%";
set @cat4:="Media_with_geo-coordinates_needing_categories";
set @cat5:="Media_needing_categories_as_of_%";
set @cat6:="Uncategorized%";
#describe geo_tags;
select distinct #gt_lat, gt_lon, gt_page_id,
(select concat("File:",page_title) from page where page_id = gt_page_id) as title
#,count(*)
from geo_tags
inner join categorylinks on gt_page_id = cl_from
where (cl_to like @cat1 or cl_to like @cat2 or cl_to like @cat3 or cl_to like @cat4 or cl_to like @cat5 or cl_to like @cat6)
and cl_type="file" and
(
((gt_lat<54.705 and gt_lat>=53.114659 and gt_lon>10.607234 and gt_lon<14.406991))
)
order by 1
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.
All SQL code is licensed under CC0 License.