SELECT cast( GROUP_CONCAT( CONCAT('<option value=',CONCAT(pn.Panel_ID,'#',pn.ReferenceCodeOPD,'#',pn.Payment_Mode,'#',pn.MinBalReceive,'#',IF(UPPER(pn.payment_mode)='ADVANCE',pn.inamount+pn.creditlimit-pn.outamount, 0)) ,'#',IFNULL(pn.collectiontype,''),'#',pn.isfullpaidreceipt,'#',pn.hidediscount,'#',pn.removedoctordiscount,'#',pn.hiderate,'#',pn.`AllowTout`,'#',pn.PanelGroupid,'#',pn.AllowOutSideContainer,'#',pn.OutSideSample,'#',pn.`SharePanelId`,'>',CONCAT(pn.Company_Name,'#',IFNULL(ADD2,'')),'</option>') ORDER BY  IF (pn.panel_id='138', '', 'pn.company_name') SEPARATOR '')as char)Company_Name  FROM Centre_Panel cp  INNER JOIN f_panel_master pn ON cp.PanelId=pn.panel_id WHERE cp.CentreId='1'  AND cp.isActive=1 and pn.panel_code<>'' AND pn.isActive=1  order by pn.Panel_ID asc