Missing 6-pack achievement during 2025 week 1? #20
Description
Have a PAX, "Will Call" that posted to 6 beatdowns the first week of the year (Dec. 30, 2024 - Jan. 4, 2025) but was never awarded a 6 pack achievement from Weaselbot. Figured it might be because the week technically spanned the calendar year. But figured I'd reach out in case it was in-fact a bug. DBeaver queries against f3stlouis host below. Thanks!
# no achievement
SELECT pax, pax_id, name, description, date_awarded
FROM f3southsound.achievements_view
WHERE date_awarded >= DATE("2025-01-01")
AND pax = "Will Call"
ORDER BY date_awarded DESC
LIMIT 30;
# 6 posts during a week
SELECT `Date`, AO, PAX, Q
FROM f3southsound.attendance_view
WHERE `Date` >= DATE("2024-12-30")
AND `Date` < DATE("2025-01-05")
AND PAX = "Will Call"
ORDER BY `Date`
LIMIT 30;