Query Run
SELECT LEFT(log_timestamp,6) AS 'year/month', CASE log_namespace WHEN 0 THEN... 1 year ago
SELECT LEFT(log_timestamp,6) AS 'year/month', CASE log_namespace WHEN 0 THEN... 1 year ago