use ptwiki_p;
select CONCAT('[[', page_title,']]')
from page
inner join... |
6 years ago |
use ptwiki_p;
select CONCAT('[[', page_title,']]'), linter_cat
from... |
6 years ago |
use ptwiki_p;
select CONCAT('[[', page_title,']]'), linter_cat
from... |
6 years ago |
use ptwiki_p;
select CONCAT('[[', page_title,']]')
from page
inner join... |
6 years ago |
use ptwiki_p;
select CONCAT('[[', page_title,']]')
from page
inner join... |
6 years ago |
use ptwiki_p;
select CONCAT('[[', page_title,']]')
from page
inner join... |
6 years ago |
use ptwiki_p;
select CONCAT('[[', page_title,']]')
from page
inner join... |
6 years ago |
use ptwiki_p;
select "ptwiki", linter_cat, count(*) from linter join page on... |
6 years ago |
use ptwiki_p;
select "ptwiki", linter_cat, count(*) from linter join page on... |
6 years ago |
use ptwiki_p;
select afl_user_text as nome, max(afl_timestamp) as tempo from... |
6 years ago |
use ptwiki_p;
select afl_user_text, max(afl_timestamp) from... |
6 years ago |
use ptwiki_p;
select afl_user_text, max(afl_timestamp) from... |
6 years ago |
use ptwiki_p;
select afl_user_text, max(afl_timestamp) from... |
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
where afl_timestamp <... |
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
where afl_timestamp between... |
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
order by afl_timestamp desc
limit 100000 |
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
order by afl_timestamp desc
limit 100000 |
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
order by afl_timestamp desc
limit 10000 |
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
order by afl_timestamp desc
limit 10000 |
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
order by afl_timestamp desc
limit 10 |
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
limit 10
order by afl_timestamp desc
|
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
limit 10
order by afl_timestamp desc
|
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
limit 10
order by afl_timestamp desc
|
6 years ago |
use ptwiki_p;
select * from abuse_filter_log
limit 10
order by afl_timestamp desc
|
6 years ago |
use ptwiki_p;
select * from logging
where log_type = 'abusefilter'
limit 10
|
6 years ago |
use ptwiki_p;
DESCRIBE logging
|
6 years ago |
use ptwiki_p;
DESCRIBE text
|
6 years ago |
use ptwiki_p;
DESCRIBE user
|
6 years ago |
describe ptwiki_p;
|
6 years ago |
use ptwiki_p;
select * from text
inner join revision on old_id =... |
6 years ago |
use ptwiki_p;
select * from user where user_name = 'OTAVIO1981' |
6 years ago |
use ptwiki_p;
select * from user where user_id = 207511 |
6 years ago |
use ptwiki_p;
select * from user where user_id = 207504 |
6 years ago |