use commonswiki_p;

/*select *

from geo_tags

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))

  )

limit 1000*/

select *

from page

where pagenamespace = 6

limit 10

​

/*

gt_id   gt_page_id  gt_globe    gt_primary  gt_lat  gt_lon  gt_dim  gt_type gt_name gt_country  gt_region

*/