zabbix SQL

SELECT
TIMESTAMPDIFF(
SECOND,
from_unixtime(triggers.lastchange),
CURRENT_TIMESTAMP ()
) AS second_diff,
triggers.triggerid AS tid,
triggers.description,
triggers.status,
triggers.priority,
triggers.lastchange,
from_unixtime(triggers.lastchange) AS lasttime,
from_unixtime(Item.lastlogsize) AS changetime,
Item.units,
Item.hostid,
hosts.host,
hosts.name,
triggers.expression,
Item.delay,
FROM_UNIXTIME(events.clock) AS clock,
events.objectid,
events.eventid,
MAX(events.eventid) AS eid,
events.acknowledged,

IF (
   (
      SELECT
         acknowledged
      FROM
         `events`
      WHERE
         objectid = tid
      ORDER BY
         eventid DESC
      LIMIT 1
   ) = 0,
   'N',
   'Y'
) AS n_acknowledged
FROM
   `triggers`
INNER JOIN functions ON `triggers`.triggerid = functions.triggerid
INNER JOIN items  Item ON functions.itemid = Item.itemid
INNER JOIN `hosts` ON Item.hostid = `hosts`.hostid
LEFT JOIN `events` ON `events`.objectid = `triggers`.triggerid
WHERE
   `triggers`.`value` = 1
AND `triggers`.priority != 1
AND `hosts`. STATUS = 0
AND `events`.`object` = 0
AND `events`.`value` = 1
GROUP BY
   functions.triggerid
ORDER BY
   lasttime,
   clock DESC

SELECT
TIMESTAMPDIFF(
SECOND,
from_unixtime(triggers.lastchange),
CURRENT_TIMESTAMP ()
) AS second_diff,
triggers.triggerid AS tid,
triggers.description,
triggers.status,
triggers.priority,
triggers.lastchange,
from_unixtime(triggers.lastchange) AS lasttime,
from_unixtime(items.lastclock) AS changetime,
items.units,
items.hostid,
hosts.host,
– hosts.n_location,
hosts.host,
– hosts.n_url,
triggers.expression,
items.lastvalue,
FROM_UNIXTIME(events.clock) AS clock,
events.objectid,
events.eventid,
MAX(events.eventid) AS eid,
events.acknowledged,

IF (
(
SELECT
acknowledged
FROM
events
WHERE
objectid = tid
ORDER BY
eventid DESC
LIMIT 1
) = 0,
‘N’,
‘Y’
) AS n_acknowledged
FROM
triggers
INNER JOIN functions ON triggers.triggerid = functions.triggerid
INNER JOIN items ON functions.itemid = items.itemid
INNER JOIN hosts ON items.hostid = hosts.hostid
LEFT JOIN events ON events.objectid = triggers.triggerid
WHERE
triggers.value = 1
AND triggers.priority != 1
AND hosts. STATUS = 0
AND events.object = 0
AND events.value = 1
GROUP BY
functions.triggerid
ORDER BY
clock DESC