Degen

Bug in the Airdrop 2 Leaderboard (Live)
----------------------------------------
There are duplicate rows in dune.degentokenbase.tip_allowances for today's allowance for all fids. This table is used to verify the allowance for the current day. Due to these duplicate entries, the INNER JOIN operation returns multiple rows (2 times) for the same fid on the same block_day, causing the SUM(tips.tip_amount) calculation to count the same tip multiple times (2 times)

If the duplicated tips fall within today's allowance, the points increase incorrectly by two times. Conversely, if they exceed the allowance, the points become invalid, even though the tip itself is valid.

For some people, points are increased two times of that tip and for some people, it became invalid points. 

Solution:

1. Remove duplicate rows from the tip_allowances table.

2. As a future-proof measure, ensure the join returns only one distinct row per fid and block_day to prevent accidental duplications from affecting calculations.