We are trying to read the trends information for couple of items for selected groups. I noticed that we dont have a trends API.

I tried below query but not giving me any results... Is this SQL correct? did i joined all tables correctly?

select hosts.host,items.name,items.key_,trends.value_min
from items
inner join hosts on hosts.hostid=items.hostid
inner join hosts_groups on hosts.hostid=hosts_groups.hostid
inner join groups on hosts_groups.groupid=groups.groupid
inner join trends on trends.itemid=items.itemid
and items.state=0
and items.status=0
and hosts.status=0
and groups.name like '%WFA%'
and trends.clock > 1453363438