Substance Abuse Issues in Sexual Offenders

How does alcohol and substance abuse affect the likelihood of violent and/or sexual offenses?