SELECT distinct p.ID id
FROM yadata_posts p
JOIN yadata_postmeta meta0 ON p.ID = meta0.post_id AND meta0.meta_key = 'is_active'
JOIN yadata_postmeta meta_order ON p.ID = meta_order.post_id AND meta_order.meta_key = 'associate_details_last_name'
WHERE
p.post_status = 'publish'
AND (meta0.meta_value = 'TRUE' or meta0.meta_value = '1')
AND p.post_type = 'associates' order by p.post_title asc
Matt Buckner
Engineering Services
Director, Engineering
(615) 815-5467
Saul Buendia
Accident Reconstruction & Forensic Animation
Accident Reconstructionist
(310) 218-1893
Jim Bullington
Fire & Explosion Investigation
Fire Consultant
(954) 815-1306
Maria Burnette
Environmental Services
Senior Consultant
(470) 302-1219
Christine Callahan
Construction Consulting
Senior Consultant
(702) 927-6665
Christopher Campbell
Construction Consulting
Regional Consultant
(423) 400-5201
Mark Cantalamessa
Construction Consulting
Managing Partner
(412) 616-9220
Eric Cardenas
Accident Reconstruction & Forensic Animation
Senior Forensic Animator
(310) 218-1662
Philip Casso
Engineering Services
Senior Project Manager
(210) 409-5503
Rich Chudzik
Planning & Construction Advisory Services
President, Planning & Construction Advisory Services
(716) 436-5563
Eloy Cisneros
Environmental Services
Partner, Environmental Services
(925) 580-1043
Dale Clark
Engineering Services
Senior Managing Materials Scientist
(425) 273-0344
Meagan Clark
Business Development
Business Development Executive
(678) 447-5568
Peter Clutterbuck
Construction Consulting
Senior Regional Consultant
(617) 947-9891