So that text that you want to exclude....is it in a specific field? Can't tell where it would be merely by looking at your query there
Several options here. You could use UNIONS and remove each record w/ that text from each of the queries in the different UNIONS.
select * from ts_admin.editorial where <field> <> 'reissue'
select * from ts_admin.editorial where <field> <> 'scholastic'
select * from ts_admin.editorial where <field> <> 'media tie-in'
select * from ts_admin.editorial where <field> <> 'movie tie-in'
Or you could probably do something with a nested sub-query like so:
where <field> not in (select <field> from ts_admin.editorial where <field2(field containing your text...)> = 'reissue'
or <field2> = 'scholastic'
or <field2> = 'media tie-in'
or <field2> = 'movie tie-in')
Easiest option would probably be to just incorporate the exclusions right into your query:
where season in ('2011 September',
'2011 Fall/ 2012 Winter')
and asset_type = 'Cover Image'
and ([field1] <> 'reissue' OR [field1] <> 'scholastic' OR [field1] <> 'media tie-in' OR [field1] <> 'movie tie-in')
Now if those strings you are wanting to exclude are part of a larger string that you would need to parse out, you have a bit more complicated problem on your hand...though still do-able
Several ways to do it, but whichever you choose, choose the fastest one. Can run explain plans against the different queries to figure out which one is most optimal.