CREATE TEMPORARY TABLE Tcomp (INDEX (Computerid)) SELECT SubGroupwchildren.computerid,SubGroupwchildren.GroupID FROM SubGroupwchildren WHERE  FIND_IN_SET(SubGroupwchildren.groupid,'9') AND SubGroupwchildren.ComputerID NOT IN (SELECT ComputerID FROM AgentIgnore WHERE AgentID=271);SELECT DISTINCT 'C',computers.computerid,computers.Name AS ComputerName,CONVERT(CONCAT(clients.name,' ',locations.name) USING utf8) AS Location, eventlogs.`EventType` AS TestValue,eventlogs.Message FROM ((eventlogs LEFT JOIN Computers ON Computers.ComputerID=eventlogs.ComputerID) LEFT JOIN Locations ON Locations.LocationID=Computers.Locationid) LEFT JOIN Clients ON Clients.ClientID=Computers.clientid JOIN AgentComputerData ON Computers.ComputerID=AgentComputerData.ComputerID WHERE eventlogs.`EventType` IN (1,3) AND  (((eventlogs.SOURCE LIKE 'Server Administrator' AND eventlogs.EventID IN (2336,2057,2049,2266,2123,2048,2057,2094,1306,2335,2266,2095,2166,2238,2188)) OR (eventlogs.SOURCE LIKE 'mraid35%' AND eventlogs.EventID = 117) OR (eventlogs.SOURCE LIKE 'LSI_SAS' AND eventlogs.EventID IN (11,129,7026)) OR (eventlogs.SOURCE LIKE 'lsi_scsi' AND eventlogs.EventID IN (11,129)) OR (eventlogs.SOURCE LIKE 'RAID_SERVER' AND eventlogs.EventID = 140) OR (eventlogs.SOURCE LIKE 'ServerView RAID' AND eventlogs.EventID = 10732) OR (eventlogs.SOURCE LIKE 'disk' AND eventlogs.EventID = 11) OR (eventlogs.SOURCE IN ('mraid2k','mraid35%') AND eventlogs.EventID = 9) OR (eventlogs.SOURCE LIKE 'raidsrc' AND eventlogs.EventID = 9) OR (eventlogs.SOURCE IN ('viamraid', 'viasraid', 'viadsk') AND eventlogs.EventID IN (9,15,117,3681)) OR (eventlogs.SOURCE IN ('a320raid','aac','aar1210','aar81%%','aarich','adpu160m','aic78%%','aic79%%','asa72%%','sptrak','adpu') AND eventlogs.EventID IN (9,11,117)) OR (eventlogs.SOURCE IN ('Cisserv','HpCISSs2','HPQILO2','HP Smart Array') AND eventlogs.EventID IN (11,57,103,129,24584,24606,24674,24607)) OR (eventlogs.SOURCE LIKE 'rr174%' AND eventlogs.EventID = 9) OR (eventlogs.SOURCE IN ('VxSvc_Perc2pro','AFA_AGENT','PercPro','afamgt') AND eventlogs.EventID IN (9,68,571,579,4098))
     ) AND DAYOFWEEK(NOW()) NOT IN (1,7) AND Computers.LastContact > DATE_ADD(NOW(),INTERVAL -15 MINUTE))  AND Computers.ComputerID IN (SELECT ComputerID FROM Tcomp);  DROP TEMPORARY TABLE Tcomp;