Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Prevent duplicate contributors for same company, remove existing #236

Open
iandunn opened this issue Nov 3, 2023 · 0 comments
Open

Prevent duplicate contributors for same company, remove existing #236

iandunn opened this issue Nov 3, 2023 · 0 comments
Milestone

Comments

@iandunn
Copy link
Member

iandunn commented Nov 3, 2023

Some companies have added the same contributor twice, probably by accident or because they forgot they were already added.

We should prevent that from happening, and remove the existing instances.

Examples

There's probably more, though.

This query helps to find them, but it'll also include folks who are legitimately sponsored by multiple companies. Make sure you don't prevent/remove that.

SELECT post_title, count(*) title_count
FROM `wporg_668_posts`
where post_type = '5ftf_contributor' and post_status = 'publish'
group by post_title
having title_count > 1
@iandunn iandunn added this to the Stats milestone Nov 3, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant