| use hewiki_p;
select count(pl_from), replace(pl_title, "_", " ") from... |
7 years ago |
| use hewiki_p;
select count(pl_from), pl_title from pagelinks
where... |
7 years ago |
| use hewiki_p;
select count(pl_from), pl_title from pagelinks
where... |
7 years ago |
| use hewiki_p;
select count(pl_from), pl_title from pagelinks
where... |
7 years ago |
| use hewiki_p;
select count(pl_from), pl_title from pagelinks
where... |
7 years ago |
| use hewiki_p;
select count(pl_from), pl_title from pagelinks
where... |
7 years ago |
| use hewiki_p;
select count(pl_from), pl_title from pagelinks
where... |
7 years ago |
| use hewiki_p;
select count(pl_from), pl_title from pagelinks
where... |
7 years ago |
| use hewiki_p;
select count(pl_from), pl_title from pagelinks
where... |
7 years ago |
| use hewiki_p;
select count(pl_from), pl_namespace from pagelinks
where... |
7 years ago |
| use hewiki_p;
show tables |
7 years ago |
| use hewiki_p;
select * from pagelinks
where not exists
(select * from page
... |
7 years ago |
| use hewiki_p;
select * from pagelinks
where not exists
(select * from page
... |
7 years ago |
| use hewiki_p;
select * from pagelinks
where not exists
(select * from page
... |
7 years ago |
| use hewiki_p;
select * from pagelinks
where not exists
(select * from page
... |
7 years ago |
| USE hewiki_p;
SELECT * FROM langlinks JOIN page
ON page_id = ll_from
WHERE... |
9 years ago |
| USE hewiki_p;
SELECT * FROM langlinks LEFT JOIN page
ON page_id = ll_from... |
9 years ago |
| USE hewiki_p;
SELECT * FROM langlinks LEFT JOIN page
ON page_id = ll_from... |
9 years ago |
| USE hewiki_p;
SELECT page_title, ll_lang FROM langlinks LEFT JOIN page
ON... |
9 years ago |
| USE hewiki_p;
SELECT page_title, ll_lang FROM langlinks LEFT JOIN page
ON... |
9 years ago |
| USE hewiki_p;
SELECT page_title, ll_lang FROM langlinks LEFT JOIN page
ON... |
9 years ago |
| USE hewiki_p;o
SELECT page_title, ll_lang FROM langlinks LEFT JOIN page
ON... |
9 years ago |
| USE hewiki_p;
SELECT page_title, ll_lang FROM langlinks LEFT JOIN page
ON... |
9 years ago |
| USE hewiki_p;
SELECT page_title, ll_lang FROM langlinks LEFT JOIN page
ON... |
9 years ago |
| USE hewiki_p;
SELECT ll_lang, COUNT(*) as total FROM langlinks LEFT JOIN... |
9 years ago |
