SELECT reward_id
FROM reward_transaction
WHERE MAX( dateupdated ) < DATE_SUB( CURRENT_DATE( ) , INTERVAL 3 YEAR )
GROUP BY reward_id

#1111 - Invalid use of group function