McGuireWoods is a law firm with a top-ranked health care team with extensive experience in regulatory issues, financial services, litigation, corporate services, technology, and labor issues.
2008-08-27-788 SELECT * FROM `master` WHERE CompanyID='7723' AND `Profile_Type` LIKE 'resource' AND `Approved` LIKE 'YES' ORDER BY `Member_Priority` ASC LIMIT 0 , 30