Not expecting a big change in performance here. But generally it's better to have two simple queries that can be fully read from index instead of joining the tables etc. The join should be straight forward though as well because it should be also created based on the index, however the two individual queries should be still faster.
Also another tweak is that for deleted sites we don't need to look at
ts_archived. This actually does make things quite a bit faster.