SELECT (SELECT COUNT(*) FROM CLOG{0} WHERE SERIALNO={ME} AND STCODE="*LT" AND EVTYPE = 1 AND LOGDATE>=DATEADD(DD,-7,"{DU}") AND EVTYPE=3 AND QUAL=1 AND QUAL7=1)
+
(SELECT COUNT(*) FROM CLOG{1} WHERE SERIALNO={ME} AND STCODE="*LT" AND EVTYPE = 1 AND LOGDATE>=DATEADD(DD,-7,"{DU}") AND EVTYPE=3 AND QUAL=1 AND QUAL7=1)