中原区内で撮られたかもしれないCommons上の新規ファイル

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

This query is marked as a draft This query has been published by 軽快.

SQL

use commonswiki_p;
select 
  concat( "[[File:", replace(page_title, "_", " "), "]]" ) as "ファイルリンク",
  concat( "[http://www.google.co.jp/maps/@", gt_lat, ",", gt_lon, ",14z]" ) as "Googleマップ上の位置"
from geo_tags
inner join(
  select page_id, page_title
  from page
  where page_namespace = 6
) as file on page_id = gt_page_id 
where
  gt_globe = "earth" and 
  (gt_lon between 139.6269 and 139.6847) and
  (gt_lat between 35.5525 and 35.5980)

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...