listings graphs

[thanhtruong]

i don't know if i can ask this here...

can i have a sql statement for listing the graphs ids per host ?
this sql statement must list only graphs ids which have the associated datasource on

currently, i have this :
CODE: SELECT ALL

$sql = "SELECT * FROM graph_local where host_id = '<id>'";
this give me 6 results on a particular host and i know this host have only 5 graphs and 5 datasources
and i don't know how to select only graphs with active datasources

thanks