charts_same_title_variant (view)

Data license: CC-BY

✎ View and edit SQL

This data as json

0 records

CREATE VIEW charts_same_title_variant AS
SELECT a.title_plus_variant,
    printf("https://owid.cloud/admin/charts/%s/edit", a.id) as chartA,
    printf("https://owid.cloud/admin/charts/%s/edit", b.id) as chartB
FROM charts a
    JOIN charts b ON a.title_plus_variant = b.title_plus_variant
    AND a.id < b.id
WHERE json_extract(a.config, '$.isPublished') = 1
    AND json_extract(b.config, '$.isPublished') = 1
ORDER BY 1;