I need to find ALL the post_id in table
wp_postmeta that has duplicate sku numbers. I did this with following sql query but the query is not complete.
Now I get the full list of all products as result.
The field post_id is missing but I do not know how to set filter on it if count(post_id > 1)
Is there someone of you who can modify the query and add the missing part to filter only the duplicate sku?
Would be very helpful for me. Thanks in advance.
SELECT * FROM `wp_postmeta` WHERE `meta_key` LIKE '%sku%'