fix query to ignore one-off tips that happen during payday