More than one million pub regulars have shunned visiting the pub during the past seven years, a new survey has revealed.