Chop non release groups from tv episode release_name in DB

remove_sub_rlsgroup

UPDATE tv_episodes SET release_name = REPLACE(release_name, '[rartv]', '') WHERE release_name LIKE '%[rartv]';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[rarbg]', '') WHERE release_name LIKE '%[rarbg]';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[eztv]', '') WHERE release_name LIKE '%[eztv]';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[ettv]', '') WHERE release_name LIKE '%[ettv]';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[vtv]', '') WHERE release_name LIKE '%[vtv]';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[GloDLS]', '') WHERE release_name LIKE '%[GloDLS]';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[silv4]', '') WHERE release_name LIKE '%[silv4]';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[Seedbox]', '') WHERE release_name LIKE '%[Seedbox]';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[AndroidTwoU]', '') WHERE release_name LIKE '%[AndroidTwoU]';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '.RiPSaLoT', '') WHERE release_name LIKE '%.RiPSaLoT';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '-NZBGEEK', '') WHERE release_name LIKE '%-NZBGEEK';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '-RP', '') WHERE release_name LIKE '%-RP';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '-20-40', '') WHERE release_name LIKE '%-20-40';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[ www.TorrentDay.com ] - ', '') WHERE release_name LIKE '[ www.TorrentDay.com ] - %';
UPDATE tv_episodes SET release_name = REPLACE(release_name, '[ www.Cpasbien.pw ] ', '') WHERE release_name LIKE '[ www.Cpasbien.pw ] %';

#No spaces or trailing '.' or '-' in release_names pl0x
UPDATE tv_episodes SET release_name = REPLACE(release_name, ' ', '.') WHERE release_name LIKE '% %';
UPDATE tv_episodes SET release_name = SUBSTR(release_name, 1, LENGTH(release_name) - 1) WHERE release_name LIKE '%.';
UPDATE tv_episodes SET release_name = SUBSTR(release_name, 1, LENGTH(release_name) - 1) WHERE release_name LIKE '%-';

UPDATE history SET provider = REPLACE(provider, '[VTV]', '') WHERE provider LIKE '%[VTV]';
UPDATE history SET provider = REPLACE(provider, '[vtv]', '') WHERE provider LIKE '%[vtv]';
UPDATE history SET provider = REPLACE(provider, '[ettv]', '') WHERE provider LIKE '%[ettv]';
UPDATE history SET provider = REPLACE(provider, '[rartv]', '') WHERE provider LIKE '%[rartv]';
UPDATE history SET provider = REPLACE(provider, '[rarbg]', '') WHERE provider LIKE '%[rarbg]';
UPDATE history SET provider = REPLACE(provider, '[eztv]', '') WHERE provider LIKE '%[eztv]';

UPDATE history SET provider = SUBSTR(provider, 1, LENGTH(provider) - 1) WHERE provider LIKE '%.';
UPDATE history SET provider = SUBSTR(provider, 1, LENGTH(provider) - 1) WHERE provider LIKE '%-';