SELECT ug_user, ug_group
FROM user_groups
WHERE ug_group NOT IN ('ipblock-exempt')
|
2 years ago |
SELECT *
FROM user_groups
WHERE ug_group NOT IN ('ipblock-exempt')
|
2 years ago |
SELECT user_id, user_name, ug_group
FROM user
LEFT JOIN actor ON user_id =... |
2 years ago |
SELECT user_id, user_name, GROUP_CONCAT(ug_group SEPARATOR ",") AS... |
2 years ago |
SELECT user_id, user_name, GROUP_CONCAT(ug_group SEPARATOR ",") AS... |
2 years ago |
SELECT
user_id,
user_name,
... |
2 years ago |
/*SELECT
user_id,
user_name,
... |
2 years ago |
SELECT
user_id,
user_name,
... |
2 years ago |
SELECt ug_user, actor_id, user_name, GROUP_CONCAT(ug_group SEPARATOR ',') AS... |
2 years ago |
SELECt ug_user, user_name, GROUP_CONCAT(ug_group SEPARATOR ',') AS... |
2 years ago |
SELECt ug_user, user_name, GROUP_CONCAT(ug_group SEPARATOR ',') AS... |
2 years ago |
SELECt ug_user, user_name, GROUP_CONCAT(ug_group SEPARATOR ', ') AS... |
2 years ago |
SELECt ug_user, user_name, GROUP_CONCAT(ug_group SEPARATOR ', ') AS... |
2 years ago |
SELECt ug_user, user_name, GROUP_CONCAT(ug_group SEPARATOR ', ') AS... |
2 years ago |
USE zhwiki_p;
SELECt ug_user, user_name, GROUP_CONCAT(ug_group SEPARATOR ',... |
3 years ago |
USE zhwiki_p;
SELECt ug_user, user_name, GROUP_CONCAT(ug_group SEPARATOR ',... |
3 years ago |