SELECT (SELECT COUNT(*) FROM CLOG{0} WHERE STCODE="BA2" AND EVTYPE = 1 AND ZONE={ZN} AND SERIALNO={ME} AND LOGDATE >= DATEADD(MINUTE,-60,GETUTCDATE())
+
(SELECT COUNT(*)  FROM CLOG{1} WHERE STCODE="BA2" AND EVTYPE = 1 AND ZONE={ZN} AND SERIALNO={ME} AND LOGDATE >= DATEADD(MINUTE,-60,GETUTCDATE())))