Broken R-parity in the sky and at the LHC