Wiki

Here is the SQL we used to find annotations which had not been removed from datasets when the annotated time series was removed.

select a.* from ts_annotation a where a.ts_annotation_id not in (select ats.ts_annotation_id from ts_annotation_time_series ats);