| select
dbname,
substr( url, 9 ) as domain
from
wiki
; |
2 years ago |
| select
dbname,
substr( url, 9 ) as hostname
from
wiki
; |
2 years ago |
| select
dbname,
substr( url, 9 ) as domain
from
wiki
; |
2 years ago |
| select
dbname,
substr( url, 9 ) as domain
from
wiki
where
dbname = 'metawiki'
; |
2 years ago |
| select
dbname,
substr( url, 8 ) as domain
from
wiki
where
dbname = 'metawiki'
; |
2 years ago |
| select
*
from
wiki
where
dbname = 'metawiki'
; |
2 years ago |
| select
dbname,
url,
concat_ws( '.', lang, family, 'org' ) as... |
2 years ago |
| select
dbname,
concat_ws( '.', lang, family, 'org' ) as... |
2 years ago |
| select
*
from
wiki
limit 10
; |
2 years ago |
| select
dbname,
concat_ws( '.', lang, family, 'org' ) as hostname
from
wiki
; |
3 years ago |
| select
dbname,
concat_ws( '.', lang, family, 'org' )
from
wiki
; |
3 years ago |
| select
dbname,
concat_ws( '.', lang, family, 'org' )
from
wiki
limit 10
; |
3 years ago |
| select
dbname,
concat( lang, family, '.org' )
from
wiki
limit 10
; |
3 years ago |
| select
dbname,
concat( lang, family, '.org' )
from
meta.wiki
limit 10
; |
3 years ago |
| select
user_name ug,
concat( w.lang, w.family, '.org' )
from
user
... |
3 years ago |
| select
user_name ug,
concat( w.lang, w.family, '.org' )
from
user
... |
3 years ago |
| select
*
from
wiki
; |
3 years ago |
| select
database(),
user_name
from
user join
user_groups on user.user_id... |
3 years ago |
| select
user_name
from
user join
user_groups on user.user_id =... |
3 years ago |
| select
count(*) as n
from
user_groups
where
ug_group = 'sysop'
; |
3 years ago |
| select
count(*) as n
from
user_group
where
ug_group = 'sysop'
; |
3 years ago |
| select
count(*) as n
from
user_group
where
ug_group = 'sysop'
; |
3 years ago |
| select
count(*) as n
from
user_group
where
ug_group = 'sysop'
; |
3 years ago |
