Untitled query #45197

SQL

SELECT
  project,
  page_title,
  namespace_id,
  sum(view_count) as count
FROM
  wmf.pageview_hourly
WHERE
  -- Exclude special pages and files.
  namespace_id not in (-1, 6) AND
  -- This should be better understood. It shouldn't be needed.
  -- The existence of this '-' probably hides real pageviews.
  page_title not in ('-') AND
  -- Put the country name here
  country = 'Romania' AND
  -- Put the right month here
  month = 04 AND
  year = 2020 
GROUP BY
  project,
  page_title,
  namespace_id
ORDER BY
  count desc
LIMIT
  100;
SQL

Checking query status...
