select
actor_name, actor_user
, edits as edits_on_lghtng_rods
,... |
2 years ago |
with acts as
(select r.rev_actor
, actor_name
, actor_user
,... |
2 years ago |
with acts as
(select r.rev_actor
, actor_name
, actor_user
,... |
2 years ago |
with acts as
(select r.rev_actor
, actor_name
, count(*) edits
from... |
2 years ago |
with acts as
(select r.actor_id
, actor_name
, count(*) edits
from... |
2 years ago |
select
mid(rev_timestamp,1,6) mth
, actor_name
, count(*) edits
from... |
2 years ago |
select * from revision limit 10 |
2 years ago |
select
mid(rev_timestamp,1,6) mth
, rev_user_text
, user_name
, count(*)... |
2 years ago |
select
mid(rev_timestamp,1,6) mth, user_name, count(*) edits
from revision... |
2 years ago |
select
mid(rev_timestamp,1,6) mth, r.rev_actor, count(*) edits
from... |
2 years ago |
select * from revision limit 10 |
2 years ago |
select
mid(rev_timestamp,1,6) mth, r.rev_user, count(*) edits
from revision... |
2 years ago |
select
mid(rev_timestamp,1,6) mth, rev_user, count(*) edits
from revision... |
2 years ago |
select
mid(rev_timestamp,1,6) mth, count(*) edits
from revision r
inner... |
2 years ago |
select
mid(rev_timestamp,1,6) mth, count(*) edits
from revision r
inner... |
2 years ago |
select
mid(rev_timestamp,1,6) mth, count(*) edits
from revision r
inner... |
2 years ago |
select
mid(rev_timestamp,1,6) mth, count(*) edits
from revision r
inner... |
2 years ago |
#select mid(rev_timestamp,1,6), count(*) from revision
#group by 1
#order by... |
2 years ago |
select mid(rev_timestamp,1,6), count(*) from revision
group by 1
order by 1 |
2 years ago |
select mid(rev_timestamp,1,6), count(*) from revision
group by 1
order by desc 1 |
2 years ago |
select * from revision
where rev_timestamp > '20210919000000000'
limit 10 |
2 years ago |
select * from revision limit 10 |
2 years ago |
SELECT COUNT(*)
FROM revision_userindex
WHERE
rev_actor = (SELECT... |
2 years ago |