SELECT log_user_text AS `reviewer`,
COUNT(DISTINCT(log_page)) AS... |
7 years ago |
SELECT log_user_text AS `reviewer`,
COUNT(DISTINCT(log_page)) AS... |
7 years ago |
SELECT log_user_text AS `reviewer`,
COUNT(DISTINCT(log_page)) AS... |
7 years ago |
SELECT log_user_text AS `reviewer`,
COUNT(DISTINCT(log_page)) AS... |
7 years ago |
SELECT log_user_text AS `reviewer`,
COUNT(DISTINCT(log_page)) AS... |
7 years ago |
SELECT log_user_text AS `reviewer`,
COUNT(DISTINCT(log_page)) AS... |
7 years ago |
SELECT log_user_text AS `reviewer`,
COUNT(log_id) AS `reviews`
FROM... |
7 years ago |
SELECT DISTINCT log_user AS `reviewer`,
COUNT(log_id) AS... |
7 years ago |
SELECT DISTINCT log_user AS `unique_reviewers`,
COUNT(log_id) AS... |
7 years ago |
SELECT COUNT(DISTINCT log_user) AS `unique_reviewers`,
COUNT(log_id)... |
7 years ago |
SELECT EXTRACT(YEAR FROM DATE_FORMAT(log_timestamp,'%Y%m%d%H%i%s')) AS... |
7 years ago |