Flutterby™! : Where'd that file come from?

Thinking about file metadata for various things, and needed to put down a note here. To get the source URL from downloaded files in Firefox:

SELECT url,title FROM moz_places WHERE id IN (SELECT place_id FROM moz_historyvisits WHERE visit_type = 7);</blokquote>

(From here)

Probably need to copy places.sqlite before querying it with SQLite, 'cause Firefox locks it while it's open.

On MacOS, the file is in /Users/danlyke/Library/Application Support/Firefox/Profiles/*/places.sqlite.