Joplin's database is stored as database.sqlite in its profile directory. At least on Linux, it's possible to show the profile directory in a file explorer using Help > Open Profile Directory:
It may also be possible to locate and delete the disappeared folders using the debug info plugin.