| use fawiki_p;
select user_name, count(*)
from abuse_filter_log
join user
... |
4 years ago |
| use fawiki_p;
select afl_user, count(*)
from abuse_filter_log
where... |
4 years ago |
| use fawiki_p;
select afl_user, count(*)
from abuse_filter_log
where... |
4 years ago |
| use fawiki_p;
select *
from abuse_filter_log
limit 10 |
4 years ago |
| use fawiki_p;
select *
from abuse_log
limit 10 |
4 years ago |
| use fawiki_p;
select
rc_title,
SUM(
CASE
WHEN ct_tag_id = 10... |
4 years ago |
| use fawiki_p;
select
rc_title,
SUM(
CASE
WHEN ct_tag_id = 10... |
4 years ago |
| use fawiki_p;
select
rc_title,
SUM(
CASE
WHEN ct_tag_id = 10... |
4 years ago |
| use fawiki_p;
select
page_id,
rc_title,
SUM(
CASE
WHEN... |
4 years ago |
| use fawiki_p;
select
page_id,
rc_title,
SUM(
CASE
WHEN... |
4 years ago |
| use fawiki_p;
select
page_id,
rc_title,
SUM(
CASE
WHEN... |
4 years ago |
| use fawiki_p;
select
page_id,
page_title,
SUM(
CASE
WHEN... |
4 years ago |
| use fawiki_p;
select
page_id,
page_title,
SUM(
CASE
WHEN... |
4 years ago |
| use fawiki_p;
select
page_id,
page_title,
SUM(
CASE
WHEN... |
4 years ago |
| use fawiki_p;
select
page_id,
page_title,
SUM(
CASE
WHEN... |
4 years ago |
| use fawiki_p;
select
rc_id,
rc_timestamp,
actor_user,
actor_name,
... |
4 years ago |
| use fawiki_p;
select
rc_id,
rc_timestamp,
rc_actor,
comment_text,
... |
4 years ago |
| use fawiki_p;
select
rc_id,
rc_timestamp,
rc_actor,
rc_comment_id,
... |
4 years ago |
| use fawiki_p;
select
rc_id,
rc_timestamp,
rc_actor,
rc_comment_id,
... |
4 years ago |
| use fawiki_p;
select
rc_id,
rc_timestamp,
rc_actor,
rc_comment_id,
... |
4 years ago |
| use fawiki_p;
select
rc_id,
rc_timestamp,
rc_actor,
rc_comment_id,
... |
4 years ago |
| use fawiki_p;
select
rc_id,
rc_timestamp,
rc_actor,
rc_comment_id,
... |
4 years ago |
| use fawiki_p;
select
rc_id,
rc_timestamp,
rc_actor,
rc_comment_id,
... |
4 years ago |
| use fawiki_p;
select *
from recentchanges
join revision
on rc_this_oldid =... |
4 years ago |
| use fawiki_p;
select *
from recentchanges
join revision
on rc_this_oldid =... |
4 years ago |
| use fawiki_p;
select *
from recentchanges
join revision
on rc_cur_id =... |
4 years ago |
| use fawiki_p;
select *
from recentchanges
join revision
on rc_cur_id =... |
4 years ago |
| use fawiki_p;
select *
from recentchanges
where rc_title =... |
4 years ago |
| use fawiki_p;
select *
from recentchanges
order by rc_id desc
limit 100 |
4 years ago |
| use fawiki_p;
select *
from recentchanges
join revision
on rec_rev =... |
4 years ago |
| use fawiki_p;
select *
from recentchanges
join revision
on rec_rev =... |
4 years ago |
