How many LEFT JOINS make a VIEW unusable?
The link provided by Martin Smith to an existing SO question provided me with the answer:


  The main restrictions are that foreign key relationships must be based
  on a single key to contribute to the simplification process