The classic song started a sequence that makes CCR surely one of the unluckiest bands never to score a US No.1 single.