SELECT (SELECT COUNT(*) FROM CLOG{0} WHERE STCODE="RP" AND EVTYPE = 0 AND SERIALNO={ME} AND LOGDATE >= DATEADD(DAY,-30,GETUTCDATE()) + (SELECT COUNT(*) FROM CLOG{1} WHERE STCODE="RP" AND EVTYPE = 0  AND SERIALNO={ME} AND LOGDATE >= DATEADD(DAY,-30,GETUTCDATE())))