Related Post: Mysql Left Join With Condition On Right Table Left Join With Condition On Right Table Left Join Mysql On Multiple Conditions