USE viwiki_p;
SELECT *
FROM logging
LEFT JOIN user_groups
ON... |
2 years ago |
USE viwiki_p;
SELECT *
FROM logging
LEFT JOIN user_groups
ON... |
2 years ago |
USE viwiki_p;
SELECT *
FROM logging
LEFT JOIN user_groups
ON... |
2 years ago |
USE viwiki_p;
SELECT *
FROM logging
LEFT JOIN user_groups
ON... |
2 years ago |
USE viwiki_p;
SELECT *
FROM logging
WHERE log_actor IN (SELECT ug_user FROM... |
2 years ago |
USE viwiki_p;
SELECT log_type, log_action
FROM logging
WHERE log_actor IN... |
2 years ago |
USE viwiki_p;
SELECT log_type, log_action
FROM logging
WHERE log_actor IN... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION, log_type, log_action
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION, log_type, log_action
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION, log_type, log_action
FROM... |
2 years ago |
USE viwiki_p;
SELECT *
FROM user
WHERE user_id IN (SELECT ug_user FROM... |
2 years ago |
USE viwiki_p;
SELECT *
FROM user
WHERE user_id IN (SELECT ug_user FROM... |
2 years ago |
USE viwiki_p;
SELECT *
FROM user
WHERE user_id IN (SELECT ug_user FROM... |
2 years ago |
USE viwiki_p;
SELECT *
FROM users
WHERE user_id IN (SELECT ug_user FROM... |
2 years ago |
USE viwiki_p;
SELECT *
FROM users
WHERE log_actor IN (SELECT ug_user FROM... |
2 years ago |
USE viwiki_p;
SELECT ug_user FROM user_groups WHERE ug_group LIKE "bureaucrat" |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION, log_type, log_action
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION, logging.log_type,... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION, logging.log_type,... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION, log_type, log_action
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION, log_type, log_action
FROM... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION, *
FROM logging
WHERE... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION
FROM logging
WHERE log_actor... |
2 years ago |
SELECT * FROM user_groups WHERE ug_group LIKE "bureaucrat" |
2 years ago |
SELECT user_id FROM user_groups WHERE ug_group LIKE "bureaucrat" |
2 years ago |
SELECT user_id FROM user_groups WHERE ug_group LIKE "bureaucrat" |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION
FROM logging
WHERE log_actor... |
2 years ago |
USE viwiki_p;
SELECT COUNT(*) AS NUMBEROFACTION
FROM logging
WHERE log_actor... |
2 years ago |
USE viwiki_p;
SELECT * FROM user_groups WHERE ug_group LIKE "bureaucrat" |
2 years ago |
USE viwiki_p;
SELECT * FROM user_groups WHERE ug_group bureaucrat |
2 years ago |
USE viwiki_p;
SELECT * FROM user_groups |
2 years ago |
USE viwiki_p;
SELECT * FROM user_groups WHERE ug_user IN (SELECT user_id... |
2 years ago |
USE viwiki_p;
SELECT count(*) AS NUMBEROFACTION
FROM logging
WHERE log_actor... |
2 years ago |
USE viwiki_p;
SELECT logging.log_type, logging.log_action,... |
2 years ago |
USE viwiki_p;
SELECT logging.log_type, logging.log_action,... |
2 years ago |
USE viwiki_p;
SELECT logging.log_type, logging.log_action,... |
2 years ago |
USE viwiki_p;
SELECT logging.log_type, logging.log_action,... |
2 years ago |
USE viwiki_p;
SELECT logging.log_type, logging.log_action,... |
2 years ago |
USE viwiki_p;
SELECT user_id FROM user WHERE user_name = "TheFriendlyRobot" |
2 years ago |
USE viwiki_p;
SELECT logging.log_type, logging.log_action,... |
2 years ago |
USE viwiki_p;
SELECT logging.log_type, logging.log_action,... |
2 years ago |
USE viwiki_p;
SELECT *
FROM logging
LIMIT 10; |
2 years ago |
USE viwiki_p;
SELECT *
FROM logging
WHERE log_user_text =... |
2 years ago |
USE viwiki_p;
SELECT *
FROM logging
WHERE log_user_text = TheFriendlyRobot
LIMIT 10; |
2 years ago |
USE viwiki_p;
SELECT *
FROM user_properties
LIMIT 10; |
2 years ago |
USE viwiki_p;
SELECT *
FROM user_groups
LIMIT 10; |
2 years ago |
USE viwiki_p;
SELECT *
FROM user
LIMIT 10; |
2 years ago |
USE viwiki_p;
SELECT *
FROM user |
2 years ago |
USE viwiki_p
SELECT *
FROM user |
2 years ago |
USE viwiki_p
SELECT user.user_name
FROM user |
2 years ago |