EXPLAIN PARTITIONS
SELECT DISTINCT i.hostid,t.* FROM triggers t,functions f,items i WHERE (i.hostid BETWEEN '95818' AND '99127' OR i.hostid BETWEEN '99129' AND
'99149' OR i.hostid BETWEEN '99151' AND '99171' OR i.hostid BETWEEN '99173' AND '99193' OR i.hostid BETWEEN '99195' AND '99215' OR i.hostid
BETWEEN '99217' AND '99237' OR i.hostid BETWEEN '99239' AND '99259' OR i.hostid BETWEEN '99261' AND '99281' OR i.hostid BETWEEN '99283' AND
'99303' OR i.hostid BETWEEN '99305' AND '99325' OR i.hostid BETWEEN '99327' AND '99347' OR i.hostid BETWEEN '99349' AND '99369' OR i.hostid
BETWEEN '99371' AND '99391' OR i.hostid BETWEEN '99393' AND '99413' OR i.hostid BETWEEN '99415' AND '99435' OR i.hostid BETWEEN '99437' AND '99457' OR i.hostid BETWEEN '99459' AND '99479' OR i.hostid BETWEEN '99481' AND '99501' OR i.hostid BETWEEN '99503' AND '99523' OR i.hostid
BETWEEN '99525' AND '99545' OR i.hostid BETWEEN '99547' AND '99567' OR i.hostid BETWEEN '99569' AND '99589' OR i.hostid BETWEEN '99591' AND '99611' OR i.hostid BETWEEN '99613' AND '99633' OR i.hostid BETWEEN '99635' AND '99655' OR i.hostid BETWEEN '99657' AND '99677' OR i.hostid BETWEEN '99679' AND '99699' OR i.hostid BETWEEN '99701' AND '99721' OR i.hostid BETWEEN '99723' AND '99743' OR i.hostid BETWEEN '99745' AND '99765' OR i.hostid BETWEEN '99767' AND '99787' OR i.hostid BETWEEN '99789' AND '99809' OR i.hostid BETWEEN '99811' AND '99830' OR i.hostid BETWEEN '99832' AND '99851' OR i.hostid BETWEEN '99853' AND '99872' OR i.hostid BETWEEN '99874' AND '99893' OR i.hostid BETWEEN '99895' AND '99914' OR i.hostid BETWEEN '99916' AND '99935' OR i.hostid BETWEEN '99937' AND '99956' OR i.hostid BETWEEN '99958' AND '99977' OR i.hostid BETWEEN '99979' AND '99998' OR i.hostid BETWEEN '100000' AND '100019' OR i.hostid BETWEEN '100021' AND '100040' OR i.hostid BETWEEN '100042' AND '100061' OR i.hostid BETWEEN '100063' AND '100082' OR i.hostid BETWEEN '100084' AND '100103' OR i.hostid BETWEEN '100105' AND '100124' OR i.hostid BETWEEN '100126' AND '100145' OR i.hostid BETWEEN '100147' AND '100166' OR i.hostid BETWEEN '100168' AND '100187' OR i.hostid BETWEEN '100189' AND '100208' OR i.hostid BETWEEN '100210' AND '100229' OR i.hostid BETWEEN '100231' AND '100250' OR i.hostid BETWEEN '100252' AND '100271' OR i.hostid BETWEEN '100273' AND '100292' OR i.hostid BETWEEN '100294' AND '100313' OR i.hostid BETWEEN '100315' AND '100334' OR i.hostid BETWEEN '100336' AND '100355' OR i.hostid BETWEEN '100357' AND '100376' OR i.hostid BETWEEN '100378' AND '100397' OR i.hostid BETWEEN '100399' AND '101167' OR i.hostid BETWEEN '101169' AND '101178' OR i.hostid BETWEEN '101180' AND '101189' OR i.hostid BETWEEN '101192' AND '101201' OR i.hostid BETWEEN '101204' AND '101213' OR i.hostid BETWEEN '101217' AND '101225' OR i.hostid BETWEEN '101229' AND '101237' OR i.hostid BETWEEN '101242' AND '101250' OR i.hostid BETWEEN '101255' AND '101262' OR i.hostid BETWEEN '101267' AND '101274' OR i.hostid BETWEEN '101279' AND '101286' OR i.hostid BETWEEN '101300' AND '101305' OR i.hostid IN ('101291','101292','101293','101294','101296','101297','101307','101311','101314','101315','101316','101317','101319','101320','101322','101326','101329','101330','101331','101332','101334','101335','101337','101341','101344','101345','101346','101348','101350','101351','101353','101357','101360','101361','101362','101364','101366','101367','101369','101373','101376','101377','101378','101380','101382','101383','101385','101389','101392','101393','101394','101396','101398','101399','101401','101405','101408','101409','101411','101413','101414','101416','101419','101422','101423','101425','101427','101428','101430','101433','101436','101437','101439','101441','101442','101444','101447','101450','101453','101455','101456','101458','101461','101463','101465','101467','101469','101471','101473','101475','101477','101479','101481','101483','101485','101487','101489','101491','101493','101495','101497','101499','101501','101503','101505','101507','101509','101511','101513','101515','101517','101519','101521','101523','101525','101527','101529','101531','101533','101535','101537','101539','101540','101541','101543','101545','101547','101549','101551','101553','101555','101557','101559','101561','101563','101565','101567','101569','101571','101573','101575'
,'101577','102073')) AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE
t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN ('0','4')
ORDER BY t.description,t.lastchange DESC