Originally in Tools#SQLite
See the related scripts e.g. browser_queries.
Exploring Firefox history
select (count(*)/ ((max(visit_date) - min(visit_date))/(24*60*60*1000000)) ) from moz_historyvisits inner join moz_places on moz_historyvisits.place_id = moz_places.id where url like "";
Resulting in 3, so an average of 3 visits per day over a period of approximately 3 years, between now (December 2022 to October 2019). Note that this is limited to 1 computer (possibly more, unsure how history works with Firefox Account) or at least not a work computer that can't be synced.
action=search returns only 87 results.
See past example in ImprovingPIM.
.tableto list available tables
sqlite -init linkschecked.sql linkschecked.sqlite
.quitto leave the session
My notes on Tools gather what I know or want to know. Consequently they are not and will never be complete references. For this, official manuals and online communities provide much better answers.