USE hywiki_p;
SELECT page_title,
GROUP_CONCAT(cl_to)
FROM page
INNER... |
4 years ago |
USE hywiki_p;
SELECT page_title,
GROUP_CONCAT(cl_to)
FROM page
INNER... |
4 years ago |
SELECT page_title
FROM page
WHERE page_id NOT IN
(SELECT cl_from
... |
4 years ago |
select count(*) c, ll_from, page_title, ll_lang
from langlinks
join page on... |
4 years ago |
select count(*) c, ll_from, page_title
from langlinks
join page on page_id... |
4 years ago |
select count(*) c, ll_from, page_title
from langlinks
join page on page_id... |
4 years ago |
select count(*) c, ll_from, page_title from langlinks
join page on page_id... |
4 years ago |
select count(*) c, ll_from, page_title from langlinks
join page on page_id... |
4 years ago |
select count(*), ll_from, page_title from langlinks
join page on page_id =... |
4 years ago |
select count(*), ll_from, page_id from langlinks
join page on page_id =... |
4 years ago |
select count(*), ll_from from langlinks
join page on page_id =... |
4 years ago |
select count(*), ll_from from langlinks group by 2 limit 20; |
4 years ago |
select count(*), ll_lang from langlinks limit 20;
|
4 years ago |
select count(*), ll_lang from langlinks limit 20;
|
4 years ago |
select count(*), ll_lang from langlinks group by 2 order by 1 desc limit 20;
|
4 years ago |