SELECT DISTINCT p.* FROM wp_posts p
JOIN wp_postmeta title_category ON p.ID = title_category.post_id  
 AND (title_category.meta_key = 'title_category' AND title_category.meta_value LIKE '%Of Counsel%') WHERE p.post_status = 'publish' AND p.post_type = 'attorney' ORDER BY substring_index(TRIM(p.post_title), ' ', -1) ASC

WSHB's highly skilled attorneys harness their world-class academic, legal and trial experience to deliver the best outcome for you.

Attorney Search

Privacy Policy      |      Site Map

© 2020 Wood Smith Henning & Berman LLP

Subscribe to our mailing list

* indicates required