for example we have 2 site - test1 and test2. yesterday test1 was deleted, all associasion move to test2. new tickets created with test2.

but, all old tickets still have in field "site" test1 and test2. how we can fix it automatically? 

thanks for your help.

sd - 9003, database sql, if this information will be usefull.