delete entites with bad enttypes (by name)

DELETE FROM entities
WHERE EXISTS(
SELECT 1 FROM enttypes
WHERE
enttype_id=id
AND TYPE IN
('FinancialMarketIndex',
'Automobile',
'SportingEvent',
'Position',
'Organization',
'Company',
'NaturalFeature',
'Currency',
'Facility',
'IndustryTerm',
'Technology',
'Movie',
'EntertainmentAwardEvent',
'Product',
'SportsEvent',
'PublishedMedium',
'TVShow',
'RadioStation',
'PoliticalEvent',
'Holiday',
'MusicGroup',
'SportsLeague',
'OperatingSystem',
'TVStation',
'FaxNumber',
'PhoneNumber',
'MusicAlbum',
'Anniversary',
'ProgrammingLanguage',
'EmailAddress',
'MarketIndex',
'NaturalDisaster',
'FieldTerminology',
'PrintMedia',
'Sport',
'EntertainmentAward',
'TelevisionStation',
'TelevisionShow',
'RadioProgram',
'SportsGame'));