Thanks jittichai,

This is only a partial answer : the article focuses mostly on commercial partnerships, codesharing, which is not necessarily the same as partnerships for earning miles.

Somebody should create a database with all this information, and then we can search it "in all directions".

thanks !!