| select concat("Flokkur:", a.page_title), concat("Category:", b.ll_title)... |
2 years ago |
| select concat("Flokkur:", a.page_title), concat("Category:", b.ll_title)... |
2 years ago |
| select concat("Flokkur:", a.page_title), b.ll_lang, concat("Category:",... |
2 years ago |
| select a.page_title, b.ll_title from page a
join langlinks b on b.ll_from =... |
2 years ago |
| select a.page_title, b.ll_title from page a
join langlinks b on b.ll_from =... |
2 years ago |
| select a.page_latest, c.page_latest, b.rev_timestamp, d.rev_timestamp,... |
2 years ago |
| select a.page_latest, c.page_latest, b.rev_timestamp, d.rev_timestamp,... |
2 years ago |
| select page_title, rev_timestamp, actor_name from page
join revision on... |
2 years ago |
| select page_title, rev_timestamp, actor_name from page
join revision on... |
2 years ago |
| select page_title, rev_timestamp, actor_name from page
join revision on... |
2 years ago |
| select page_title, rev_timestamp, actor_name from page
join revision on... |
2 years ago |
| select count(el_from) from externallinks
group by el_from |
2 years ago |
| select count(el_id) from externallinks
group by el_from |
2 years ago |
| select count(el_id) from externallinks
group by el_id |
2 years ago |
| select page_title, a.cl_from, a.cl_to from categorylinks a
join... |
2 years ago |
| select page_title, a.cl_from, a.cl_to from categorylinks a
join... |
2 years ago |
| select a.cl_from, a.cl_to from categorylinks a
join categorylinks b on... |
2 years ago |
| select count(el_id) from externallinks |
2 years ago |
| select il_from, page_title, il_to from imagelinks
join page on page_id =... |
2 years ago |
| select il_from, page_title, il_to from imagelinks
join page on page_id =... |
2 years ago |
| select il_from, page_title, il_to from imagelinks
join page on page_id =... |
2 years ago |
| select il_from, page_title, il_to from imagelinks
join page on page_id =... |
2 years ago |
| select il_from, page_title, il_to from imagelinks
join page on page_id =... |
2 years ago |
| select il_from, page_title, il_to from imagelinks
join page on page_id =... |
2 years ago |
| select a.tl_from, page_title, a.tl_title from templatelinks a
inner join... |
2 years ago |
| select a.tl_from, page_title, a.tl_title from templatelinks a
inner join... |
2 years ago |
| select a.tl_from, page_title, a.tl_title from templatelinks a
inner join... |
2 years ago |
| select a.tl_from, page_title, a.tl_title from templatelinks a
where... |
2 years ago |
| select actor_name, min(log_timestamp), (log_timestamp - user_registration)... |
3 years ago |
| blank query |
4 years ago |
| select page_id, page_title, page_namespace from iswiki_p.page
inner join... |
4 years ago |
| select page_id, page_title, page_namespace from iswiki_p.page
inner join... |
5 years ago |
| select page_id, page_title, page_namespace from iswiki_p.page
inner join... |
5 years ago |
| select page_id, page_title, page_namespace from iswiki_p.page
inner join... |
5 years ago |
| use wikidatawiki_p;
select page_title, el_to, el_index from... |
6 years ago |
| use wikidatawiki_p;
select page_title, el_to, el_index from... |
6 years ago |
| use wikidatawiki_p;
select page_title, el_to, el_index from... |
6 years ago |
| use wikidatawiki_p;
select page_title, ll_lang, ll_title from langlinks
join... |
6 years ago |
| use wikidatawiki_p;
select page_title, iwl_prefix, iwl_title from... |
6 years ago |
| use wikidatawiki_p;
select page_title, iwl_prefix, iwl_title from... |
6 years ago |
| use wikidatawiki_p;
select * from iwlinks
where iwl_prefix = "commons"
limit 20
|
6 years ago |
| use wikidatawiki_p;
select iwl_title from iwlinks
where iwl_prefix =... |
6 years ago |
| use iswiki_p;
select * from externallinks
where el_from = "126663"
|
6 years ago |
| use iswiki_p;
select * from externallinks
and el_from = "126663"
|
6 years ago |
| use iswiki_p;
select * from iwlinks
where iwl_prefix = "commons"
and... |
6 years ago |
| use iswiki_p;
select * from iwlinks
limit 20 |
6 years ago |
| use iswiki_p;
select * from interwiki
limit 20 |
6 years ago |
| use iswiki_p;
select * from interwiki
where iw_prefix = "commons"
limit 20 |
6 years ago |
| use wikidatawiki_p;
show tables |
6 years ago |
| use wikidata_p;
show tables |
6 years ago |
