mysql left outer join example

MySQL LEFT Inner and outer where clause joins