| select gil_wiki, concat(gil_page_namespace, ":", gil_page_title), gil_to... |
2 months ago |
| select * from user limit 50; |
1 year ago |
| select actor_name, count(*) c from revision join page on rev_page=page_id... |
2 years ago |
| select actor_name, count(*) c from revision join page on rev_page=page_id... |
2 years ago |
| USE ruwiki_p;
select tl_from_namespace, page_title, tl_namespace,... |
3 years ago |
| USE ruwiki_p;
select tl_from_namespace, page_title, tl_namespace,... |
3 years ago |
| USE ruwiki_p;
select tl_from_namespace, page_title, tl_namespace, tl_title... |
3 years ago |
| USE ruwiki_p;
select templatelinks.*, page.page_title from templatelinks... |
3 years ago |
| USE ruwiki_p;
select * from templatelinks join page on page_id=tl_from where... |
3 years ago |
| USE ruwiki_p;
select * from templatelinks where tl_namespace <> 0 limit 50; |
3 years ago |
| USE ruwiki_p;
select * from templatelinks limit 50; |
3 years ago |
| USE ruwiki_p;
SELECT
actor_name,
COUNT(actor_name),
page_title, --... |
3 years ago |
| USE ruwiki_p;
SELECT
actor_name,
COUNT(actor_name),
rev_comment, --... |
3 years ago |
| USE ruwiki_p;
SELECT
rev_user_text,
COUNT(rev_user_text),
... |
3 years ago |
