SELECT pm.PanelLock,pm.CommisionType,pm.SecurityAmount,pm.OutSideSample,pm.IsFranchise,pm.AllowDueReport,pm.AttachmentFile,pm.PanelEmailId ,pm.IsInvoice,pm.SharePanelId,pm.AllowOutSideContainer,pm.AllowSeniorCitizenDisc,pm.allowsharing ,pm.InvoiceType, pm.HideRate ,pm.isfullpaidreceipt,IFNULL(pm.Centre_ID,'')Centre_ID,pm.HideDiscount,pm.removedoctordiscount,pm.Panel_Code,pm.bde_id ,pm.Territory_ID,pm.ZSM_ID,pm.AreaSalesManager_ID, pm.city,pm.area,pm.state, pm.collectiontype,pm.ShowHeaderinReceipt,pm.ShowMRPinReceipt ,pm.CentreID_Print,pm.ReportDispatchMode,pm.PROID,pm.IsActive,pm.TaxPercentage,pm.SpecialityDoctor,pm.CompanyType ,pm.ServiceProvider,pm.SalesHead,pm.MarketingPerson,pm.FieldBoy, DATE_FORMAT(pm.ContractDate,'%d-%b-%y')ContractDate,pm.ContractPeriod,pm.ContractMonth ,pm.PanelPassword,pm.PanelUserID,pm.PanelGroupID,pm.Payment_Mode,pm.Company_Name,pm.Add1,pm.Add2,pm.Panel_ID,pmIPD.Company_Name AS Ref_Company ,pm.ReferenceCode,pm.Panel_Code,pm.IsTPA,pm.EmailID,pm.Phone,pm.Mobile,pm.Contact_Person,pm.Fax_No,  pmOPD.Company_Name AS Ref_CompanyOPD ,pm.ReferenceCodeOPD,pm.Agreement,IF(pm.IsServiceTax='1','Yes','No')IsServiceTax, DATE_FORMAT(pm.DateFrom,'%d-%b-%y')DateFrom ,DATE_FORMAT(pm.DateTo,'%d-%b-%y')DateTo,pm.CreditLimit,pm.IsLock,pm.printinlab,pm.MinBalReceive mincash,pm.fullpaidpanelid ,pm.AllowTout,pm.MinVal,pm.MaxVal,pm.Region  FROM f_panel_master pm INNER JOIN f_panel_master pmIPD ON pmIPD.Panel_ID = pm.ReferenceCode INNER JOIN f_panel_master pmOPD ON pmOPD.Panel_ID = pm.ReferenceCodeOPD WHERE pm.Company_Name LIKE '%star%'  ORDER BY pm.Company_Name