When I do SELECT COUNT(id) FROM customers it returns 1, 543. But When I JOIN the customers table with a 2nd table that references the IDs the number is actually higher.
Here is the query:
INNER JOIN favs
ON favs.userID = customers.id
So what I'm trying to do is show the IDs that are no longer in the customers table so that I can delete them and the COUNT can be accurate.