| SELECT
page_id, page_title, page_len, page_is_new
... |
2 months ago |
| SELECT
page_id, page_title, page_len, page_is_new
... |
2 months ago |
| select *
from geo_tags, page
where
page_title = "Ccmhj.jpg"
and page_id =... |
3 months ago |
| #use commonswiki_p;
set @cat1:="All_media_needing_categories_as_of_20%";
#... |
3 months ago |
| #use commonswiki_p;
set @cat1:="All_media_needing_categories_as_of_20%";
#... |
3 months ago |
| #use commonswiki_p;
set @cat1:="All_media_needing_categories_as_of_20%";
#... |
3 months ago |
| # test geo_tags teable
select *
from geo_tags, page
where
gt_country =... |
3 months ago |
| select gt_region, COUNT(*) as ct
from geo_tags, page
where
gt_country =... |
3 months ago |
| select COUNT(*) as ct
from geo_tags, page
where
gt_country = "IT"
#... |
3 months ago |
| select COUNT(*) as ct
from geo_tags, page
where
gt_country = "CH"
#... |
3 months ago |
| select COUNT(*) as ct
from geo_tags, page
where
gt_country = "LU"
#... |
3 months ago |
| select *
from geo_tags, page
where
gt_country = "LU"
# page_title =... |
3 months ago |
| select *
from geo_tags, page
where
gt_country = "LI"
# page_title =... |
3 months ago |
| select *
from page
where
#page_title = "Ccmhj.jpg"
page_title =... |
3 months ago |
| select *
from geo_tags, page
where
#page_title = "Ccmhj.jpg"
page_title =... |
3 months ago |
| select *
from geo_tags, page
where
#page_title = "Ccmhj.jpg"
page =... |
3 months ago |
| select *
from geo_tags, page
where
page_title = "Ccmhj.jpg"
and page_id =... |
3 months ago |
| select *
from geo_tags, page
where
page_title = "Ccmhj.jpg"
|
3 months ago |
| select gt_lat, gt_lon, page_id, page_title
from geo_tags, page
where
... |
3 months ago |
