Alert rule via /alert-rules showing as OK, but same rule in /device/${DEVICE_ID}/alerts shows active alarm

Attached are three screen caps showing an alert in three different views with the /alert-rules view showing status is OK, but /alert-log, /device/3/alerts showing the alert is active.

/alert-rules

/alert-log

/device/3/alerts

Any ideas why the difference? It seems to be only happening for this one alert. This one alert is a custom SQL Query, the rest are not.