This query returns a list of people IDs associated with specific find a grave memorial numbers (the memorial numbers are stored in a hidden table in the database, after they are processed the table is emptied and then populated with entries for the next run).
I came up with this when I realized how much time I was spending looking up people IDs to run edits on records that I was updating based on updates that had been done to the associated find a grave memorials.
This query only works with the first find a grave field, if a record has two memorials associated with it and the second one is in the hidden table, it will not match it because it only searches the first find a grave memorial field, not the second one.
There are five options (just added another one 8 July 2023). The first one returns the FAG numbers and people ids in a columnar format but doesn't have clickable links in the screen. The second option is visually almost identical to the first one but the find a grave memorials and the people ids are both clickable, which can be handy. (Note: The People ID will always land on a people record, but if the associated FAG memorial is gone (merged or removed) you will end up on a find a grave page that is not a memorial).
The third option returns the FAG numbers, people ids, and all other fields in the main people table which have corresponding fields in find a grave, also in a columnar format like option one. The idea is I can suck all this information into a spreadsheet and compare it with the new information sucked in from find a grave, so I have a better idea which information is missing or corrupted in the database vs. information that is missing or corrupted in find a grave.
The fourth option exists because I have run into so many duplicated find a grave memorials and it is not always feasible to merge them (one problem being when it is obvious to me that the memorial is duplicated but not at all obvious to some of the administrators at find a grave). I threw in the towel and added a place in the database to store duplicate find a grave memorials and I have linked those to the base people record. The fourth options returns the people id, original fag memorial, and the duplicated fag memorial in one screen. I can use this information to update the database without changing which memorial number is defined as the "original" memorial.
BTW, as an aside the "original" and "duplicate" memorials as I define them are not always chronologically earlier or later. I have found some cases where someone created an earlier memorial for a completely wrong person (not the person who is buried in the location specified) and in those cases I consider the first memorial with the correct information to be the "original", not the first one with the right name in the correct cemetery. I have no idea how find a grave figures it out but I see no point in rewarding lazy and ignorant contributors by having their memorials preserved when someone else who got it right can have their memorial clobbered just because it was created later.
The fifth option makes it easier for me to suck photos out of find a grave. I just recently realized I posted a number of photos on find a grave without them being in this database. The query works off the list of FAG memorial numbers and returns all the information I need to add those photos to the images table in my database and copy the files to the correct folders where they will go on the server.
Click on the appropriate form dialog box below to run the correct query: