SELECT concat(locationid,'#',panel_id) locationid,location FROM st_locationmaster WHERE isactive=1    AND locationid IN ('24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','43','44','45','47')  ORDER BY location