| use fawiki_p;
SHOW INDEXES FROM logging_userindex |
3 years ago |
| use fawiki_p;
SHOW INDEXES FROM logging |
3 years ago |
| use fawiki_p;
SHOW INDEXES FOR logging |
3 years ago |
| use fawiki_p;
select
rev_actor,
left(rev_timestamp, 8) as rev_date,
... |
3 years ago |
| use enwiki_p;
select
rev_actor,
left(rev_timestamp, 8) as rev_date,
... |
3 years ago |
| use enwiki_p;
select
rev_actor,
left(rev_timestamp, 8) as rev_date,
... |
3 years ago |
| use enwiki_p;
select
rev_actor,
left(rev_timestamp, 8) as... |
3 years ago |
| show databases; |
4 years ago |
| use fawiki_p;
SELECT
actor_name,
STR_TO_DATE(LEFT(min(rev_timestamp),... |
4 years ago |
| use fawiki_p;
SELECT
user_name,
MAX(iwlinks) AS h_index
FROM
(
SELECT
... |
4 years ago |
| use fawiki_p;
SELECT
user_name,
MAX(iwlinks) AS h_index
FROM
(
SELECT
... |
4 years ago |
| use fawiki_p;
SELECT
user_name,
MAX(iwlinks) AS h_index
FROM
(
SELECT
... |
4 years ago |
| use fawiki_p;
SELECT
user_name,
MAX(iwlinks) AS h_index
FROM
(
SELECT
... |
4 years ago |
