# this report counts all items which have been deleted
# but corrects for... |
2 years ago |
select * FROM logging
WHERE log_namespace=0 AND log_type='delete' AND... |
2 years ago |
select count(*) FROM logging
WHERE log_namespace=0 AND log_type='delete'... |
2 years ago |
COUNT(DISTINCT log_title) AS cnt
FROM logging
WHERE log_namespace=0 AND... |
2 years ago |
COUNT(DISTINCT log_title) AS cnt
FROM logging
WHERE log_namespace=0 AND... |
2 years ago |
# query3:
SELECT CEILING(SUBSTRING(page_title FROM 2) / 500000) AS bin,... |
2 years ago |