| USE fawiki_p;
SELECT count(distinct(page_id)) standard_article_count
FROM... |
6 years ago |
| use fawiki_p;
select
count(*) all_pages_in_main_namespace,
count(*) -... |
6 years ago |
| use fawiki_p;
select count(*), count(*) - sum(page_is_redirect)
from... |
6 years ago |
| use fawiki_p;
select count(*), count(*) - sum(page_is_redirect)
from... |
6 years ago |
| use fawiki_p;
select count(*), count(*) - sum(page_is_redirect)
from... |
6 years ago |
| use fawiki_p;
select count(*), count(*) - sum(page_is_redirect)
from... |
6 years ago |
| use fawiki_p;
select t1.rev_user_text, t1.iwlinks, sum(t2.freq) total
... |
6 years ago |
| use fawiki_p;
select t1.rev_user_text, t1.iwlinks, sum(t2.freq) total
... |
6 years ago |
| use fawiki_p;
select t1.rev_user_text, t1.iwlinks, sum(t2.freq) total
... |
6 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_timestamp,... |
6 years ago |
| use fawiki_p;
select page_namespcae, page_title, rev_timestamp,... |
6 years ago |
| use fawiki_p;
select *
from revision
where rev_user_text = 'Huji'
and... |
6 years ago |
| use enwiki_p;
select left(afl_timestamp, 8) as day, max(afl_id) maxid
from... |
6 years ago |
| use enwiki_p;
select d1.day, d2.day as nextday, d1.maxid,... |
6 years ago |
| use enwiki_p;
select d1.day, d2.day as nextday, d1.maxid,... |
6 years ago |
| use enwiki_p;
select d1.day, d2.day as nextday, d1.maxid,... |
6 years ago |
| use enwiki_p;
select d1.day, d2.day as nextday, d1.maxid,... |
6 years ago |
| use enwiki_p;
select d1.day, d2.day as next day, d1.maxid,... |
6 years ago |
| use enwiki_p;
select d1.day, d2.day as next day, d1.maxid,... |
6 years ago |
| use enwiki_p;
select left(afl_timestamp, 8) as day, max(afl_id)
from... |
6 years ago |
| use enwiki_p;
select max(afl_id)
from abuse_filter_log
where afl_timestamp >... |
6 years ago |
| use enwiki_p;
select max(afl_id)
from abuse_filter_log |
6 years ago |
