I expect following query in file support_nag.module (about line 62) to select all tickets matching some filter criteria:
// TODO: Ugly query!
$sql = 'SELECT n.nid FROM {node} n
LEFT JOIN {support_ticket} t ON n.nid = t.nid
WHERE '. implode(' AND ', $where) .
' ORDER BY state ASC, priority DESC, client';
$result2 = db_query($sql);
But the "LEFT JOIN" will result in returning ALL nodes - what is probably not intended.