日本国内のジオタグが付いたCommons上の新規ファイル

SQL

use commonswiki_p;
select *
from geo_tags
inner join(
  select rc_user_text, rc_title, rc_cur_id
  from recentchanges
  where rc_log_type = "upload"
  limit 100000
) as newfile on gt_page_id = rc_cur_id
where
  gt_globe = "earth" and 
  (
    ((gt_lon between 139.131 and 146.030) and (gt_lat between 20.879 and 45.737)) or
    ((gt_lon between 131.199 and 139.131) and (gt_lat between 18.229 and 38.668)) or
    ((gt_lon between 129.023 and 131.199) and (gt_lat between 21.657 and 34.913)) or
    ((gt_lon between 122.739 and 129.023) and (gt_lat between 21.821 and 33.073))
  )

SQL

Checking query status...