Related Post: Mysql Left Join With Where Clause On Right Table Mysql Left Join With Condition On Right Table Left Join With Where Clause On Right Table Left Join Two Tables With Where Clause