| use frwiki_p;
select count(rev_id), SUBSTR(rev_timestamp, 1, 6)
from... |
6 years ago |
| use frwiki_p;
select count(rev_id), SUBSTR(rev_timestamp, 1, 6)
from... |
6 years ago |
| use enwiki_p;
select * from page where page_id = 28644448; |
6 years ago |
| use enwiki_p;
select * from page limit 10; |
6 years ago |
| use enwiki_p;
select * from page where pid = 28644448; |
6 years ago |
| use enwiki_p;
select * from page where id = 28644448; |
6 years ago |
| use quarry;
select count(*) from user; |
6 years ago |
| use quarry;
select * from user_group; |
6 years ago |
| use frwiki_p;
select page_title
from page
order by len(page_title) desc
limit 100; |
6 years ago |
| use frwiki_p;
select page_title
from page
order by len(page_title) desc; |
6 years ago |
| use frwiki_p;
select top 10 page_title
from page
order by len(page_title) desc; |
6 years ago |
| use frwiki_p;
select top 10 page_title
from page
order by len(page_title) desc |
6 years ago |
| SELECT
*
FROM
... |
7 years ago |
| SELECT
*
FROM
... |
7 years ago |
