| select page_id, page_title, b.pl_namespace, b.pl_title from page
left outer... |
1 year ago |
| select page_id, page_title, b.pl_namespace, b.pl_title from page
left outer... |
1 year ago |
| select page_id, page_title, b.pl_namespace, b.pl_title from page
left outer... |
1 year ago |
| select page_id, page_title, b.pl_namespace, b.pl_title from page
left outer... |
1 year ago |
| select rev_page, rev_comment_id from revision
join comment on rev_comment_id... |
1 year ago |
| select rev_page, rev_comment_id from revision
join comment on rev_comment_id... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id, substring(comment_text, 1, 10), comment_text... |
1 year ago |
| select rev_id, rev_comment_id, substring(comment_text, 0, 10), comment_text... |
1 year ago |
| select rev_id, rev_comment_id, substring(comment_text, 0, 10) from... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select length("Tók aftur") |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select rev_id, rev_comment_id from revision
join comment on rev_comment_id =... |
1 year ago |
| select a.page_title, rd_title, rd_namespace, rd_from from redirect
join page... |
1 year ago |
| select rd_title, rd_namespace, rd_from from redirect
where rd_namespace = 0
limit 1 |
1 year ago |
| select rd_title, rd_namespace, rd_from from redirect
limit 1 |
1 year ago |
| select log_title, log_type from logging
limit 1
select rd_title,... |
1 year ago |
| select log_title, log_type from logging
join page on log_title =... |
1 year ago |
| select log_title, log_type from logging
where log_type = 'delete'
and... |
1 year ago |
| select page_title, log_title, log_type from page
join logging on page_title... |
1 year ago |
| select page_title, log_title, log_type from page
join logging on page_title... |
1 year ago |
| select page_title, log_title, log_type from page
join logging on page_title... |
1 year ago |
| select a.page_title, rd_title, rd_namespace, rd_from from redirect
join page... |
1 year ago |
| select a.page_title, rd_title, rd_namespace, rd_from from redirect
join page... |
1 year ago |
| select a.page_title, rd_title, rd_namespace, rd_from from redirect
join page... |
1 year ago |
| select * from change_tag_def
where ctd_name = 'mw-rollback' |
1 year ago |
| select comment_text, rev_timestamp from comment
join revision on... |
1 year ago |
| select comment_text, rev_timestamp from comment
join revision on... |
1 year ago |
| select comment_text, rev_timestamp from comment
join revision on... |
1 year ago |
| select comment_text, rev_timestamp from comment
join revision on... |
1 year ago |
| select comment_text, rev_timestamp from comment
join revision on... |
1 year ago |
| select comment_text, rev_timestamp from comment
join revision on... |
1 year ago |
| select comment_text, rev_timestamp from comment
join revision on... |
1 year ago |
| select comment_text, rev_timestamp from comment
join revision on... |
1 year ago |
| blank query |
1 year ago |
| select page_title, count(page_title) from page
join revision on rev_page =... |
1 year ago |
| select page_title, count(page_title) from page
join revision on rev_page =... |
1 year ago |
| select * from actor
where actor_name = "Fyxi"
limit 10 |
1 year ago |
| blank query |
1 year ago |
| select comment_text, count(comment_text) from comment
join logging on... |
1 year ago |
| blank query |
2 years ago |
| select count(linter_page), linter_params from linter
group by linter_params |
2 years ago |
| blank query |
2 years ago |
| select concat("[[", page_title, "]]"), concat("{{aðgreiningartengill1|",... |
2 years ago |
| select concat("[[", page_title, "]]"), concat("{{aðgreiningartengill1|",... |
2 years ago |
| select concat("[[", page_title, "]]"), concat("{{aðgreiningartengill1|",... |
2 years ago |
| select page_title from page
join pagelinks on page_id = pl_from
join... |
2 years ago |
| select pl_title from pagelinks
where pl_from = 69029 |
2 years ago |
| select * from wbs_propertypairs
where qid1 = 6610935
limit 10 |
2 years ago |
| select * from wbs_propertypairs
where qid = 6610935
limit 10 |
2 years ago |
| select * from page_props
where pp_page = 6610935
limit 10 |
2 years ago |
| select pp_page, pp_propname, pp_value from page_props
where pp_page = 6610935
limit 5 |
2 years ago |
| select pp_page, pp_propname, pp_value from page_props
where pp_page =... |
2 years ago |
| select a.page_title, cl_to from page a
join categorylinks on a.page_id =... |
2 years ago |
| select a.page_title, cl_to from page a.
join categorylinks on a.page_id =... |
2 years ago |
| select page_title from page
left outer join categorylinks on page_id =... |
2 years ago |
| select lt_title from linktarget
join templatelinks on tl_target_id = lt_id... |
2 years ago |
| select lt_title, cl_to from linktarget
join templatelinks on tl_target_id =... |
2 years ago |
| select lt_title, cl_to from linktarget
join templatelinks on tl_target_id =... |
2 years ago |
| select gil_wiki, gil_page_title, gil_to from globalimagelinks
where gil_wiki... |
2 years ago |
| select gil_wiki, gil_page_title, gil_to from globalimagelinks
where gil_wiki... |
2 years ago |
| select * from globalimagelinks
limit 5 |
2 years ago |
| select cl_from, il_to from categorylinks
join imagelinks on il_from =... |
2 years ago |
| select cl_from, il_to from categorylinks
join imagelinks on il_from =... |
2 years ago |
| select cl_from, il_to from categorylinks
join imagelinks on il_from =... |
2 years ago |
| Select ct_rev_id, rev_timestamp, page_title from change_tag
inner join... |
2 years ago |
| Select ct_rev_id, rev_timestamp, page_title from change_tag
inner join... |
2 years ago |
| select ctd_name, ctd_id from change_tag_def |
2 years ago |
| select count(pp_page) from page_props
join templatelinks on pp_page =... |
2 years ago |
| select count(pp_page) from page_props
join templatelinks on pp_page =... |
2 years ago |
| select count(pp_page) from page_props
join templatelinks on pp_page =... |
2 years ago |
| select count(pp_page) from page_props
where pp_propname =... |
2 years ago |
| select count(pp_page) from page_props
where pp_propname =... |
2 years ago |
| blank query |
2 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_name, rd_title from page
join redirect on page_id... |
4 years ago |
| use iswiki_p;
select page_title, rd_title, substring(page_title, 1, 3),... |
4 years ago |
| use iswiki_p;
select page_title, rd_title, substring(page_title, 1, 3),... |
4 years ago |
| use iswiki_p;
select page_title, rd_title, substring(page_title, 1, 3),... |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title regexp... |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title regexp "^[0-9]"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title regexp "%d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title regexp "^%d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title regexp "^\d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title regexp "\d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title like "\d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title like "%\d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title like "%[1-9]"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title like "^[1-9]"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title like "^\d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title like "^%d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title like "^\d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title from page
where page_title like "^\d\d\d"
limit 10 |
4 years ago |
| use iswiki_p;
select page_title, rd_title, substring(page_title, 1, 3),... |
4 years ago |
| use iswiki_p;
select page_title, tl_title, substring(page_title, 1, 3),... |
4 years ago |
| use iswiki_p;
select page_title, tl_title, substring(page_title, 1, 3),... |
4 years ago |
| use iswiki_p;
select page_name, tl_title, substring(page_name, 1, 3),... |
4 years ago |
| use commonswiki_p;
select img_size, img_name from image
where img_size > 3221225472 |
5 years ago |
| use commonswiki_p;
select img_size, count(img_name) from image
where... |
5 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24), page_title FROM... |
8 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24), page_title FROM... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24), page_title FROM... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24), page_title FROM... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24), page_title FROM... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24) FROM commonswiki_p.templatelinks... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24) FROM commonswiki_p.templatelinks... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24), i.page_title FROM... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24) FROM commonswiki_p.templatelinks... |
9 years ago |
| SELECT i.page_title, i.page_namespace FROM commonswiki_p.page as i
WHERE... |
9 years ago |
| SELECT i.page_title, i.page_namespace FROM iswiki_p.page as i
WHERE... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24), i.page_title FROM... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 24) FROM commonswiki_p.templatelinks... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 23) FROM commonswiki_p.templatelinks... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 19) FROM commonswiki_p.templatelinks... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 19), i.page_title FROM... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 19) FROM commonswiki_p.templatelinks... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 19) FROM commonswiki_p.templatelinks... |
9 years ago |
| SELECT c.tl_from, substring(c.tl_title, 19) FROM commonswiki_p.templatelinks... |
9 years ago |
| use commonswiki_p;
SELECT tl_from, substring(tl_title, 19) FROM... |
9 years ago |
| use commonswiki_p;
SELECT tl_from, substring(tl_title, 18) FROM... |
9 years ago |
| use commonswiki_p;
SELECT tl_from, substring(tl_title, 15) FROM... |
9 years ago |
| use commonswiki_p;
SELECT tl_from, substring(tl_title, 11) FROM... |
9 years ago |
| use commonswiki_p;
SELECT tl_from, substring(tl_title, 8) FROM... |
9 years ago |
| use commonswiki_p;
SELECT tl_from, tl_title FROM templatelinks
WHERE tl_from... |
9 years ago |
| use commonswiki_p;
SELECT tl_from, tl_title FROM templatelinks
WHERE tl_from... |
9 years ago |
| use iswiki_p;
SELECT tl_from, tl_title FROM templatelinks
WHERE tl_from =... |
9 years ago |
| use iswiki_p;
SELECT il_to, il_from, page_title FROM imagelinks
JOIN page ON... |
9 years ago |
| use iswiki_p;
SELECT il_to, il_from FROM imagelinks
WHERE il_to = 0
LIMIT 10
|
9 years ago |
| use iswiki_p;
SELECT il_to, il_from FROM imagelinks
WHERE il_to = 2818358
|
9 years ago |
| use commonswiki_p;
SELECT il_to, il_from FROM imagelinks
WHERE il_to = 2818358
|
9 years ago |
| use iswiki_p;
SELECT page_title, page_namespace, count(iwl_from) FROM... |
9 years ago |
| use iswiki_p;
SELECT page_title, page_namespace, count(iwl_from) FROM... |
9 years ago |
| use iswiki_p;
SELECT page_title, page_namespace, count(ll_from) FROM... |
9 years ago |
| use metawiki_p;
SELECT iwl_prefix, COUNT(iwl_prefix) FROM iwlinks
GROUP BY... |
9 years ago |
| use metawiki_p;
SELECT ll_from, ll_lang FROM langlinks
LIMIT 1000 |
9 years ago |
| use metawiki_p;
SELECT COUNT(page_namespace), page_namespace, iwl_prefix... |
9 years ago |
| use metawiki_p;
SELECT COUNT(DISTINCT page_namespace), page_namespace,... |
9 years ago |
| use metawiki_p;
SELECT page_title, page_namespace, iwl_prefix FROM... |
9 years ago |
| use metawiki_p;
SELECT page_title, iwl_prefix FROM iwlinks
JOIN page ON... |
9 years ago |
| use metawiki_p;
SELECT COUNT(page_namespace), iwl_prefix FROM iwlinks
JOIN... |
9 years ago |
| use iswiki_p;
SELECT page_title, page_latest, page_namespace FROM page
JOIN... |
9 years ago |
| use iswiki_p;
SELECT page_title, page_latest, page_namespace FROM page
JOIN... |
9 years ago |
| use iswiki_p;
SELECT * FROM revision
WHERE rev_page = 54471 |
9 years ago |
| use iswiki_p;
SELECT rev_page, rev_parent_id FROM revision
WHERE rev_page = 54471 |
9 years ago |
| use iswiki_p;
SELECT page_title, page_latest, page_namespace FROM page
JOIN... |
9 years ago |
| use iswiki_p;
SELECT page_title, rev_parent_id, page_namespace FROM... |
9 years ago |
| use iswiki_p;
SELECT page_title, page_touched, page_len, page_namespace FROM... |
9 years ago |
| use enwiki_p;
SELECT count(afl_id), afl_action, afl_timestamp FROM... |
9 years ago |
| use enwiki_p;
SELECT count(afl_id), afl_action, afl_timestamp FROM... |
9 years ago |
| use enwiki_p;
SELECT count(afl_id), afl_action, afl_timestamp FROM... |
9 years ago |
| use enwiki_p;
SELECT count(afl_id), afl_action, afl_timestamp FROM... |
9 years ago |
| use enwiki_p;
SELECT afl_action FROM abuse_filter_log
LIMIT 10 |
9 years ago |
| use enwiki_p;
SELECT count(afl_id), afl_actions, afl_timestamp FROM... |
9 years ago |
| use enwiki_p;
SELECT afl_action FROM abuse_filter_log
LIMIT 10 |
9 years ago |
| use enwiki_p;
SELECT count(afl_id), afl_actions, afl_timestamp FROM... |
9 years ago |
| use enwiki_p;
SELECT count(afl_id), afl_actions FROM abuse_filter_log
WHERE... |
9 years ago |
| use enwiki_p;
SELECT afl_actions FROM abuse_filter_log
LIMIT 5 |
9 years ago |
| use enwiki_p;
DESCRIBE abuse_filter_log |
9 years ago |
