SELECT
count(DISTINCT log_actor),
ug_group
FROM logging
JOIN... |
2 years ago |
SELECT
DISTINCT ug_group
from user_groups
|
2 years ago |
SELECT
DISTINCT ug_group
from user_groups
|
2 years ago |
DESCRIBE
logging
|
2 years ago |
SELECT
count(DISTINCT log_actor),
ug_group
FROM logging
JOIN... |
2 years ago |
SELECT
count(DISTINCT log_actor),
ug_group
FROM logging
JOIN... |
2 years ago |
SELECT
DISTINCT log_actor
FROM logging
JOIN user_groups ON ug_user =... |
2 years ago |
SELECT
DISTINCT ug_group
FROM user_groups
ORDER BY ug_group
|
2 years ago |
SELECT
DISTINCT ug_group
FROM user_groups
WHERE log_timestamp > 20220101000000
|
2 years ago |
SELECT
DISTINCT log_actor
FROM logging
JOIN user_groups ON ug_user =... |
2 years ago |
SELECT
DISTINCT log_actor
FROM logging
JOIN user_groups ON ug_user =... |
2 years ago |
SELECT
DISTINCT log_actor
FROM logging
JOIN user_groups ON ug_user =... |
2 years ago |
SELECT
COUNT(DISTINCT log_actor)
FROM logging
JOIN user_groups ON ug_user... |
2 years ago |
SELECT
COUNT(DISTINCT log_actor)
FROM logging
JOIN user_groups ON ug_user... |
2 years ago |
SELECT
COUNT DISTINCT log_actor
FROM logging
JOIN user_groups ON ug_user... |
2 years ago |
SELECT
COUNT DISTINCT log_actor
FROM logging
JOIN user_groups ON ug_user... |
2 years ago |
SELECT
COUNT DISTINCT log_actor
FROM logging
JOIN user_groups ON ug_user... |
2 years ago |
SELECT
ug_user
FROM user_groups
WHERE ug_group = 'sysop'
LIMIT 10 |
2 years ago |
describe user_groups |
2 years ago |
SELECT
COUNT DISTINCT ug_user,
ug_group
FROM user_groups
WHERE ug_group =... |
2 years ago |
SELECT
COUNT DISTINCT ug_user,
ug_group
FROM user_groups
WHERE ug_group =... |
2 years ago |
SELECT
COUNT DISTINCT ug_user,
ug_group
FROM user_groups
WHERE ug_group =... |
2 years ago |
SELECT
COUNT DISTINCT ug_user,
ug_group
FROM user_groups
WHERE ug_group =... |
2 years ago |
SELECT
COUNT DISTINCT ug_user,
ug_group
FROM user_groups
WHERE (ug_group =... |
2 years ago |
describe user_groups |
2 years ago |
SELECT
COUNT(*)
FROM logging
JOIN user_groups ON ug_user =... |
2 years ago |
SELECT
COUNT DISTINCT log_actor
FROM logging
JOIN user_groups ON ug_user... |
2 years ago |
SELECT
COUNT DISTINCT log_actor
FROM logging
JOIN user_groups ON ug_user... |
2 years ago |
SELECT
COUNT(*)
FROM logging
JOIN user_groups ON ug_user =... |
2 years ago |
SELECT
COUNT(*)
FROM logging
JOIN user_groups ON ug_user =... |
2 years ago |
SELECT
COUNT(*)
FROM logging
JOIN user_groups ON ug_user = log_user
WHERE... |
2 years ago |