split statement into three for better index utilisation

The overall statement takes 158 seconds for me because no index can be used. With the two new indexes, the individual statements only take a total of 20 seconds for me.