The only way to fix this is to make different create_date and effective_date columns for every content-type, and to order feeds by effective_date rather than create_date.
For changes that don't need approval, effective_date = create_date
For changes the are approved, effective_date = time approved
For changes in the future, effective_date = scheduled date