[@beerallica Participant 10 years, 10 months ago]

Currently at 67K and going.

Some assistance please; this query:

SELECT DISTINCT 'post_author'
FROM 'wp_posts'
AS t1
LEFT JOIN 'wp_users' AS t2 
ON t2.ID = t1.post_author
WHERE t2.ID IS NULL AND t1.post_type = 'reply'
ORDER BY 't1'.'post_author' ASC

returns 306 results. This one:

SELECT COUNT(*)
FROM 'wp_posts'
AS t1
LEFT JOIN 'wp_users' AS t2 
ON t2.ID = t1.post_author
WHERE t2.ID IS NULL AND t1.post_type = 'reply'

returns the number 29547.

So, there are 29547 replies attributed to 306 users that don’t exist in the user table. Will that get fixed by the repair tools or should I stop the process and try something else?