问错误号：“on子句”中的1054列'2021-08-23‘

EN

$this->db->select('i.isn_Add_Date,s.scentre_Name,i.isn_Job_No,cp.cpart_Part_Id,cp.cpart_Part,cp.cpart_Qty,cp.cpart_Rate,cp.cpart_Amount,p.product_Name,m.model_Name,c.complaint_Job_No,c.complaint_Add_Date,c.complaint_Under_Warranty,cp.cpart_Qty,cp.cpart_Rate,cp.cpart_Amount');
            
            $this->db->join('complaint_parts as cp', 'c.complaint_Id = cp.cpart_Complaint_Id ', 'left');
            
            $this->db->join('scentres as s', 's.scentre_Id = c.complaint_Scentre_Id', 'left');
            $this->db->join('products as p', 'p.product_Id = c.complaint_Product_Id', 'left');
            $this->db->join('models as m', 'm.model_Id = c.complaint_Model_Id', 'left');

            $this->db->JOIN('isn as i', 'i.isn_Complain_Number = c.complaint_Job_No AND i.isn_Add_Date BETWEEN '.str_replace('/', '-', $fromDate).' AND '.str_replace('/', '-', $toDate).'', 'LEFT'); 
            
            
            
            $this->db->where("c.complaint_Scentre_Id", $serviceCenterId[0]);
            $this->db->where("c.complaint_Status",'Delivered');
            $this->db->where("c.complaint_Trash", 0);
            
            $query = $this->db->get("complaints as c");