SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (100100000013001)) UPDATE triggers SET templateid=0 WHERE triggerid=100100000016918 SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (100100000012996)) UPDATE triggers SET templateid=0 WHERE triggerid=100100000016919 SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (100100000012997)) UPDATE triggers SET templateid=0 WHERE triggerid=100100000016920 SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (100100000074329)) SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (100100000012995)) UPDATE triggers SET templateid=0 WHERE triggerid=100100000016921 SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (100100000013000)) UPDATE triggers SET templateid=0 WHERE triggerid=100100000016922 SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (100100000074330)) SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (100100000074410)) SELECT DISTINCT h.* FROM hosts h, functions f, items i WHERE i.itemid=f.itemid AND h.hostid=i.hostid AND (f.triggerid IN (100100000012994)) UPDATE triggers SET templateid=0 WHERE triggerid=100100000016923 SELECT * FROM items WHERE (hostid IN (100100000010284)) select * from items where itemid=100100000022284 UPDATE items SET templateid=0 WHERE itemid=100100000036197 select * from items where itemid=100100000021903 select * from items where itemid=100100000021904 select * from items where itemid=100100000021905 select * from items where itemid=100100000022285 UPDATE items SET templateid=0 WHERE itemid=100100000036198 select * from items where itemid=100100000022286 UPDATE items SET templateid=0 WHERE itemid=100100000036199 select * from items where itemid=100100000022287 UPDATE items SET templateid=0 WHERE itemid=100100000036200 select * from items where itemid=100100000022288 UPDATE items SET templateid=0 WHERE itemid=100100000036201 select * from items where itemid=100100000022289 UPDATE items SET templateid=0 WHERE itemid=100100000036202 select * from items where itemid=100100000022290 UPDATE items SET templateid=0 WHERE itemid=100100000036203 select * from items where itemid=100100000245897 select * from items where itemid=100100000205113 select * from items where itemid=100100000254077 UPDATE items SET templateid=0 WHERE itemid=100100000254286 select * from items where itemid=100100000258505 UPDATE items SET templateid=0 WHERE itemid=100100000258714 select * from items where itemid=100100000259981 UPDATE items SET templateid=0 WHERE itemid=100100000260190 select * from items where itemid=100100000257029 UPDATE items SET templateid=0 WHERE itemid=100100000257238 select * from items where itemid=100100000255553 UPDATE items SET templateid=0 WHERE itemid=100100000255762 select * from items where itemid=100100000245898 select * from items where itemid=100100000245899 select * from items where itemid=100100000245900 select * from items where itemid=100100000245901 select * from items where itemid=100100000263369 select * from items where itemid=100100000262986 select * from items where itemid=100100000245902 select * from items where itemid=100100000245903 select * from items where itemid=100100000212969 UPDATE items SET templateid=0 WHERE itemid=100100000213183 select * from items where itemid=100100000212056 select * from items where itemid=100100000219056 UPDATE items SET templateid=0 WHERE itemid=100100000219269 select * from items where itemid=100100000212057 select * from items where itemid=100100000244422 UPDATE items SET templateid=0 WHERE itemid=100100000244631 select * from items where itemid=100100000215596 UPDATE items SET templateid=0 WHERE itemid=100100000215809 select * from items where itemid=100100000022291 UPDATE items SET templateid=0 WHERE itemid=100100000036204 select * from items where itemid=100100000021908 select * from items where itemid=100100000220584 UPDATE items SET templateid=0 WHERE itemid=100100000220797 select * from items where itemid=100100000245904 select * from items where itemid=100100000245905 select * from items where itemid=100100000022292 UPDATE items SET templateid=0 WHERE itemid=100100000036205 select * from items where itemid=100100000022293 UPDATE items SET templateid=0 WHERE itemid=100100000036206 select * from items where itemid=100100000022294 UPDATE items SET templateid=0 WHERE itemid=100100000036207 select * from items where itemid=100100000022295 UPDATE items SET templateid=0 WHERE itemid=100100000036208 select * from items where itemid=100100000022296 UPDATE items SET templateid=0 WHERE itemid=100100000036209 select * from items where itemid=100100000022297 UPDATE items SET templateid=0 WHERE itemid=100100000036210 select * from items where itemid=100100000022298 UPDATE items SET templateid=0 WHERE itemid=100100000036211 select * from items where itemid=100100000022299 UPDATE items SET templateid=0 WHERE itemid=100100000036212 select * from items where itemid=100100000022300 UPDATE items SET templateid=0 WHERE itemid=100100000036213 select * from items where itemid=100100000022301 UPDATE items SET templateid=0 WHERE itemid=100100000036214 select * from items where itemid=100100000022302 UPDATE items SET templateid=0 WHERE itemid=100100000036215 select * from items where itemid=100100000022303 UPDATE items SET templateid=0 WHERE itemid=100100000036216 select * from items where itemid=100100000022304 UPDATE items SET templateid=0 WHERE itemid=100100000036217 select * from items where itemid=100100000206879 UPDATE items SET templateid=0 WHERE itemid=100100000207093 select * from items where itemid=100100000022306 UPDATE items SET templateid=0 WHERE itemid=100100000036219 select * from items where itemid=100100000022307 UPDATE items SET templateid=0 WHERE itemid=100100000036220 select * from items where itemid=100100000022308 UPDATE items SET templateid=0 WHERE itemid=100100000036221 select * from items where itemid=100100000022309 UPDATE items SET templateid=0 WHERE itemid=100100000036222 select * from items where itemid=100100000022310 UPDATE items SET templateid=0 WHERE itemid=100100000036223 select * from items where itemid=100100000022312 UPDATE items SET templateid=0 WHERE itemid=100100000036225 select * from items where itemid=100100000022313 UPDATE items SET templateid=0 WHERE itemid=100100000036226 select * from items where itemid=100100000022315 UPDATE items SET templateid=0 WHERE itemid=100100000036228 select * from items where itemid=100100000022316 UPDATE items SET templateid=0 WHERE itemid=100100000036229 select * from items where itemid=100100000245907 select * from items where itemid=100100000245908 select * from items where itemid=100100000246163 select * from items where itemid=100100000022318 UPDATE items SET templateid=0 WHERE itemid=100100000036231 select * from items where itemid=100100000022319 UPDATE items SET templateid=0 WHERE itemid=100100000036232 select * from items where itemid=100100000022320 UPDATE items SET templateid=0 WHERE itemid=100100000036233 select * from items where itemid=100100000022323 UPDATE items SET templateid=0 WHERE itemid=100100000036236 select * from items where itemid=100100000022324 UPDATE items SET templateid=0 WHERE itemid=100100000036237 select * from items where itemid=100100000022325 UPDATE items SET templateid=0 WHERE itemid=100100000036238 select * from items where itemid=100100000022326 UPDATE items SET templateid=0 WHERE itemid=100100000036239 select * from items where itemid=100100000245910 select * from items where itemid=100100000245911 select * from items where itemid=100100000245912 select * from items where itemid=100100000245913 select * from items where itemid=100100000246133 select * from items where itemid=100100000022327 UPDATE items SET templateid=0 WHERE itemid=100100000036240 select * from items where itemid=100100000022328 UPDATE items SET templateid=0 WHERE itemid=100100000036241 select * from items where itemid=100100000022329 UPDATE items SET templateid=0 WHERE itemid=100100000036242 select * from items where itemid=100100000022330 UPDATE items SET templateid=0 WHERE itemid=100100000036243 select * from items where itemid=100100000022331 UPDATE items SET templateid=0 WHERE itemid=100100000036244 select * from applications where hostid=100100000010284 select * from applications where applicationid=100100000000179 update applications set templateid=0 where applicationid=100100000002893 select * from applications where applicationid=100100000000167 DELETE FROM hosts_templates WHERE hostid=100100000010284 AND (templateid IN (100100000010061))