Badge preview working, badge assignment not working

[Mittineague]

Only a wild guess, does
CURRENT_TIMESTAMP granted_at
need an AS ?

EDIT
Hmmm, Lokking at a few of the default badge queries, none of them had CURRENT_TMESTAMP in them.