| -- Define your list of article names here
WITH articles_to_check AS (
... |
1 year ago |
| -- Define your list of article names here
WITH articles_to_check AS (
... |
1 year ago |
| SELECT
page.page_title AS page_name,
MAX(revision.rev_id) AS... |
1 year ago |
| SELECT
page.page_title AS page_name,
MAX(revision.rev_id) AS... |
1 year ago |
| SELECT
page.page_title AS page_name,
MAX(revision.rev_id) AS... |
1 year ago |
| SELECT
page.page_title AS page_name,
MAX(revision.rev_id) AS... |
1 year ago |
| SELECT
page.page_title AS page_name,
MAX(revision.rev_id) AS... |
1 year ago |
|
WITH articles_to_check AS (
SELECT
UNNEST(VALUES ('Інцели'),... |
1 year ago |
| WITH articles_to_check AS (
SELECT
unnest(ARRAY['Інцели']) AS... |
1 year ago |
| WITH articles_to_check AS (
SELECT
unnest(ARRAY['Інцели', 'Локатор... |
1 year ago |
| WITH articles_to_check AS (
SELECT
'Локатор (Apple)' AS article_name
... |
1 year ago |
| WITH articles_to_check AS (
SELECT
'Локатор (Apple)' AS article_name
... |
1 year ago |
| WITH articles_to_check AS (
SELECT
'Локатор (Apple)' AS article_name
... |
1 year ago |
| WITH articles_to_check AS (
SELECT
'Локатор (Apple)' AS article_name
... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
FROM... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
FROM... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
FROM... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
FROM... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
FROM... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
FROM... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
FROM... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
FROM... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
FROM... |
1 year ago |
| SELECT p.page_id, p.page_title,
(SELECT COUNT(DISTINCT u2.user_id)
... |
1 year ago |
| SELECT p.page_id, p.page_title, COALESCE(ec.editors_count, 0) AS... |
1 year ago |
| SELECT p.page_id, p.page_title, ec.editors_count
FROM page p
JOIN (
SELECT... |
1 year ago |
| SELECT p.page_id, p.page_title, editors_count
FROM page p
JOIN (
SELECT... |
1 year ago |
| WITH patrollers_count AS (
SELECT p.page_id,
COUNT(DISTINCT... |
1 year ago |
| WITH patrollers_count AS (
SELECT p.page_id,
COUNT(DISTINCT... |
1 year ago |
| WITH patrollers_count AS (
SELECT p.page_id,
COUNT(DISTINCT... |
1 year ago |
| WITH patrollers_count AS (
SELECT p.page_id,
COUNT(DISTINCT... |
1 year ago |
| WITH PatrollerCounts AS (
SELECT p.page_id,
COUNT(DISTINCT... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title, unique_patrollers
FROM page... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title, unique_patrollers
FROM page... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title, unique_patrollers
FROM page... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title, unique_patrollers
FROM page... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title, UniquePatrollers
FROM page... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| SELECT p.page_id, p.page_title,
CASE
WHEN (UniqueEditors >= 10 AND... |
1 year ago |
| SELECT DISTINCT ug_group
FROM user_groups; |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title,
CASE
WHEN... |
1 year ago |
| SELECT p.page_id, p.page_title,
CASE
WHEN (UniqueEditors >= 10 AND... |
1 year ago |
| UPDATE page AS p
SET p.page_content = CASE
WHEN (
SELECT... |
1 year ago |
| CREATE TEMPORARY TABLE temp_articles AS
SELECT p.page_id AS article_id,
... |
1 year ago |
| SELECT p.page_id, p.page_title
FROM page p
JOIN revision r ON p.page_id =... |
1 year ago |
| SELECT p.page_id, p.page_title
FROM page p
JOIN revision r ON p.page_id =... |
1 year ago |
| USE ukwiki_p;
SELECT p.page_id, p.page_title
FROM page p
JOIN revision r ON... |
1 year ago |
| SELECT p.page_id, p.page_title
FROM page p
JOIN revision r ON p.page_id =... |
1 year ago |
