WITH t AS
(
SELECT
ll_lang, article.page_id AS pid
FROM page talk
... |
2 years ago |
WITH t AS
(
SELECT
ll_lang, article.page_id AS pid
FROM page talk
... |
2 years ago |
WITH t AS
(
SELECT
ll_lang, article.page_id AS pid
FROM page talk
... |
2 years ago |
WITH t AS
(
SELECT
ll_lang, article.page_id AS pid
FROM page talk
... |
2 years ago |
WITH t AS
(
SELECT
ll_lang, article.page_id AS pid
FROM page talk
... |
2 years ago |
WITH t AS
(
SELECT
ll_lang, article.page_id AS pid
FROM page talk
... |
2 years ago |
WITH t AS
(
SELECT
ll_lang, article.page_id AS pid
FROM page talk
... |
2 years ago |
WITH t AS
(
SELECT
ll_lang, article.page_id AS pid
FROM page talk
... |
2 years ago |
WITH t AS
(
SELECT
ll_lang, article.page_id
FROM page talk
INNER... |
2 years ago |
WITH t AS
(
SELECT
ll_lang, article.page_id
FROM page talk
INNER... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id ) OVER (PARTITION BY... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id ) OVER (PARTITION BY... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id ) OVER ( PARTITION BY ll_lang... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id ) OVER ( PARTITION BY ll_lang... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id ) OVER ( PARTITION BY ll_lang... |
2 years ago |
SELECT
ll_lang,
COUNT( x.pid ) OVER ( PARTITION BY ll_lang )
FROM (
... |
2 years ago |
SELECT
ll_lang,
COUNT( x.pid )
FROM (
SELECT ll_lang,... |
2 years ago |
SELECT
ll_lang,
COUNT( x.article.page_id )
FROM (
SELECT ll_lang,... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id )
FROM (
SELECT ll_lang,... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id )
FROM page talk
INNER... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id ) OVER (PARTITION BY... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id ) OVER (PARTITION BY... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id ) OVER (PARTITION BY... |
2 years ago |
SELECT ll_lang, article.page_id, COUNT( DISTINCT article.page_id ) AS... |
2 years ago |
SELECT ll_lang, article.page_id, COUNT(DISTINCT article.page_id AS... |
2 years ago |
SELECT
DISTINCT ll_lang,
COUNT( article.page_id ) OVER (PARTITION BY... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id ) OVER (PARTITION BY... |
2 years ago |
SELECT
ll_lang,
COUNT(DISTINCT article.page_id )
FROM page talk
... |
2 years ago |
SELECT
ll_lang,
COUNT( article.page_id )
FROM page talk
INNER... |
2 years ago |
SELECT ll_lang, article.page_id, article.page_title
FROM page talk
INNER... |
2 years ago |
SELECT
DISTINCT ll_lang,
COUNT(article.page_id) OVER (PARTITION BY... |
2 years ago |
SELECT
DISTINCT ll_lang,
COUNT(article.page_id) OVER (PARTITION BY... |
2 years ago |
SELECT
DISTINCT ll_lang,
COUNT(article.page_id) OVER (PARTITION BY... |
2 years ago |
SELECT ll_lang, COUNT(article.page_id)
FROM page talk
INNER JOIN page... |
2 years ago |
SELECT ll_lang, COUNT(t.articles), total_articles
FROM (
SELECT ll_lang,... |
2 years ago |
SELECT ll_lang, COUNT(article.page_id), total_articles
FROM (
SELECT... |
2 years ago |
SELECT ll_lang, COUNT(article.page_id), total_articles
FROM (
SELECT... |
2 years ago |
SELECT COUNT(DISTINCT article.page_id)
FROM page talk
INNER JOIN page... |
2 years ago |
SELECT COUNT DISTINCT(article.page_id)
FROM page talk
INNER JOIN page... |
2 years ago |
SELECT COUNT(article.page_id)
FROM page talk
INNER JOIN page article ON... |
2 years ago |
SELECT COUNT(*)
FROM page talk
INNER JOIN page article ON talk.page_title... |
2 years ago |
SELECT ll_lang, COUNT(article.page_id)
FROM page talk
INNER JOIN page... |
2 years ago |
SELECT ll_lang, COUNT(article.page_id)
FROM page talk
INNER JOIN page... |
2 years ago |
SELECT ll_lang, article.page_id, article.page_title
FROM page talk
INNER... |
2 years ago |
SELECT
DISTINCT ll_lang,
COUNT(article.page_id) OVER (PARTITION BY... |
2 years ago |
SELECT
DISTINCT ll_lang,
COUNT(article.page_id) OVER (PARTITION BY... |
2 years ago |
SELECT
DISTINCT ll_lang,
COUNT(article.page_id) OVER (PARTITION BY... |
2 years ago |
SELECT DISTINCT ll_lang, COUNT(article.page_id) OVER (PARTITION BY... |
2 years ago |
SELECT ll_lang, COUNT(article.page_id) OVER (PARTITION BY ll_lang)
FROM page... |
2 years ago |
SELECT ll_lang, count(article.page_id)
FROM page talk
INNER JOIN page... |
2 years ago |
SELECT DISTINCT article.page_id, article.page_title, ll_lang,... |
2 years ago |
SELECT DISTINCT article.page_id, article.page_title, ll_lang,... |
2 years ago |
SELECT DISTINCT article.page_id, article.page_title, count(ll_lang)
FROM... |
2 years ago |