| select l2.*
from (
select... |
2 years ago |
| select l2.*
from (
select... |
2 years ago |
| select l2.*
from (
select... |
2 years ago |
| select l2.*
from (
select... |
2 years ago |
| select
REGEXP_SUBSTR(SUBSTRING(l.log_params,5),'curid";s:\\d+:"\\K\\d+')... |
2 years ago |
| select
REGEXP_SUBSTR(SUBSTRING(l.log_params,5),'curid";s:\\d+:"\\K\\d+')... |
2 years ago |
| select
REGEXP_SUBSTR(SUBSTRING(l.log_params,5),'curid";s:\\d+:"\\K\\d+')... |
2 years ago |
| select
REGEXP_SUBSTR(SUBSTRING(l.log_params,5),'curid";s:\\d+:"\\K\\d+')... |
2 years ago |
| select... |
2 years ago |
| select
REGEXP_SUBSTR(l.log_params,'(?m)curid";s;\\d+:"\\K\\d+')... |
2 years ago |
| select REGEXP_SUBSTR(l.log_params,'(?m)curid";s;\\d+:"\\K\\d+')... |
2 years ago |
| select REGEXP_SUBSTR(l.log_params,'(?m)curid";s;\\d+:"\\K\\d+?')... |
2 years ago |
| select l.*,REGEXP_SUBSTR(l.log_params,'curid";s;\\d+:"\\K\\d+?') curid
from... |
2 years ago |
| select l.*,REGEXP_SUBSTR(l.log_params,'curid";s;\\d+:"(\\d+?)";') curid... |
2 years ago |
| select l.* /*,ls.* */
from logging l
/* left join log_search ls on l.log_id... |
2 years ago |
| select l.* /*,ls.* */
from logging l
/* left join log_search ls on l.log_id... |
2 years ago |
| select l.*,ls.*
from logging l
left join log_search ls on l.log_id =... |
2 years ago |
| select l.*,ls.*
from logging l
left join log_search ls on l.log_id =... |
2 years ago |
| select l.*,ls.*
from logging l
left join log_search ls on l.log_id =... |
2 years ago |
| select l.*,ls.*
from logging l
left join log_search ls on l.log_id =... |
2 years ago |
| select l.*,ls.*
from logging l
left join log_search ls on l.log_id =... |
2 years ago |
| select l.*,ls.*
from logging l
left join log_search ls on l.log_id =... |
2 years ago |
| select l.*
from logging l
where l.log_type ='patrol'
order by... |
2 years ago |
| /*
show databases;
*/
select * from interwiki;
|
2 years ago |
| /*
show databases;
*/
USE mw_central;
select * from interwiki;
|
2 years ago |
| /*
show databases;
*/
USE mw_central;
select * from interwiki;
|
4 years ago |
| /*
show databases;
*/
USE centralauth_p;
select * from interwiki;
|
4 years ago |
| show databases;
/*
USE metawiki_p;
select * from interwiki;
*/ |
4 years ago |
| /*show databases;*/
USE metawiki_p;
select * from interwiki;
|
4 years ago |
| show databases;
/*USE meta;
//select * from interwiki;
*/ |
4 years ago |
| USE meta;
select * from interwiki; |
4 years ago |
| USE zhwiki_p;
select * from interwiki; |
4 years ago |
| use zh_wiki;
select * from interwiki; |
4 years ago |
| use zhwiki;
select * from interwiki; |
4 years ago |
