| select * from comment
where comment_text like "%is.wp/en.wp sem heimild%" |
8 months ago |
| select * from comment
where comment_text like "%is.wp/en.wp sem heimild%" |
8 months ago |
| select * from comment
where comment_text = "hreingerning: tengill - sýndur... |
8 months ago |
| select * from comment
where comment_text = "hreingerning: tengill - sýndur... |
8 months ago |
| select * from comment
where comment_text = "hreingerning: tengill - sýndur... |
8 months ago |
| select page_namespace, page_title, page_len from page
order by page_len desc limit 10 |
8 months ago |
| select a.page_title from page a
join templatelinks b on b.tl_from =... |
1 year ago |
| select a.page_title from page a
join page c on a.page_title = c.page_title... |
1 year ago |
| select a.page_title from page a
inner join templatelinks b on b.tl_from =... |
1 year ago |
| select a.page_title from page a
right join templatelinks b on b.tl_from =... |
1 year ago |
| select a.page_title from page a
left outer join templatelinks b on b.tl_from... |
1 year ago |
| select a.page_title from page a
outer join templatelinks b on b.tl_from =... |
1 year ago |
| select a.page_title from page a
full outer join templatelinks b on b.tl_from... |
1 year ago |
| select a.page_title from page a
join templatelinks b on b.tl_from =... |
1 year ago |
| select a.page_title from page a
join templatelinks b on b.tl_from =... |
1 year ago |
| select a.page_title from page a
join templatelinks b on b.tl_from =... |
1 year ago |
| select * from linktarget
where lt_title in ('Wpheimild', 'Þýðing') |
1 year ago |
| select * from linktarget
where lt_title = 'wpheimild' |
1 year ago |
| select * from linktarget
where lt_title in ('wpheimild', 'þýðing') |
1 year ago |
|
|
1 year ago |
| select page_title, rev_timestamp from page
join revision on rev_page =... |
1 year ago |
| select page_title, rev_timestamp, ctd_name from page
join revision on... |
1 year ago |
| select page_title, rev_timestamp, ctd_name from page
join revision on... |
1 year ago |
| select page_title, rev_timestamp, ctd_name from page
join revision on... |
1 year ago |
| select page_title, rev_timestamp, ctd_name from page
join revision on... |
1 year ago |
| select count(page_title), substring(el_to, 1, 20) from page
join... |
1 year ago |
| select page_title, substring(el_to, 1, 30) from page
join externallinks on... |
1 year ago |
| select page_title, ct_tag_id, ctd_name from page
join revision on rev_page =... |
1 year ago |
| select page_title, ct_tag_id from page
join revision on rev_page = page_id... |
1 year ago |
| select img_name from image
where img_name like "-i---i-%" |
1 year ago |
| select img_name from image
where img_name like "-i---i-%"
limit 2000 |
1 year ago |
| select img_name from image
where img_name like "%---%"
limit 2000 |
1 year ago |
| select page_title, user_registration, user_editcount, user_touched from... |
1 year ago |
| select page_title, user_registration, user_editcount, user_touched from... |
1 year ago |
| select page_title, user_registration, user_editcount, user_touched from... |
1 year ago |
| select page_title, user_registration, user_editcount, user_touched from... |
1 year ago |
| select * from linktarget
where lt_title = "Velkomin" |
1 year ago |
| select page_title from page
join templatelinks on tl_from = page_id and... |
1 year ago |
| select page_title from page
join templatelinks on tl_from = page_id and... |
1 year ago |
| blank query |
1 year ago |
| select page_title, rev_timestamp from page
join pagelinks on pl_from =... |
1 year ago |
| select page_name, rev_timestamp from page
join pagelinks on pl_from =... |
1 year ago |
| select page_title, pl_title, pl_namespace from page
join categorylinks on... |
2 years ago |
| select e.page_title as cat1, a.cl_to as cat2, d.page_title,... |
2 years ago |
| select e.page_title as cat1, a.cl_to as cat2, d.page_title,... |
2 years ago |
| select e.page_title as cat1, a.cl_to as cat2, d.page_title, d.page_namespace... |
2 years ago |
| select e.page_title as cat1, a.cl_to as cat2, d.page_title, d.page_namespace... |
2 years ago |
| select e.page_title as cat1, a.cl_to as cat2, d.page_title, d.page_namespace... |
2 years ago |
| select page_title as cat1, a.cl_to as cat2, b.cl_from as art from page
join... |
2 years ago |
| select page_title as cat1, a.cl_to as cat2, b.cl_from as art from page
join... |
2 years ago |
| select pl_from, a.page_title as source, b.page_title as target from... |
2 years ago |
| select pl_from, a.page_title as source, b.page_title as target from... |
2 years ago |
