| use enwiki_p;
select geo_page.page_title, geo_page.gt_lat, geo_page.gt_lon,... |
7 years ago |
| use itwiki_p;
select geo_page.page_title, geo_page.gt_lat, geo_page.gt_lon,... |
7 years ago |
| use itwiki_p;
select geo_page.page_title, geo_page.gt_lat, geo_page.gt_lon,... |
7 years ago |
| use itwiki_p;
select geo_page.page_title, geo_first_rev.gt_lat,... |
7 years ago |
| use itwiki_p;
select geo_page.page_title, geo_first_rev.gt_lat,... |
7 years ago |
| use itwiki_p;
select page.page_title, geo_first_rev.gt_lat,... |
7 years ago |
| use itwiki_p;
select * from
(
select *
from geo_tags
where gt_primary=1... |
7 years ago |
| use itwiki_p;
select * from
(
select *
from geo_tags
where gt_primary=1... |
7 years ago |
| use itwiki_p;
(
select *
from geo_tags
where gt_primary=1 and gt_globle... |
7 years ago |
| use itwiki_p;
select *
from geo_tags
limit 10 |
7 years ago |
| use itwiki_p;
select *
from revision
where rev_page=2
order by rev_timestamp |
7 years ago |
