select distinct(s.series_title) from series s, titles t where t.series_id = s.series_id and t.title_ttype = 'EDITOR' and s.series_title like '%fan%' order by s.series_title;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
...matching Series that include EDITOR Titles, that is.
select distinct(s.series_title) from series s, titles t where t.series_id = s.series_id and t.title_ttype = 'EDITOR' and s.series_title like '%fan%' order by s.series_title;
Implemented in r2009-65.