| select ukuser.user_id as uk_id,
enuser.user_id as en_id,
ukuser.user_name as... |
6 years ago |
| #select ukuser.user_id as uk_id,
#enuser.user_id as en_id,
#ukuser.user_name... |
6 years ago |
| #select ukuser.user_id as uk_id,
#enuser.user_id as en_id,
#ukuser.user_name... |
6 years ago |
| select ukuser.user_id as uk_id,
enuser.user_id as en_id,
ukuser.user_name as... |
6 years ago |
| use ukwiki_p;
SELECT *
from revision
where rev_user = 107293 |
6 years ago |
| use ukwiki_p;
SELECT *
from user
where user_name = 'Ludde23' |
6 years ago |
| use enwiki_p;
SELECT *
from user
where user_id = 1524194 |
6 years ago |
| use ukwiki_p;
SELECT count(revision.rev_user)
from revision
group by... |
6 years ago |
| use ukwiki_p;
SELECT count(revision.rev_id)
from revision
group by revision.user_id |
6 years ago |
| use ukwiki_p;
SELECT count(*)
from user
join revision
on revision.rev_user =... |
6 years ago |
| use ukwiki_p;
SELECT *
from user
where user_name = 'Sander Säde'
ORDER BY... |
6 years ago |
| use ukwiki_p;
SELECT user_name
from user
where user_name = 'Sander... |
6 years ago |
| use ukwiki_p;
SELECT *
# babel.babel_lang AS lang,
#... |
6 years ago |
| use ukwiki_p;
SELECT user.user_name
# babel.babel_lang AS lang,
... |
6 years ago |
| use enwiki_p;
SELECT user.user_name
# babel.babel_lang AS lang,
... |
6 years ago |
| use ukwiki_p;
SELECT user.user_name
# babel.babel_lang AS lang,
... |
6 years ago |
| use ukwiki_p;
SELECT user.user_name,
babel.babel_lang AS lang,
... |
6 years ago |
| use eswiki_p;
SELECT user.user_name,
babel.babel_lang AS lang,
... |
6 years ago |
