Complex sentence: There are many tactics where machine pistols come into play, including room clearing, personal defense, close quarter battle and door breaching.
Split into simpler sentences: There are many tactics were machine pistols come into play. Such as room clearing, personal defense, close quarter battle and door breaching.