Skip to content

Instantly share code, notes, and snippets.

@kaibosh

kaibosh/recat-tv.sql

Created July 16, 2017 22:12
Show Gist options
  • Save kaibosh/7856b7c35664e8892a133fd65af2fb73 to your computer and use it in GitHub Desktop.
Save kaibosh/7856b7c35664e8892a133fd65af2fb73 to your computer and use it in GitHub Desktop.
Download ZIP
recategorise shows that end up in movies cats based on episode string
Raw
recat-tv.sql
update releases set categories_id = 5020 where searchname like '%s0_e__%' and categories_id = 2010 and passwordstatus = 0;
update releases set categories_id = 5020 where searchname like '%s1_e__%' and categories_id = 2010 and passwordstatus = 0;
update releases set categories_id = 5020 where searchname like '%s2_e__%' and categories_id = 2010 and passwordstatus = 0;
update releases set categories_id = 5030 where searchname like '%s0_e__%' and categories_id = 2030 and passwordstatus = 0;
update releases set categories_id = 5030 where searchname like '%s1_e__%' and categories_id = 2030 and passwordstatus = 0;
update releases set categories_id = 5030 where searchname like '%s2_e__%' and categories_id = 2030 and passwordstatus = 0;
update releases set categories_id = 5040 where searchname like '%s0_e__%' and categories_id = 2040 and passwordstatus = 0;
update releases set categories_id = 5040 where searchname like '%s1_e__%' and categories_id = 2040 and passwordstatus = 0;
update releases set categories_id = 5040 where searchname like '%s2_e__%' and categories_id = 2040 and passwordstatus = 0;
update releases set categories_id = 5030 where searchname like '%s0_e__%' and categories_id = 2070 and passwordstatus = 0;
update releases set categories_id = 5030 where searchname like '%s1_e__%' and categories_id = 2070 and passwordstatus = 0;
update releases set categories_id = 5030 where searchname like '%s2_e__%' and categories_id = 2070 and passwordstatus = 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment