Simple Query intermittently returning 0 results
Improve the situation by adding a composite index:

INDEX(awarded, awarded_date)


Is there some other process that is doing bulk changes to awarded?  Perhaps not transaction-safe?