Skip to content

armgit / dub

Public Imported from GitHub
0

The modern link attribution platform. Loved by world-class engineering teams at Twilio, Zillow, Jobber, Vercel, Raycast, and more.

396 B
Raw Blame
TAGS "Dub Misc Endpoints"

NODE endpoint
SQL >

%
    SELECT
        timestamp,
        amount,
        country,
        city,
        latitude,
        longitude
    FROM dub_sale_events_mv
    WHERE
        timestamp > now() - INTERVAL 12 HOUR
        AND country != 'Unknown'
        AND city != 'Unknown'
        AND city != 'Ashburn'
    ORDER BY timestamp DESC
    LIMIT 500

TYPE ENDPOINT