| SELECT CAST(CONCAT(LEFT(rev_timestamp, 12), '00') AS DATETIME) AS 'minute',
... |
1 week ago |
| SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS 'hour',
... |
1 week ago |
| SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS 'hour',
... |
1 week ago |
| SELECT CAST(CONCAT(LEFT(rev_timestamp, 10), '0000') AS DATETIME) AS 'hour',
... |
1 week ago |
| SELECT RANK() OVER (ORDER BY `Redirect reviews` DESC) AS `No`, actor_name AS... |
1 month ago |
| SELECT RANK() OVER (ORDER BY `Redirect reviews` DESC) AS `No`, actor_name AS... |
1 month ago |
| SELECT RANK() OVER (ORDER BY `Redirect reviews` DESC) AS `No`, actor_name AS... |
1 month ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
1 month ago |
| SELECT actor_name AS `Reviewer`,
COUNT(IF(logtemp.page_is_redirect =... |
1 month ago |
| select replace(log_title, '_', ' '), count(log_id)
from logging
join user on... |
4 months ago |
| select replace(log_title, '_', ' '), count(log_id)
from logging
join user on... |
4 months ago |
