SELECT DISTINCT pm.*
            FROM wp_10_postmeta AS pm JOIN
                 wp_10_posts AS p
                 ON pm.post_id = p.ID
            WHERE p.post_status = 'publish'
AND ((meta_key LIKE 'personnel_%_last_name' OR meta_key LIKE 'personnel_%_first_name') AND meta_value LIKE '%michael%')
AND ((meta_key LIKE 'personnel_%_last_name' OR meta_key LIKE 'personnel_%_first_name') AND meta_value LIKE '%humphries%')