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
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
Jim Chilson
Construction Consulting
Regional Consultant
(781) 258-2471
Rich Chudzik
Planning & Construction Advisory Services
President
(716) 436-5563
Eloy Cisneros
Environmental Services
Partner, Environmental Services
(925) 580-1043
Meagan Clark
Business Development
Business Development Executive
(678) 447-5568
Dale Clark
Engineering Services
Senior Managing Materials Scientist
(425) 273-0344
Peter Clutterbuck
Construction Consulting
Senior Regional Consultant
(617) 947-9891
Caleb Cockman
Construction Consulting
Regional Consultant
(336) 465-2562
Gary Colburn
Engineering Services
Senior Managing Engineer
(206) 795-3985
Quentin Commander
Accident Reconstruction & Forensic Animation
Accident Reconstructionist II
(334) 391-6603
Joseph Concia
Construction Consulting
Regional Consultant
Dean Conley
Construction Consulting
Senior Regional Consultant
(205) 977-1996
