For the meat and potatoes of how things go awry, Shirley Sahrmann does an excellent job of cataloging dysfunction in detail. Keep your eyes out for cheap, used copies of her two volumes on Amazon.
Though if you want a supremely clear explanation of the musculoskeletal system, there is no equal to Dr. Adalbert Kapandji's three volumes. Recent copies of his books are overpriced, but you can get them from your library for free.