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