With Yoast SEO and Admin Columns Pro enabled, I get the following errors anytime I search or filter a post type list:

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1]

[Not unique table/alias: 'wp_postmeta']
SELECT DISTINCT wp_posts.ID FROM wp_posts
LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id)
LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id)
INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
LEFT JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (43)
AND tt1.term_taxonomy_id IN (43)
AND tt2.term_taxonomy_id IN (43)
)
AND (
( wp_postmeta.meta_key = 'parts' AND wp_postmeta.meta_value != '' )
)
AND wp_posts.post_type = 'product'
AND (
(wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')
)
GROUP BY wp_posts.ID
ORDER BY CAST(wp_postmeta.meta_value AS CHAR) ASC