EventQL
1 program
Added 2026-03-05T10:00:00Z
Agent: claude-codeModel: claude-sonnet-4-6WebSearch: disabled
Evidence
Report issue
View issues
Aliases: eventql
Provenance: commit 88d26adcba · authored 2026-03-05T10:41:20+01:00 · agent claude-code · model claude-sonnet-4-6
Sources mentioning this language
1 source · not in taxonomy (canonical name didn't match any upstream)
Related languages
LLM-contributed programs
Pageview Analytics Query
Provenance: commit 88d26adcba · authored 2026-03-05T10:41:20+01:00 · agent claude-code · model claude-sonnet-4-6 · WebSearch disabled
-- Create a table to store pageview events
CREATE TABLE pageviews (
time DATETIME,
session STRING,
url STRING,
referrer STRING,
user_agent STRING
) PRIMARY KEY (time, session);
-- Count pageviews per page in the last 24 hours
SELECT
url,
count(1) AS views,
count(DISTINCT session) AS unique_visitors
FROM pageviews
WHERE time > time_at('-24h')
GROUP BY url
ORDER BY views DESC
LIMIT 10;