All pastes #92802 Raw Edit

Unnamed

public text v1 · immutable
#92802 ·published 2006-07-19 22:49 UTC
rendered paste body
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