You can also add 'making Sam Carter a black widow whose boyfriends are all doomed' as I remember one cartoonist pointing out.
Although I no longer associate number 1 with Stargate anymore since I feel another 90s genre sci-fi show was a bigger offender on that score - watch this space, hint hint.