Why is adding a specific where clause to this MySQL query a performance killing bottleneck?

Sorry for the length, wanted to give a complete description! I have a need to show a report displaying some info about an id from another table and when someone changes countries from a country and within x amount of days. Note how i can have the same country entry in the table multiple times for an id (as the info is queried at regular intervals multiple times, but they may not have moved…