Direct detection of super-thermal photon-number statistics in second-harmonic generation.