Getting (Days Visited) in CSV User List Report

I’ve written the query required for that:

SELECT
    u.username_lower AS "username",
    stats.days_visited
FROM users u
LEFT JOIN user_stats stats ON stats.user_id = u.id
ORDER BY u.id

Though such data is actually useful in the user list report to get some insight.

Thanks @Mittineague :rose:

5 Likes