Script for extration data zabbix 1.8.16

[kapi]

Hi
i want to adapt this script (zabbix 2.0) to zabbix 1.8

(SELECT g.name AS HostGroup, h.name AS Host, s.ip AS IpAddress, t.description AS Problem, FROM_UNIXTIME(e.clock) AS DataEvento
FROM triggers t
INNER JOIN functions f ON ( f.triggerid = t.triggerid )
INNER JOIN items i ON ( i.itemid = f.itemid )
INNER JOIN hosts h ON ( i.hostid = h.hostid )
INNER JOIN events e ON ( e.objectid = t.triggerid )
LEFT JOIN hosts_groups hg ON ( hg.hostid=h.hostid )
LEFT JOIN groups g ON ( g.groupid = hg.groupid )
LEFT JOIN interface s ON (s.hostid=h.hostid)
WHERE (g.name LIKE 'CAT.%' AND t.description LIKE '%ICMP%') AND t.status=0
ORDER BY g.name;


Anybody have a script to extrare data from my database zabbix 1.8.x

Thanks