USE commonswiki_p;
SELECT /* SLOW_OK */ DATE_FORMAT(DATE_ADD(img_timestamp,... |
4 years ago |
USE pageviews
str(article_pageviews(project = "de.wikipedia", article =... |
4 years ago |
library(pageviews)
str(article_pageviews(project = "de.wikipedia", article =... |
4 years ago |
SELECT title, SUM(views) total_views
FROM `wikipedia.metrics`
WHERE wiki IN... |
4 years ago |
SELECT title, SUM(views) total_views
FROM `wikipedia.metric`
WHERE wiki IN... |
4 years ago |
SELECT title, SUM(views) total_views
FROM `wikipedia.pageviews_2019`
WHERE... |
4 years ago |
select
url,
css_text_first(content, 'h1#firstHeading') as... |
4 years ago |
select
url,
css_text_first(content, 'h1#firstHeading') as... |
4 years ago |
select
url
from
pages
where
url_domain = 'wikipedia.org' |
4 years ago |