Find actual file location for macOS Ventura Photos picture
I'm trying to clean up my library. Several years back, I put a lot of pictures in my Pictures folder, but not in the Photos Libraray.photoslibrary folder. Now I'm not sure whether those pictures are duplicated in my Photos library. I've tried selecting the image in Photos and click File > Find File in Finder, but that's grayed out. Right-click > Get Info doesn't tell where it is either. If I click File > Consolidate it says its already in the library. I've even tried rummaging around in the Photos.sqlite database with sqlite3 and I can find the image name that I see in Photos, but I can't find the mapping to the name on the filesystem.
What I really want to know is, for a give image in Photos, is it in the System Library (I have 3 libraries. One is the normal system library and 2 copies on a removable drive), and if so, is the file in the Photos Libraray.photoslibrary folder or is it located external to that folder (if that's even possible).
I'm going to take a guess that if the file is located in the Library, that indeed Find File in Finder will be grayed out. If it's located elsewhere, then Find File in Finder will be selectable.
MacBook Pro 15″, macOS 13.5