select a.cl_from, page_title, count(b.cl_from), count(el_from),... |
1 year ago |
select a.cl_from, page_title, count(b.cl_from), count(el_from),... |
2 years ago |
select a.cl_from, page_title, count(b.cl_to), count(el_to), count(pl_title)... |
2 years ago |
select a.cl_from, page_title, count(b.cl_from), count(el_from) from... |
2 years ago |
select page_title, count(b.cl_from), count(el_from), count(pl_from),... |
2 years ago |
select page_title, count(b.cl_from), count(el_from), count(pl_from),... |
2 years ago |
select cl_from, page_title from categorylinks
inner join templatelinks on... |
2 years ago |
select cl_from, page_title from categorylinks
inner join templatelinks 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 a.cl_from, page_title, b.cl_to from categorylinks a
join... |
2 years ago |
select img_name from image
limit 5 |
2 years ago |
select count(gil_page_title), gil_to from globalimagelinks
where gil_wiki =... |
2 years ago |
select count(gil_page_title), gil_to from globalimagelinks
left outer join... |
2 years ago |
select count(gil_page_title), gil_to from globalimagelinks
left outer join... |
2 years ago |
select concat(gil_page_namespace, ":", gil_page_title) from... |
2 years ago |
select * from globalimagelinks
limit 5 |
2 years ago |
describe globalimagelinks |
2 years ago |
select count(cl_from), il_to from categorylinks
inner join imagelinks on... |
2 years ago |
select count(cl_from), il_to from categorylinks
inner join imagelinks on... |
2 years ago |
select count(cl_from), il_to from categorylinks
inner join imagelinks on... |
2 years ago |
select count(cl_from), il_to from categorylinks
inner join imagelinks on... |
2 years ago |
select count(il_from), il_to from imagelinks
inner join categorylinks on... |
2 years ago |
select count(il_from), il_to from imagelinks
join categorylinks on il_from =... |
2 years ago |
select tl_from, el_to from templatelinks
join externallinks on tl_from =... |
2 years ago |
select tl_from, el_to from templatelinks
join externallinks on tl_from =... |
2 years ago |
select el_from, el_to from externallinks
where el_to like "%\.is\/%"
limit 20 |
2 years ago |
select el_from, el_to from externallinks
where el_to like "%w+\.is\/%"
limit 20 |
2 years ago |
select tl_from, el_to from templatelinks
join externallinks on tl_from =... |
2 years ago |
select pl_title, page_len, page_is_redirect from pagelinks
join page on... |
2 years ago |
use iswiki_p;
select page_title, pl_title from page
inner join categorylinks... |
5 years ago |
use iswiki_p;
select page_title, pl_title from page
inner join categorylinks... |
5 years ago |
use iswiki_p;
select page_title from page
inner join categorylinks on... |
5 years ago |
use iswiki_p;
select page_title, pl_title from page
inner join categorylinks... |
5 years ago |
use iswiki_p;
select page_title, pl_title from page
inner join categorylinks... |
5 years ago |
use iswiki_p;
select page_title, pl_title from page
inner join categorylinks... |
5 years ago |
select concat("#[[", a.page_title, "]]") from iswiki_p.page a
join... |
5 years ago |
select concat("#[[", a.page_title, "]]") from iswiki_p.page a
join... |
5 years ago |
select concat("#[[", a.page_title, "]]") from iswiki_p.page a
join... |
5 years ago |
select a.page_title from iswiki_p.page a
join iswikisource_p.page b on... |
5 years ago |
use iswikisource_p;
select count(linter_page), page_title, linter_cat from... |
6 years ago |
use iswikisource_p;
select count(linter_page), page_title, linter_cat from... |
6 years ago |
use iswikisource_p;
select count(linter_page), page_title, linter_cat from... |
6 years ago |
use iswikisource_p;
select count(linter_page), page_title, linter_cat from... |
6 years ago |
use iswikisource_p;
select count(linter_page), page_title, linter_cat from... |
6 years ago |
use iswikisource_p;
select count(linter_page), page_title, linter_cat from... |
6 years ago |
use iswikisource_p;
select count(linter_page), page_title, linter_cat from... |
7 years ago |