09:24:27 # mysqladmin -i 1 processlist | grep zbxweb*
| 1325211 | zabbix | custzbxweb.customer.com:52370 | zabbix | Query | 108 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1327267 | zabbix | custzbxweb.customer.com:56780 | zabbix | Query | 94 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1327734 | zabbix | custzbxweb.customer.com:57732 | zabbix | Query | 120 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1328559 | zabbix | custzbxweb.customer.com:59572 | zabbix | Query | 138 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1330183 | zabbix | custzbxweb.customer.com:35388 | zabbix | Query | 131 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1332374 | zabbix | custzbxweb.customer.com:40474 | zabbix | Sleep | 213 | | | 0.000 |
| 1332741 | zabbix | custzbxweb.customer.com:41180 | zabbix | Query | 84 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1334149 | zabbix | custzbxweb.customer.com:43914 | zabbix | Sleep | 34 | | | 0.000 |
| 1335087 | zabbix | custzbxweb.customer.com:46088 | zabbix | Sleep | 137 | | | 0.000 |
| 1335230 | zabbix | custzbxweb.customer.com:46448 | zabbix | Sleep | 117 | | | 0.000 |
| 1335568 | zabbix | custzbxweb.customer.com:47204 | zabbix | Query | 57 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1335725 | zabbix | custzbxweb.customer.com:47536 | zabbix | Sleep | 63 | | | 0.000 |
| 1336033 | zabbix | custzbxweb.customer.com:48250 | zabbix | Query | 0 | Sending data | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1336065 | zabbix | custzbxweb.customer.com:48328 | zabbix | Sleep | 0 | | | 0.000 |
| 1336106 | zabbix | custzbxweb.customer.com:48410 | zabbix | Query | 0 | Sending data | SELECT m.maintenanceid FROM maintenances m WHERE NOT EXISTS (SELECT NULL FROM maintenances_hosts mh, | 0.000 |
| 1336249 | zabbix | custzbxweb.customer.com:40818 | zabbix | Sleep | 3 | | | 0.000 |
| 1336252 | zabbix | custzbxweb.customer.com:40822 | zabbix | Sleep | 2 | | | 0.000 |
| 1325211 | zabbix | custzbxweb.customer.com:52370 | zabbix | Query | 109 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1327267 | zabbix | custzbxweb.customer.com:56780 | zabbix | Query | 95 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1327734 | zabbix | custzbxweb.customer.com:57732 | zabbix | Query | 121 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1328559 | zabbix | custzbxweb.customer.com:59572 | zabbix | Query | 139 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1330183 | zabbix | custzbxweb.customer.com:35388 | zabbix | Query | 132 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1332374 | zabbix | custzbxweb.customer.com:40474 | zabbix | Sleep | 214 | | | 0.000 |
| 1332741 | zabbix | custzbxweb.customer.com:41180 | zabbix | Query | 85 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1334149 | zabbix | custzbxweb.customer.com:43914 | zabbix | Sleep | 35 | | | 0.000 |
| 1335087 | zabbix | custzbxweb.customer.com:46088 | zabbix | Sleep | 138 | | | 0.000 |
| 1335230 | zabbix | custzbxweb.customer.com:46448 | zabbix | Sleep | 118 | | | 0.000 |
| 1335568 | zabbix | custzbxweb.customer.com:47204 | zabbix | Query | 58 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1335725 | zabbix | custzbxweb.customer.com:47536 | zabbix | Sleep | 64 | | | 0.000 |
| 1336033 | zabbix | custzbxweb.customer.com:48250 | zabbix | Query | 0 | Sending data | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1336106 | zabbix | custzbxweb.customer.com:48410 | zabbix | Query | 0 | Sending data | SELECT m.maintenanceid FROM maintenances m WHERE NOT EXISTS (SELECT NULL FROM maintenances_hosts mh, | 0.000 |
| 1336252 | zabbix | custzbxweb.customer.com:40822 | zabbix | Sleep | 3 | | | 0.000 |
| 1325211 | zabbix | custzbxweb.customer.com:52370 | zabbix | Query | 110 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1327267 | zabbix | custzbxweb.customer.com:56780 | zabbix | Query | 96 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1327734 | zabbix | custzbxweb.customer.com:57732 | zabbix | Query | 122 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1328559 | zabbix | custzbxweb.customer.com:59572 | zabbix | Query | 140 | Sending data | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1330183 | zabbix | custzbxweb.customer.com:35388 | zabbix | Query | 133 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1332374 | zabbix | custzbxweb.customer.com:40474 | zabbix | Sleep | 215 | | | 0.000 |
| 1332741 | zabbix | custzbxweb.customer.com:41180 | zabbix | Query | 86 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1334149 | zabbix | custzbxweb.customer.com:43914 | zabbix | Sleep | 36 | | | 0.000 |
| 1335087 | zabbix | custzbxweb.customer.com:46088 | zabbix | Sleep | 139 | | | 0.000 |
| 1335230 | zabbix | custzbxweb.customer.com:46448 | zabbix | Sleep | 119 | | | 0.000 |
| 1335568 | zabbix | custzbxweb.customer.com:47204 | zabbix | Query | 59 | Copying to tmp table | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |
| 1335725 | zabbix | custzbxweb.customer.com:47536 | zabbix | Sleep | 65 | | | 0.000 |
| 1336033 | zabbix | custzbxweb.customer.com:48250 | zabbix | Query | 0 | Sending data | SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items | 0.000 |

ID User Host Txn Status Time Undo Query Text
1328559 zabbix custzbxweb ACTIVE 01:51 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1330183 zabbix custzbxweb ACTIVE 01:47 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1327734 zabbix custzbxweb ACTIVE 01:37 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1325211 zabbix custzbxweb ACTIVE 01:24 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1327267 zabbix custzbxweb ACTIVE 01:07 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1332741 zabbix custzbxweb202 ACTIVE 00:56 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i1335568 zabbix custzbxweb ACTIVE 00:29 0 SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,i

SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE NOT EXISTS (SELECT NULL FROM graphs_items gi,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('46465047','46465074') WHERE g.graphid=gi.graphid AND gi.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('46465047','46465074') WHERE g.ymin_type=2 AND g.ymin_itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND NOT EXISTS (SELECT NULL FROM items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid IN ('46465047','46465074') WHERE g.ymax_type=2 AND g.ymax_itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<'2' OR MIN(permission) IS NULL OR MIN(permission)=0) AND (i.hostid BETWEEN '10363' AND '10371' OR i.hostid BETWEEN '13338' AND '13343' OR i.hostid BETWEEN '46467304' AND '46467310' OR i.hostid BETWEEN '46471002' AND '46471007' OR i.hostid BETWEEN '46471068' AND '46471084' OR i.hostid BETWEEN '46471092' AND '46471107' OR i.hostid BETWEEN '46471112' AND '46471118' OR i.hostid BETWEEN '46471123' AND '46471129' OR i.hostid BETWEEN '46471131' AND '46471136' OR i.hostid BETWEEN '46471153' AND '46471158' OR i.hostid BETWEEN '46471161' AND '46471165' OR i.hostid BETWEEN '46471171' AND '46471176' OR i.hostid BETWEEN '46471180' AND '46471184' OR i.hostid BETWEEN '46472092' AND '46472099' OR i.hostid BETWEEN '46473069' AND '46473076' OR i.hostid BETWEEN '46473095' AND '46473099' OR i.hostid BETWEEN '46474148' AND '46474153' OR i.hostid BETWEEN '46475017' AND '46475024' OR i.hostid BETWEEN '46475164' AND '46475168' OR i.hostid BETWEEN '46475644' AND '46475648' OR i.hostid BETWEEN '46475673' AND '46475678' OR i.hostid BETWEEN '46475680' AND '46475685' OR i.hostid BETWEEN '46477032' AND '46477039' OR i.hostid BETWEEN '46477378' AND '46477396' OR i.hostid BETWEEN '46477468' AND '46477472' OR i.hostid BETWEEN '46477629' AND '46477633' OR i.hostid BETWEEN '46479036' AND '46479041' OR i.hostid BETWEEN '46479384' AND '46479391' OR i.hostid BETWEEN '46479403' AND '46479408' OR i.hostid BETWEEN '46479701' AND '46479705' OR i.hostid BETWEEN '46479846' AND '46479854' OR i.hostid BETWEEN '46479856' AND '46479869' OR i.hostid BETWEEN '46479871' AND '46479876' OR i.hostid BETWEEN '46481330' AND '46481334' OR i.hostid BETWEEN '46481922' AND '46481926' OR i.hostid BETWEEN '46481945' AND '46481951' OR i.hostid BETWEEN '46483325' AND '46483341' OR i.hostid BETWEEN '46483419' AND '46483423' OR i.hostid BETWEEN '46483438' AND '46483442' OR i.hostid BETWEEN '46484316' AND '46484320' OR i.hostid BETWEEN '46486845' AND '46486850' OR i.hostid BETWEEN '46487966' AND '46487970' OR i.hostid BETWEEN '46487998' AND '46488004' OR i.hostid BETWEEN '46488087' AND '46488091' OR i.hostid BETWEEN '46489326' AND '46489335' OR i.hostid BETWEEN '46489589' AND '46489594' OR i.hostid BETWEEN '46490739' AND '46490746' OR i.hostid BETWEEN '46491675' AND '46491680' OR i.hostid BETWEEN '46493556' AND '46493562' OR i.hostid BETWEEN '46493755' AND '46493759' OR i.hostid BETWEEN '46493772' AND '46493784' OR i.hostid BETWEEN '46493786' AND '46493790' OR i.hostid BETWEEN '46493804' AND '46493815' OR i.hostid BETWEEN '46495231' AND '46495235' OR i.hostid BETWEEN '46495242' AND '46495247' OR i.hostid BETWEEN '46496891' AND '46496895' OR i.hostid BETWEEN '46497307' AND '46497315' OR i.hostid BETWEEN '46497459' AND '46497463' OR i.hostid BETWEEN '46497934' AND '46497945' OR i.hostid BETWEEN '46497948' AND '46497961' OR i.hostid BETWEEN '46498908' AND '46498920' OR i.hostid BETWEEN '46498944' AND '46498950' OR i.hostid BETWEEN '46499562' AND '46499571' OR i.hostid BETWEEN '46499596' AND '46499602' OR i.hostid IN ('10138','10328','10329','10330','10331','10375','10379','10383','10615','10844','10845','10846','11641','12047','12075','12078','12081','12203','12207','12318','12459','12460','12461','12462','12464','12465','12638','12742','12793','12856','12865','12956','12991','12993','12994','12995','12997','13000','13091','13141','13142','13155','13156','13180','13181','13191','13237','13238','13240','13264','13600','13939','13945','13946','13951','13952','13953','14000','14057','14093','14366','14463','14592','14741','14766','14767','14768','14854','45083923','45083984','45083985','46465195','46465250','46465253','46465254','46465263','46465264','46465265','46465306','46465354','46465371','46465372','46465373','46465413','46465435','46465438','46465440','46465442','46465443','46465446','46465458','46465459','46465476','46465484','46465691','46465692','46465901','46465902','46466094','46466199','46466315','46466316','46466324','46466332','46466342','46466460','46466490','46466800','46466801','46466810','46467029','46467032','46467033','46467034','46467035','46467167','46467170','46467212','46467213','46467214','46467215','46467256','46467346','46467425','46467453','46467455','46467458','46467545','46467546','46467667','46467668','46467691','46467718','46467896','46467932','46467978','46467979','46467980','46468435','46468439','46468562','46468566','46468574','46468579','46468601','46468607','46468634','46468635','46468682','46468684','46468686','46468694','46468706','46468712','46468720','46468723','46468727','46468769','46468770','46468784','46468817','46468818','46468856','46468862','46468865','46468868','46468875','46469018','46469019','46469100','46469108','46469253','46469255','46469272','46469932','46470221','46470261','46470262','46470263','46470265','46470266','46470267','46470268','46470527','46470836','46470838','46470890','46470977','46471086','46471087','46471089','46471090','46471109','46471110','46471120','46471121','46471138','46471139','46471140','46471141','46471143','46471144','46471145','46471147','46471148','46471149','46471151','46471168','46471169','46471198','46471286','46471288','46471302','46471307','46471309','46471314','46471417','46471527','46471661','46472070','46472138','46472258','46472259','46472287','46472404','46472405','46472407','46472530','46472621','46472709','46472711','46472734','46472758','46473057','46473058','46473059','46473183','46473205','46473428','46473429','46473438','46473745','46474140','46474158','46474345','46474346','46474377','46474379','46474390','46474391','46474392','46474983','46474984','46474985','46474986','46475011','46475012','46475029','46475048','46475069','46475074','46475159','46475160','46475161','46475162','46475188','46475189','46475212','46475213','46475275','46475280','46475363','46475372','46475374','46475383','46475480','46475491','46475499','46475502','46475504','46475506','46475508','46475509','46475510','46475512','46475515','46475581','46475591','46475596','46475615','46475631','46475633','46475634','46475639','46475641','46475642','46475692','46475885','46475886','46476292','46476294','46476365','46476434','46476452','46476460','46476463','46476465','46476466','46476488','46476490','46476535','46476612','46476613','46476614','46476617','46476618','46476638','46476722','46476724','46476725','46476751','46476758','46477102','46477104','46477373','46477374','46477375','46477376','46477398','46477399','46477410','46477411','46477474','46477476','46477479','46477481','46477486','46477523','46477547','46477556','46477557','46477559','46477614','46477664','46477846','46477907','46478199','46478200','46478284','46478296','46478297','46478349','46478350','46478351','46478358','46478413','46478414','46478418','46478539','46478561','46478563','46478780','46478781','46478782','46478880','46478881','46478962','46479010','46479043','46479044','46479293','46479308','46479310','46479393','46479417','46479571','46479707','46479708','46479709','46479721','46479725','46479728','46479729','46479730','46479735','46479739','46479740','46479741','46479772','46479831','46479883','46479897','46479947','46479948','46479981','46480015','46480035','46480036','46480040','46480041','46480042','46480091','46480235','46480239','46480243','46480247','46480263','46480371','46480372','46480391','46480430','46480608','46480609','46480610','46480611','46480634','46480636','46480637','46480638','46480664','46480748','46480749','46480832','46480833','46480834','46480839','46480840','46480900','46480956','46481234','46481260','46481325','46481479','46481483','46481484','46481534','46481581','46481928','46481930','46481931','46481932','46481940','46481941','46481942','46481943','46482076','46482634','46482715','46482769','46482830','46482850','46482909','46482910','46482925','46482927','46482931','46482932','46482996','46482997','46483049','46483051','46483083','46483085','46483087','46483088','46483089','46483299','46483315','46483316','46483402','46483403','46483404','46483406','46483407','46483426','46483429','46483430','46483433','46483435','46483444','46483446','46483448','46483450','46483457','46483469','46483470','46483472','46483474','46483475','46483476','46483480','46483485','46483488','46483854','46483855','46483856','46483857','46483978','46483981','46484011','46484027','46484028','46484041','46484061','46484068','46484102','46484307','46484309','46484310','46484386','46484387','46484422','46484423','46484507','46484784','46484901','46484960','46484988','46484989','46485006','46485039','46485042','46485053','46485056','46485066','46485067','46485074','46485149','46485269','46485338','46485356','46485389','46485390','46485508','46485513','46485515','46485527','46485530','46485555','46485575','46485579','46485697','46485698','46485699','46485772','46485774','46485776','46485779','46485780','46485892','46485894','46485915','46485929','46485962','46485979','46486086','46486117','46486185','46486186','46486426','46486566','46486567','46486568','46486569','46486604','46486654','46486656','46486664','46486672','46486674','46486852','46486853','46486854','46486855','46486873','46486874','46486882','46486893','46486894','46487001','46487013','46487042','46487053','46487058','46487085','46487098','46487099','46487115','46487119','46487120','46487232','46487263','46487277','46487291','46487292','46487293','46487294','46487306','46487316','46487331','46487333','46487336','46487337','46487538','46487611','46487612','46487773','46487802','46487826','46487828','46487829','46487831','46487834','46487851','46487879','46487880','46487884','46487958','46487963','46487964','46487972','46487980','46488010','46488046','46488056','46488060','46488080','46488081','46488200','46488263','46488384','46488385','46488407','46488471','46488475','46488490','46488497','46488510','46488516','46488521','46488620','46488627','46488653','46488655','46488779','46488796','46488845','46488970','46489092','46489129','46489130','46489172','46489173','46489180','46489182','46489183','46489212','46489213','46489214','46489215','46489227','46489309','46489311','46489312','46489319','46489321','46489322','46489323','46489324','46489376','46489437','46489442','46489488','46489491','46489532','46489542','46489583','46489666','46489685','46489687','46489691','46489697','46489732','46489801','46489820','46489950','46489955','46489956','46489989','46489991','46489992','46489997','46490002','46490010','46490011','46490095','46490371','46490407','46490408','46490513','46490527','46490538','46490545','46490609','46490666','46490667','46490697','46490700','46490709','46490756','46490832','46490936','46490961','46490986','46491001','46491003','46491019','46491021','46491072','46491183','46491201','46491255','46491257','46491316','46491393','46491549','46491550','46491553','46491556','46491568','46491569','46491578','46491591','46491639','46491640','46491647','46491656','46491658','46491659','46491661','46491666','46491668','46491669','46491683','46491684','46491698','46491701','46491716','46491771','46491864','46491866','46491896','46491917','46491927','46491938','46491942','46491963','46492003','46492019','46492021','46492042','46492044','46492045','46492046','46492060','46492108','46492161','46492194','46492195','46492196','46492197','46492219','46492236','46492244','46492325','46492364','46492378','46492382','46492383','46492462','46492465','46492469','46492618','46492715','46492842','46492924','46492937','46492983','46492999','46493005','46493019','46493053','46493055','46493063','46493097','46493098','46493198','46493204','46493205','46493300','46493309','46493310','46493313','46493315','46493316','46493326','46493395','46493396','46493406','46493436','46493505','46493518','46493520','46493568','46493569','46493570','46493578','46493579','46493580','46493610','46493611','46493612','46493614','46493615','46493619','46493620','46493661','46493662','46493699','46493735','46493736','46493741','46493742','46493743','46493747','46493761','46493763','46493764','46493765','46493766','46493768','46493769','46493770','46493798','46493799','46493829','46493831','46493835','46493877','46493881','46493882','46493883','46493884','46493887','46493890','46493903','46493922','46493932','46494076','46494077','46494081','46494082','46494083','46494164','46494423','46494783','46494793','46494828','46494874','46494905','46495020','46495033','46495070','46495081','46495158','46495160','46495229','46495265','46495266','46495288','46495289','46495343','46495344','46495376','46495409','46495440','46495549','46495555','46495585','46495588','46495609','46495610','46495611','46495615','46495713','46495715','46495716','46495751','46495755','46495756','46495792','46495885','46495889','46495890','46495911','46495952','46495964','46495985','46495991','46496015','46496022','46496023','46496027','46496037','46496045','46496048','46496060','46496065','46496078','46496145','46496185','46496189','46496190','46496215','46496268','46496278','46496300','46496324','46496409','46496414','46496438','46496493','46496498','46496505','46496507','46496566','46496608','46496654','46496710','46496742','46496745','46496750','46496760','46496777','46496782','46496783','46496839','46496898','46496900','46496906') OR i.hostid IN ('46496909','46496915','46496918','46496927','46496934','46496942','46496953','46496961','46496962','46496966','46496978','46496983','46496988','46497004','46497009','46497115','46497116','46497122','46497130','46497219','46497235','46497327','46497336','46497351','46497363','46497365','46497373','46497377','46497378','46497404','46497410','46497411','46497412','46497413','46497421','46497434','46497440','46497450','46497451','46497452','46497456','46497457','46497486','46497488','46497504','46497513','46497553','46497587','46497593','46497600','46497609','46497618','46497622','46497623','46497624','46497626','46497631','46497639','46497661','46497672','46497673','46497681','46497682','46497692','46497693','46497758','46497815','46497816','46497817','46497846','46497851','46497852','46497922','46497964','46497976','46497977','46497978','46497979','46497985','46498031','46498032','46498064','46498090','46498130','46498196','46498214','46498215','46498216','46498217','46498228','46498279','46498309','46498441','46498443','46498479','46498492','46498528','46498541','46498608','46498644','46498686','46498697','46498730','46498733','46498775','46498776','46498894','46498898','46498903','46498904','46498965','46499012','46499017','46499205','46499213','46499214','46499215','46499228','46499277','46499279','46499280','46499281','46499288','46499292','46499356','46499361','46499363','46499365','46499366','46499368','46499370','46499373','46499374','46499377','46499378','46499384','46499385','46499388','46499389','46499390','46499416','46499417','46499442','46499445','46499459','46499505','46499532','46499547','46499552','46499558','46499559','46499576','46499608','46499725','46499743','46499820','46499851','46499855','46499883','46499909','46499949','46499956','46499970','46499971','46499972','46499979','46500074','46500076','46500123','46500156','46500181','46500186','46500188','46500190','46500192','46500207','46500229','46500254','46500255','46500326','46500334','46500359','46500370','46500382','46500391','46500412','46500420','46500450','46500704','46500898','46501076')) AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4') GROUP BY i.hostid