| SELECT COUNT(ug_user) FROM `user_groups` WHERE ug_group = 'patroller'; |
6 years ago |
| SELECT COUNT(ug_user) AS number of reviewers FROM `user_groups` WHERE... |
6 years ago |
| SELECT log_id, log_user_text, log_action, log_type, log_user
FROM logging... |
6 years ago |
| SELECT log_id, log_user_text, log_action, log_type, log_user
FROM logging... |
6 years ago |
| SELECT log_id, log_user_text, log_action, log_type, log_user
FROM logging... |
6 years ago |
| SELECT log_id, log_user_text, log_action, log_type, log_user
FROM logging... |
6 years ago |
| SELECT log_id, log_user_text, log_action, log_type, log_user
FROM logging... |
6 years ago |
| SELECT log_user_text, log_action, log_type, log_user
FROM logging
WHERE... |
6 years ago |
| SELECT log_user_text, log_action, ptrp_last_reviewed_by, ug_group
FROM... |
6 years ago |
| SELECT log_user_text, log_action, ptrp_last_reviewed_by, ug_group
FROM... |
6 years ago |
| DESCRIBE enwiki_p.pagetriage_page; |
6 years ago |
| SELECT log_user_text, log_action, ptrp_last_reviewed_by, ug_group
FROM... |
6 years ago |
| SELECT log_user_text, log_action, ptrp_last_reviewed_by, ur_rights
FROM... |
6 years ago |
| SELECT * FROM logging WHERE log_page = 58643833; |
6 years ago |
| SELECT pl_title, count(*)
FROM pagelinks JOIN page ON pl_title =... |
6 years ago |
| SELECT pl_title, count(*),
FROM pagelinks JOIN page ON pl_title =... |
6 years ago |
| SELECT pl_title, count(*),
FROM pagelinks JOIN page ON pl_title =... |
6 years ago |
| SELECT pl_title, count(*),
FROM pagelinks
LEFT JOIN enwiki_p.page ON ... |
6 years ago |
| SELECT pl_title, count(*),
FROM enwiki_p.pagelinks
LEFT JOIN... |
6 years ago |
| SELECT pl_title, count(*),
FROM enwiki.pagelinks
LEFT JOIN enwiki.page... |
6 years ago |
| SELECT
pl_title,
count(*),
page_id
FROM enwiki.pagelinks
LEFT JOIN... |
6 years ago |
| SELECT * FROM logging
WHERE log_title= "Kathryn_Woodard"; |
6 years ago |
| SELECT log_action FROM logging
WHERE log_title= "Kathryn_Woodard"; |
6 years ago |
| SELECT * FROM logging
WHERE log_title= "Kathryn_Woodard"; |
6 years ago |
| SELECT * FROM logging
WHERE log_title= "Kathryn_Woodard" #log_page='58556616'
; |
6 years ago |
| SELECT * FROM logging WHERE log_page=58556616 |
6 years ago |
