select page_title, page_len, count(el_from) from externallinks
join page on... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join page on... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join page on... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join page on... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join page on... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join page on... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join page on... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join page on... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join page on... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join... |
2 years ago |
select a.cl_from, page_title, b.cl_to from categorylinks a
join... |
2 years ago |
select actor_name, user_touched, user_editcount from actor
join user on... |
2 years ago |
select actor_name from actor
where actor_name rlike "sökkar" |
2 years ago |
select actor_name from actor
where actor_name rlike "%sökkar" |
2 years ago |
select actor_name from actor
where actor_user = 66254 |
2 years ago |
select actor_name, user_touched, user_editcount from actor
where actor_user = 66254 |
2 years ago |
select actor_name, user_touched, user_editcount from actor
join user on... |
2 years ago |
select actor_name, user_touched, user_editcount from actor
join user on... |
2 years ago |
select lt_title, lt_id from linktarget
where lt_title = "Stubbur"
limit 5 |
2 years ago |
select c.page_title, a.cl_to from categorylinks a
join page c on... |
2 years ago |
select c.page_title, a.cl_to from categorylinks a
join page c on... |
2 years ago |
select c.page_title, a.cl_to from categorylinks a
join page c on... |
2 years ago |
select a.cl_from, a.cl_to from categorylinks a
join page c on... |
2 years ago |
select * from page
limit 10 |
2 years ago |
select * from page
limit 10 |
2 years ago |
select * from page
limit 10 |
2 years ago |
select * from page
limit 10 |
2 years ago |
select * from page
limit 10 |
2 years ago |
select * from page
limit 10 |
2 years ago |
select * from page
limit 10 |
2 years ago |
select fpp_quality, count(fpp_page_id) from flaggedpage_pending
group by fpp_quality |
2 years ago |
select count(fpp_page_id) from flaggedpage_pending
group by fpp_quality |
2 years ago |
select count(fpp_page_id) from flaggedpage_pending
group by fpp_quality |
2 years ago |
select count(fpp_page_id) from flaggedpage_pending
group by fpp_page_id |
2 years ago |
select page_title, fpp_rev_id, fpp_pending_since from... |
2 years ago |
select * from flaggedpage_pending
limit 10 |
2 years ago |
select * from flaggedrevs_statistics
group by frs_stat_key
limit 2000 |
2 years ago |
select * from flaggedrevs_statistics
limit 2000 |
2 years ago |
select page_title, rev_timestamp from revision
join page on rev_page =... |
2 years ago |
select * from change_tag
limit 5
|
2 years ago |
select ct_tag from change_tag
where ct_tag = "cross-wiki-upload"
limit 5
|
2 years ago |
select ctd_name from change_tag_def_table
where ctd_name =... |
2 years ago |
select cat_title, cat_pages, cat_subcats, cat_files from category
where... |
2 years ago |
use metawiki_p;
select page_title, rev_actor, comment_text, rev_timestamp... |
2 years ago |
use metawiki_p;
select page_title, rev_actor, comment_text, rev_timestamp... |
2 years ago |
use metawiki_p;
select page_title, rev_actor, comment_text, rev_timestamp... |
2 years ago |
use metawiki_p;
select page_title, rev_actor, comment_text, rev_timestamp... |
2 years ago |
use metawiki_p;
select page_title, rev_actor, comment_text, rev_timestamp... |
2 years ago |
use metawiki_p;
select page_title, rev_actor, comment_text, rev_timestamp... |
2 years ago |
use metawiki_p;
select page_title, rev_actor, rev_comment, rev_timestamp... |
2 years ago |
select actor_id, actor_user from actor
where actor_user in (6523779,... |
2 years ago |
select comment_text, rev_timestamp from revision
join comment on comment_id... |
2 years ago |
select comment_text, rev_timestamp from revision
join comment on comment_id... |
2 years ago |
select comment_text, rev_timestamp from revision
join comment on comment_id... |
2 years ago |
select comment_text, rev_timestamp from revision
join comment on comment_id... |
2 years ago |
select user_name, user_editcount, user_registration from user
where... |
2 years ago |
select ug_user, ug_group, ug_registration from user_groups
where... |
2 years ago |
select ug_user, ug_group from user_groups
group by ug_group limit 50 |
2 years ago |
select ug_user, ug_group from user_groups
where ug_group = "autoconfirmed"
limit 50 |
2 years ago |
select rc_title as title, rc_new_len as size, actor_name as username from... |
2 years ago |
select page_title, count(il_from) from page
join imagelinks on il_from =... |
3 years ago |
select img_name from image
where img_media_type = "AUDIO"
limit 3 |
3 years ago |
select actor_name, min(img_timestamp), (user_registration - img_timestamp)... |
3 years ago |
select actor_name, min(img_timestamp), user_registration from image
join... |
3 years ago |
select rc_id from recentchanges
join change_tag on rc_id = ct_rc_id and... |
3 years ago |
select rc_id from recentchanges
join change_tag on rc_id = ct_rc_id and... |
3 years ago |
select rc_id from recentchanges
join change_tag on rc_id = ct_rc_id and... |
3 years ago |
select rc_id from recentchanges
join change_tag on rc_id = ct_rc_id and ct_tag_id = 7 |
3 years ago |
select rc_id from recentchanges
join change_tag on rc_id = ct_rc_id and... |
3 years ago |
select rc_id from recentchanges
join change_tag on rc_id = ct_rc_id and... |
3 years ago |
select count(rc_id) from recentchanges
join change_tag on rc_id = ct_rc_id... |
3 years ago |
select rc_id, count(rc_id) from recentchanges
join change_tag on rc_id =... |
3 years ago |
select rc_id, count(rc_id) from recentchanges
join change_tag on rc_id =... |
3 years ago |
select ctd_id, ctd_name from change_tag_def
limit 1000 |
3 years ago |
blank query |
3 years ago |
select user_name, count(wl_title) from watchlist
join user on user_id =... |
3 years ago |
select user_name, count(wl_title) from watchlist
join user on user_id =... |
3 years ago |
select user_name, count(wl_title) from watchlist
join user on user_id =... |
3 years ago |
select ips_site_page, ips_site_id from wb_items_per_site
where ips_site_id =... |
3 years ago |
select ips_site_page, ips_site_id from wb_items_per_site
where ips_site_id =... |
3 years ago |
select ips_site_page, ips_site_id from wb_items_per_site
where ips_site_id =... |
3 years ago |
use enwiki_p;
select page_namespace, page_title from page
where... |
3 years ago |
use enwiki_p;
select page_title from page
where length(page_title) > 200
limit 3000 |
3 years ago |
use iswiki_p;
select * from wbc_entity_usage
where eu_page_id = 3127
limit 20 |
4 years ago |
use wikidatawiki_p;
select a.ips_site_page from wb_items_per_site a
where... |
4 years ago |
use wikidatawiki_p;
select a.ips_site_page from wb_items_per_site a
where... |
4 years ago |
use iswiki_p;
select * from wbc_entity_usage
where eu_page_id = 94034
limit 10 |
4 years ago |
use iswiki_p;
select * from wbc_entity_usage
where eu_entity_id = 94034
limit 10 |
4 years ago |
blank query |
4 years ago |
select page_id, page_title, page_namespace from iswikiquote_p.page
inner... |
4 years ago |
select page_id, page_title, page_namespace from iswikiquote_p.page
inner... |
5 years ago |
select page_id, page_title from iswikiquote_p.page
inner join... |
5 years ago |
use iswikiquote_p;
select page_title, replace(page_title, "_", " ") from... |
5 years ago |
use wikiquote_p;
select page_title, replace(page_title, "_", " ") from... |
5 years ago |
use wikidatawiki_p;
select ips_site_id, ips_site_page from... |
5 years ago |
use wikidatawiki_p;
select ips_site_id, ips_site_page from... |
5 years ago |
select page_id, page_title from iswikiquote_p.page
inner join... |
5 years ago |
use iswikiquote_p;
select * from langlinks
where ll_from = 3069
limit 200 |
5 years ago |
use iswikiquote_p;
select * from langlinks
where ll_from = 4083
limit 200 |
5 years ago |
use iswikiquotewiki_p;
select * from langlinks
where ll_from = 4083
limit 200 |
5 years ago |
use iswiktionarywiki_p;
select * from langlinks
where ll_from = 4083
limit 200 |
5 years ago |
use wikidatawiki_p;
select ips_site_page, ips_site_id from... |
5 years ago |
use wikidatawiki_p;
select ips_site_page, ips_site_id from... |
5 years ago |
use wikidatawiki_p;
select ips_site_page, ips_site_id from... |
5 years ago |
use wikidatawiki_p
select ips_site_page, ips_site_id from... |
5 years ago |
use wikidatawiki_p
select wb_items_per_site
where ips_site_page =... |
5 years ago |
select wikidatawiki_p.wb_items_per_site
where ips_site_page = "Biblían"
and... |
5 years ago |
select page_title from iswiktionary_p.page
where page_title = "Biblían"
join... |
5 years ago |
use iswiki_p;
select img_name from image
where img_name = "20090414Reykjavik5821.JPG" |
6 years ago |
use iswiki_p;
select img_name from image
where img_name = "20090414Reykjavik5820.JPG" |
6 years ago |
use iswiki_p
select img_name from image
where img_name = "20090414Reykjavik5820.JPG" |
6 years ago |
use iswiki_p;
select page_title, il_to from page
join categorylinks on... |
6 years ago |
use iswiki_p;
select count(page_title), il_to from page
join categorylinks... |
6 years ago |
use iswiki_p;
select count(page_title), il_to from page
join categorylinks... |
6 years ago |
use iswiki_p;
select count(page_title), il_to from page
join categorylinks... |
6 years ago |
use iswiki_p;
select count(page_title), il_to from page
join categorylinks... |
6 years ago |
use iswiki_p;
select count(page_title), il_to from page
join categorylinks... |
6 years ago |
use iswiki_p;
select page_title from page
join categorylinks on page_id =... |
6 years ago |
use iswiki_p;
select page_title, il_to from page
join categorylinks on... |
6 years ago |
use iswiki_p;
select concat("*https://is.wikipedia.org/w/index.php?title=",... |
8 years ago |
use iswiki_p;
select concat("*https://is.wikipedia.org/w/index.php?title=",... |
8 years ago |
use iswiki_p;
select a.page_title from page a
join imagelinks on il_from =... |
8 years ago |
use iswiki_p;
select a.page_title from page a
join imagelinks on il_from =... |
8 years ago |
use iswiki_p;
select a.page_title from page a
join imagelinks on il_from =... |
8 years ago |
use iswiki_p;
select img_user_text, img_name from image
join page on... |
8 years ago |
use iswiki_p;
select a.page_title from page a
join imagelinks on il_from =... |
8 years ago |
use iswiki_p;
select il_to, a.page_title from page a
join imagelinks on... |
8 years ago |
use iswiki_p;
select il_to, page_title from page a
join imagelinks on... |
8 years ago |
use iswiki_p;
select img_user_text, img_name from image
join page on... |
8 years ago |
use iswiki_p;
select img_user text, page_title from image
join imagelinks on... |
8 years ago |
use iswiki_p;
select cl_to, a.page_title from page a
join imagelinks on... |
8 years ago |
use iswiki_p;
select b.page_title from page b
join categorylinks on cl_from... |
8 years ago |
use iswiki_p;
select cl_to, a.page_title from page a
join imagelinks on... |
8 years ago |
use iswiki_p;
select cl_to, a.page_title from page a
join imagelinks on... |
8 years ago |
use iswiki_p;
select img_user_text, il_to from imagelinks
join page on... |
8 years ago |
use iswiki_p;
select img_user_text, il_to from imagelinks
join page on... |
8 years ago |
use iswiki_p;
select img_user, il_to from imagelinks
join page on page_title... |
8 years ago |
use iswiki_p;
select il_to from imagelinks
join page on page_title =... |
8 years ago |
use iswiki_p;
select il_to from imagelinks
join page on page_title =... |
8 years ago |
use wikidatawiki_p;
SELECT * FROM wbs_propertypairs
where pid1 = 31
limit 20 |
8 years ago |
use wikidatawiki_p;
SELECT * FROM wbs_propertypairs
where pid1 = 31
limit 20 |
8 years ago |
use wikidatawiki_p;
SELECT * FROM wb_terms
where term_entity_id = 26249
limit 20 |
8 years ago |
use wikidatawiki_p;
SELECT * FROM wb_terms
limit 20 |
8 years ago |
use wikidatawiki_p;
SELECT * FROM wbs_propertypairs
where qid1 = 190771
limit 20 |
8 years ago |
use wikidatawiki_p;
SELECT * FROM wbs_propertypairs
where qid1 = 190771
limit 5 |
8 years ago |
use wikidatawiki_p;
SELECT * FROM wbs_propertypairs
limit 5 |
8 years ago |
use wikidatawiki_p;
SELECT qid1, pid1, pid2 FROM wbs_propertypairs
where... |
8 years ago |
use wikidatawiki_p;
SELECT qid1, pid1, pid2 FROM wbs_propertypairs
where... |
8 years ago |
use wikidatawiki_p;
SELECT * FROM wbs_propertypairs
limit 5 |
8 years ago |
use wikidatawiki_p;
SELECT pid1, pid2, qid FROM wbs_propertypairs
where qid... |
8 years ago |
use wikidata_p;
SELECT pid1, pid2, qid FROM wbs_propertypairs
where qid =... |
8 years ago |
use enwiki_p;
select log_title, page_title from logging
join page on... |
9 years ago |
use enwiki_p;
select log_title from logging
where log_namespace = 6
limit 10 |
9 years ago |
use enwiki_p
select log_title from logging
where log_namespace = 6
limit 10 |
9 years ago |
use enwiki_p;
select log_title, page_title from logging
join page on... |
9 years ago |
use enwiki_p;
select page_title, page_namespace, substring(page_title, 1,... |
9 years ago |
use enwiki_p;
select page_title, page_namespace, substring(page_title, 1,... |
9 years ago |
use enwiki_p;
select page_title, page_namespace, substring(page_title, 0,... |
9 years ago |
use enwiki_p;
select page_title, page_namespace, substring(page_title, 10,... |
9 years ago |
use enwiki_p;
select log_title, substring(log_title, 5), log_namespace from... |
9 years ago |
use iswiki_p;
select page_namespace, page_title FROM page
join revision a on... |
9 years ago |
use iswiki_p;
SELECT concat("*[http://is.wikipedia.org/w/index.php?title=",... |
9 years ago |
use iswiki_p;
SELECT concat("[http://is.wikipedia.org/w/index.php?title=",... |
9 years ago |
use iswiki_p;
SELECT rd_from, page_title, page_namespace FROM redirect
JOIN... |
9 years ago |
use iswiki_p;
SELECT rd_title, rd_namespace FROM redirect
JOIN pagelinks on... |
9 years ago |
use iswiki_p;
SELECT rd_title, rd_namespace FROM redirect
JOIN pagelinks on... |
9 years ago |
use commonswiki_p;
SELECT page_title FROM page
JOIN categorylinks b ON... |
9 years ago |
use commonswiki_p;
SELECT page_title FROM page
JOIN templatelinks ON... |
9 years ago |
use commonswiki_p;
SELECT page_title FROM page
JOIN templatelinks ON... |
9 years ago |
use commonswiki_p;
SELECT page_title FROM page
JOIN templatelinks ON... |
9 years ago |
use commonswiki_p;
SELECT page_title FROM page
JOIN categorylinks b ON... |
9 years ago |
use commonswiki_p;
SELECT page_title FROM page
JOIN categorylinks b ON... |
9 years ago |
use commonswiki_p;
SELECT page_title FROM page
JOIN categorylinks b ON... |
9 years ago |
use iswiki_p;
SELECT rev_timestamp, count(rev_timestamp) FROM revision
WHERE... |
9 years ago |
use iswiki_p;
SELECT rev_comment, count(rev_comment) FROM revision
WHERE... |
9 years ago |
use metawiki_p;
SELECT page_title, page_namespace, iwl_from, pr_level,... |
9 years ago |
use metawiki_p;
SELECT page_title, page_namespace, iwl_from, pr_level,... |
9 years ago |
use metawiki_p;
SELECT page_title, page_namespace, iwl_from, pr_level,... |
9 years ago |
use metawiki_p;
SELECT page_title, page_namespace, iwl_from FROM... |
9 years ago |
use metawiki_p;
SELECT page_title, page_namespace, iwl_from, pr_level FROM... |
9 years ago |
use metawiki_p;
SELECT page_title, page_namespace, iwl_from, pr_level FROM... |
9 years ago |
use metawiki_p;
SELECT page_title, page_namespace, iwl_from, pr_level FROM... |
9 years ago |
use metawiki_p;
SELECT page_title, iwl_from, pr_level FROM iwlinks
JOIN page... |
9 years ago |
use metawiki_p;
SELECT iwl_from, pr_level FROM iwlinks
JOIN... |
9 years ago |
use metawiki_p;
SELECT pr_level FROM page_restrictions
WHERE pr_level =... |
9 years ago |
use metawiki_p;
DESCRIBE page_restrictions.pr_level |
9 years ago |
use metawiki_p;
DESCRIBE page_restrictions |
9 years ago |
use metawiki_p;
DESCRIBE pr_level |
9 years ago |
use metawiki_p;
SELECT iwl_from, pr_level FROM iwlinks
JOIN... |
9 years ago |
use wikidatawiki_p;
SELECT rc_user_text, rc_namespace, rc_title, rc_comment... |
9 years ago |
use iswiki_p;
SELECT tl_from FROM templatelinks
JOIN categorylinks ON... |
9 years ago |
use iswiki_p;
SELECT cl_from, cl_to FROM categorylinks
WHERE cl_from =... |
9 years ago |
SELECT cl_from, cl_to FROM categorylinks
WHERE cl_from = 37569
LIMIT 2000 |
9 years ago |
SELECT cl_from, cl_to FROM categorylinks
WHERE cl_to =... |
9 years ago |
use iswiki_p;
SELECT tl_from FROM templatelinks
JOIN categorylinks ON... |
9 years ago |
use iswiki_p;
SELECT tl_from FROM templatelinks
JOIN categorylinks ON... |
9 years ago |
use enwiki_p;
SELECT page_title, rd_namespace, rd_title, count(cl_from),... |
9 years ago |
use enwiki_p;
SELECT page_title, rd_title, count(cl_from), page_namespace,... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT DISTINCT page_title, count(pl_from), page_id FROM... |
9 years ago |
use enwiki_p;
SELECT DISTINCT page_title, count(pl_from), page_id FROM... |
9 years ago |
use enwiki_p;
SELECT DISTINCT page_title, count(pl_from), page_id FROM... |
9 years ago |
use enwiki_p;
SELECT DISTINCT page_title, count(pl_from), page_id FROM... |
9 years ago |
use enwiki_p;
SELECT DISTINCT page_title, count(pl_from), page_id FROM... |
9 years ago |
use enwiki_p;
SELECT DISTINCT page_title, count(pl_from), page_id FROM... |
9 years ago |
use enwiki_p;
SELECT DISTINCT page_title, count(pl_from), page_id FROM... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT page_title, count(pl_from), page_id FROM page
JOIN... |
9 years ago |
use enwiki_p;
SELECT DISTINCT pp_propname FROM page_props |
9 years ago |
use enwiki_p;
SELECT page_namespace, page_title, page_id, rd_namespace,... |
9 years ago |
use enwiki_p;
SELECT page_namespace, page_title, page_id, rd_namespace,... |
9 years ago |
use metawiki_p;
SELECT log_title, log_user, log_user_text, log_timestamp,... |
9 years ago |
use metawiki_p;
SELECT log_title, log_user, log_user_text, log_timestamp,... |
9 years ago |
use metawiki_p;
SELECT log_namespace, log_title, log_user_text,... |
9 years ago |
use enwiki_p;
SELECT il_to, COUNT(il_to), il_from_namespace FROM... |
9 years ago |
use enwiki_p;
SELECT il_to, COUNT(DISTINCT il_to), il_from_namespace FROM... |
9 years ago |
use enwiki_p;
SELECT cl_from, cl_to FROM categorylinks
WHERE cl_to =... |
9 years ago |
use enwiki_p;
SELECT il_to, COUNT(DISTINCT il_to), il_from_namespace FROM... |
9 years ago |