Cacher is the code snippet organizer for pro developers

//http://stackoverflow.com/questions/14777478/magento-showing-wrong-product-count-in-category

DELETE FROM catalog_category_product 
where product_id NOT IN (SELECT entity_id FROM (catalog_product_entity))