| select cl_to, cl_from, count(rev_id) as edits, page_title
from (select *... |
7 years ago |
| select cl_to, cl_from, count(rev_id), page_title
from (select * from... |
7 years ago |
| select cl_to, cl_from, count(rev_id), page_title
from (select * from... |
7 years ago |
| select cl_to, cl_from, count(rev_id) from
(select * from categorylinks... |
7 years ago |
| select cl_to, cl_from, count(rev_id) from
(select * from categorylinks... |
7 years ago |
| select * from categorylinks where cl_to LIKE '2016_deaths' |
7 years ago |
| select * from categorylinks where cl_to LIKE '2016_deaths' |
7 years ago |
| select * from categorylinks where cl_to LIKE '20___deaths' and cl_to NOT... |
7 years ago |
| select * from categorylinks limit 10; |
7 years ago |
| describe categorylinks |
7 years ago |
| select * from category where cat_title = "2016_deaths" |
7 years ago |
| select * from category where cat_title is "2016_deaths" |
7 years ago |
| describe category |
7 years ago |
| show tables |
7 years ago |
| describe categorymembers
|
7 years ago |
