When a recurring gift is amended to change the appeal and amount there is no way to query on the previous appeal/amount.
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.
Steps to Duplicate
1. Create a new recurring gift and note the appeal 2. Add a payment to this recurring gift 3. Add an amendment to the gift increasing the amount and changing the appeal 4. Add a payment at the new amount and to the new appeal 5. Create a revenue query using revenue > recurring gift revenue function history