A star diagonal, the term commonly associated with 90° mirror diagonals such as this, lets you view objects that are at a 90° angle from the direction the telescope is pointing.  This allows quite comfortable viewing when the telescope is at or near the zenith(directly overhead), and is fairly comfy when observing terrestrial imagery as well-albeit a bit unorthodoxed at first.
Celestron's erect image diagonals are Amici prism designs, meaning that images are upright and laterally correct.  This design, however, instead renders images which are laterally reversed but are brighter than erect image diagonals.  The #93519 diagonal is used with 2.00" focusers and can be used with either 2.00" or 1.25" eyepieces, thanks to the included adapter which reduces the eyepiece barrel diameter to accept the smaller size.  Works both with Schmidt-Cassegrain telescopes or refractors.