The question is in the main clause and he has been playing football is not a question of any kind even if it is called an indirect question in grammar books. The word order changes if the beginning of the sentence is omitted. Do you know how long he has been playing football?
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.