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