| USE plwikisource_p;
SELECT user_name, user_editcount
FROM user_groups
LEFT... |
5 years ago |
| USE plwikisources_p;
SELECT user_name, user_editcount
FROM user_groups
LEFT... |
5 years ago |
| USE plwiki_p;
SELECT user_name, user_editcount
FROM user_groups
LEFT JOIN... |
5 years ago |
| USE plwiki_p;
SELECT user_name, user_editcount
FROM user_groups
LEFT JOIN... |
5 years ago |
| USE plwiki_p;
SELECT user_name, user_editcount
FROM user_groups
LEFT JOIN... |
5 years ago |
| USE plwiki_p;
SELECT user_name,... |
5 years ago |
| USE plwiki_p;
SELECT user_name, user_editcount
SUM(CASE WHEN rev_timestamp... |
5 years ago |
| USE plwiki_p;
SELECT user_name, user_editcount
FROM user_groups
LEFT JOIN... |
5 years ago |
| USE plwiki_p;
SELECT user_name, user_editcount
FROM user_groups
LEFT JOIN... |
5 years ago |
| USE plwiki_p;
SELECT * FROM user_groups; |
5 years ago |
| SHOW TABLES FROM plwiki_p;
|
5 years ago |
| SHOW TABLES plwiki;
|
5 years ago |
| SHOW TABLES plwiki_p;
|
5 years ago |
| USE plwiki_p;
SELECT * FROM user_groups
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM user_group
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM ug_group='sysop'
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM user_groups
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM user
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM user WHERE user_groups = 'sysop'
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM user WHERE ug_groups = 'sysop'
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM user WHERE ug_group = 'sysop'
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM user
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM user;
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM users;
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM logging WHERE log_type='block'
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM logging
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM logging;
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM logging;
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM logging;
LIMIT 10; |
5 years ago |
| USE plwiki_p;
SELECT * FROM logging; |
5 years ago |
| use plwiki_p;
SHOW user_name (WHERE ug_groups = 'sysop'); |
5 years ago |
| use plwiki_p;
SELECT user_ID
FROM user_groups
WHERE ug_groups = 'sysop'; |
5 years ago |
| use plwiki_p;
SELECT user_name
FROM user_groups
WHERE ug_groups = 'sysop'; |
5 years ago |
| use plwiki_p;
SELECT user_name
FROM user
WHERE user_groups = 'sysop'; |
5 years ago |
| use plwiki_p;
SELECT user_name
FROM user
WHERE ug-group = 'sysop'; |
5 years ago |
| SHOW TABLES FROM plwiki_p;
|
5 years ago |
| USE plwiki_p;
SELECT user_name
WHERE ug_group = 'sysop';
|
5 years ago |
| USE plwiki_p;
SELECT
count(*) AS counter,
user_name,
... |
5 years ago |
| USE plwiki_p;
SELECT user_id WHERE user_groups = 'editor'; |
5 years ago |
| USE plwiki_p;
SELECT user_id WHERE user_groups='editor'; |
5 years ago |
