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

SQL

use commonswiki_p;
select *
from geo_tags
where gt_country = "Japan"/*
where
((gt_lat between 139.131 and 146.030) and (gt_lon between 20.879 and 45.737)) or
((gt_lat between 131.199 and 139.131) and (gt_lon between 18.229 and 38.668)) or
((gt_lat between 129.023 and 131.199) and (gt_lon between 21.657 and 34.913)) or
((gt_lat between 122.739 and 129.023) and (gt_lon between 21.821 and 33.073))*/
limit 1

AخA
 
use commonswiki_p;select *from geo_tagswhere gt_country = "Japan"/*where((gt_lat between 139.131 and 146.030) and (gt_lon between 20.879 and 45.737)) or((gt_lat between 131.199 and 139.131) and (gt_lon between 18.229 and 38.668)) or((gt_lat between 129.023 and 131.199) and (gt_lon between 21.657 and 34.913)) or((gt_lat between 122.739 and 129.023) and (gt_lon between 21.821 and 33.073))*/limit 1

SQL

Checking query status...