The driver of a car that crashed in a Bradford cemetery - killing himself and his friend - was over the limit for drink and drugs.