SELECT SiteWideName,
sum(IF(notifAlarmLog.UTimeStart - notifAlarmLog.UTimeStop) < 2,1,0)) as less2,
sum(IF(notifAlarmLog.UTimeStart - notifAlarmLog.UTimeStop) > 2 && notifAlarmLog.UTimeStart - notifAlarmLog.UTimeStop) < 10,1,0)) as more2less10,
sum(IF(notifAlarmLog.UTimeStart - notifAlarmLog.UTimeStop) > 10,1,0)) as more10
 FROM notifAlarmLog, fillEventsT WHERE
notifAlarmLog.UTimeStart < fillEventsT.rhicTimeUS-10 AND
notifAlarmLog.UTimeStart > fillEventsT.rhicTimeUS-10 AND
(fillEventsT.event = 'ev-bquench' OR fillEventsT.event = 'ev-yquench')
GROUP BY SiteWideName