Wraith stunner pistol
The Siege, Part 3 - Wraith warriors wield stunner pistols inside the city of Atlantis.
Runner - Ford possesses a stunner pistol and uses it to threaten McKay into compliance.
The Hive - Shots are fired between Wraith and Ford's coalition, as his people board a hive ship in a joint mission with Colonel Sheppard's unit.
The Long Goodbye - When an alien consciousness possesses Dr. Weir and continues its long war with its enemy, it arms itself with a stunner pistol.