| USE ruwiki_p;
SELECT page_title FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT page_title FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT page_title FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT page_title FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT page_title FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT page_title FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT page_title FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT page_title, fr_flags FROM flaggedrevs
JOIN revision ON... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT DISTINCT fr_flags FROM flaggedrevs
LIMIT 10;
# SELECT *... |
4 years ago |
| USE ruwiki_p;
SELECT DISTINCT fr_flags FROM flaggedrevs
LIMIT 100;
# SELECT... |
4 years ago |
| USE ruwiki_p;
SELECT DISTINCT fr_flags FROM flaggedrevs;
# SELECT * FROM... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs LIMIT 1;
# SELECT * FROM revision... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs LIMIT 1;
# SELECT * FROM revision... |
4 years ago |
| USE ruwiki_p;
# SELECT * FROM revision LIMIT 1;
# SELECT * FROM actor LIMIT... |
4 years ago |
| USE ruwiki_p;
# SELECT * FROM revision LIMIT 1;
# SELECT * FROM actor LIMIT... |
4 years ago |
| USE ruwiki_p;
# SELECT * FROM revision LIMIT 1;
SELECT * FROM actor LIMIT... |
4 years ago |
| USE ruwiki_p;
# SELECT * FROM revision LIMIT 1;
SELECT * FROM actor LIMIT... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM revision LIMIT 1;
# SELECT * FROM flaggedrevs
#... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT ug_group FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT ug_user FROM user_groups
WHERE ug_group = "editor";
#... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM user_groups
LIMIT 10;
# SELECT ug_group FROM... |
4 years ago |
| USE ruwiki_p;
SELECT ug_group FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT ug_group FROM flaggedrevs
LEFT JOIN revision ON rev_id... |
4 years ago |
| USE ruwiki_p;
SELECT ug_group FROM flaggedrevs
LEFT JOIN revision ON rev_id... |
4 years ago |
| USE ruwiki_p;
SELECT ug_group FROM flaggedrevs
JOIN revision ON rev_id =... |
4 years ago |
| USE ruwiki_p;
SELECT ug_group FROM flaggedrevs
WHERE fr_user = (SELECT... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs
WHERE fr_user = 1086556 # (SELECT... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs
WHERE fr_user = (SELECT user_id FROM... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs
WHERE fr_user = (SELECT user_id FROM... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs
LIMIT 10;
# SELECT * FROM logging
#... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM flaggedrevs;
# SELECT * FROM logging
# WHERE... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM logging
WHERE log_type = "review"
AND... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM logging
WHERE log_type = "review"
AND... |
4 years ago |
| USE ruwiki_p;
SELECT * FROM logging
WHERE log_type = "review"
LIMIT 10; |
4 years ago |
| USE ruwiki_p;
SELECT * FROM logging
LIMIT 10; |
4 years ago |
