[videodb] fix seasons update query for mysql

Mysql doesn't like SELECT subqueries on the same table.

@popcornmix mind checking that this does the trick?