❓ Analyzing Downloads > Buggy `SQL` > "Download-stats-weekly/2026/04.json": 404 (Not Found)."

[adriens]

❔ About

I wanted to give a try to some download stats.

The first one works perfcetly out of the box :

... but the the second following SQL does not work out of the box (while the):

PIVOT (
    UNPIVOT (
        FROM read_json([
            printf('https://community-extensions.duckdb.org/download-stats-weekly/%s.json',
                strftime(x, '%Y/%W')
            )
            FOR x
            IN range(TIMESTAMP '2025-09-22', now()::TIMESTAMP, INTERVAL 1 WEEK)
            IF strftime(x, '%W') != '53'
        ], union_by_name := true)
    )
    ON COLUMNS(* EXCLUDE _last_update)
    INTO NAME extension VALUE downloads
)
ON date_trunc('day', _last_update::TIMESTAMP)
USING any_value(downloads)
ORDER BY extension;

leads to the following error :

Unable to connect to URL "https://community-extensions.duckdb.org/download-stats-weekly/2026/04.json":
404 (Not Found).