| SELECT page_title, left(min(rev_timestamp),8) as creationDate
FROM page AS... |
6 months ago |
| |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(DISTINCT(logtemp.log_page)) AS... |
6 months ago |
| select actor name as `Reviewer`, min(`Article Reviews`) as streak
from
(
... |
6 months ago |
| SELECT MONTH(DATE_ADD('2022-01-01', INTERVAL @rn:=@rn+1 MONTH)) as month... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
6 months ago |
| SELECT
actor_name as "Creator",
COUNT(*) AS "Year total",
SUM(CASE WHEN... |
6 months ago |
| SELECT actor_name as "Creator",
COUNT(IF(logtemp.page_is_redirect = 0,... |
6 months ago |
| SELECT actor_name as "Creator",
COUNT(IF(logtemp.page_is_redirect = 0,... |
6 months ago |
| SELECT
actor_name as "Reviewer",
COUNT(*) AS "Year total",
SUM(CASE... |
6 months ago |
