| SELECT ug_user
FROM user_groups
WHERE ug_group = "bot" |
2 years ago |
| SELECT user_name
FROM user
JOIN user_groups on user_id = ug_user
WHERE... |
2 years ago |
| SELECT *
FROM user
JOIN user_groups on user_id = ug_user
WHERE ug_group = "bot" |
2 years ago |
| SELECT *
FROM user
JOIN user_groups on user_id = ug_user
WHERE user_name =... |
2 years ago |
| SELECT *
FROM user
WHERE user_name = "TheFriendlyRobot"
JOIN user_groups on... |
2 years ago |
| SELECT *
FROM user
JOIN user_groups on user_id = ug_user
LIMIT 10; |
2 years ago |
| SELECT *
FROM user
LIMIT 10; |
2 years ago |
| SELECT rev_id, rev_page, actor_name
FROM revision
JOIN actor on rev_actor =... |
2 years ago |
| SELECT rev_id, rev_page, actor_name
FROM revision
JOIN actor on rev_actor =... |
2 years ago |
| SELECT rev_id, rev_page, actor_name
FROM revision
JOIN actor on rev_actor =... |
2 years ago |
| SELECT rev_id, rev_page, actor_name
FROM revision
JOIN actor on rev_actor =... |
2 years ago |
| SELECT rev_id, rev_page, actor_name
FROM revision
JOIN actor on rev_actor =... |
2 years ago |
| SELECT *
FROM revision
JOIN actor on rev_actor = actor_id
LIMIT 10; |
2 years ago |
| SELECT *
FROM revision
JOIN user on rev_actor = user_id
LIMIT 10; |
2 years ago |
| SELECT *
FROM revision
LIMIT 10; |
2 years ago |
| SELECT *
FROM revision
LIMIT 1; |
2 years ago |
| SELECT rev_id
FROM revision
WHERE rev_timestamp BETWEEN "20150201" AND... |
2 years ago |
