Which version had "date first visited"?

Looking at the places.sqlite database, I am not sure that date can be determined accurately in Firefox 15. You can look at the earliest visit on record, but if that data is incomplete, there would be no way to reconstruct it from other fields.

I'm not sure at what version they cancelled the feature, but as an illustration, this is what I noticed:

Firefox used to have this feature: http://www.nirsoft.net/utils/mozilla_history_view.html http://www.nirsoft.net/utils/mozillahistoryview.gif

And now it doesn't: http://techalites.com/2009/02/11/how-to-carry-firefox-history-in-pen-drive/ http://techalites.com/wp-content/uploads/2009/02/mozilla-history-viewer-300x281.png

the change was probably made over 4 years ago, when the bookmark & history system was redesigned for firefox 3 and combined into the places.sqlite database.

https://developer.mozilla.org/en-US/docs/Places/History_Service_Design

So even though NirSoft shows that column on the page, the column does not appear in the current version? Since it is not a Mozilla product, I don't know that anyone at Mozilla could explain how or why it changed. Perhaps it's simply much less convenient to access in the SQLite database than it was in the history.dat file.

As mentioned above, it's possible to determine the earlier visit date still on file. For example, to see the earliest visit to the Google home page, you could run this query in the SQLite Manager extension:

SELECT url, title, visit_count, datetime(first_visit/1000000,'unixepoch') AS EarliestVisit, datetime(last_visit_date/1000000,'unixepoch') AS LatestVisit
FROM moz_places INNER JOIN 
 (SELECT place_id, MIN(visit_date) AS first_visit 
  FROM moz_historyvisits 
  GROUP BY place_id) AS FirstVisits 
 ON FirstVisits.place_id = moz_places.id
WHERE url LIKE 'https://www.google.com/' OR 
url LIKE 'http://www.google.com/'
ORDER BY url

(I'm not a SQL guru, so I certainly do not guarantee that this is the most efficient code.)

A screen shot of the result is attached.

Thanks! You rock!

I noticed that if remove the lines:

WHERE url LIKE 'https://www.cicisvisit.com/' OR url LIKE 'https://www.cicisvisit.com/'

I get a fuller list.

I don't know whether History is allowed to grow indefinitely; I do not have Firefox pruning my history, but there could be some routine maintenance.

I currently show 153,771 "visits" dating back to June 23, 2011. Dividing by 455 days, that's an average of 338 history entries per day. Perhaps I need to get back to work. ;-)

It turns out that I was opening an older database before I replaced my computer last year. Now I'm looking at the new database. The list seems complete :) GREAT!!!

Glad you found it. I forgot to mention that the (Select Profile Database) button is a shortcut to your currently active profile folder.

On the WHERE clause, if you want all URLs on a domain, add a % before the closing ' mark. In other words:

WHERE url LIKE 'https://www.cicisvisit.com/%' OR 
 url LIKE 'https://www.cicisvisit.com/%'

Of course, if you want everything, just leave out the WHERE clause completely (as I assume you have discovered).

You can of course also leave out the starting part.

WHERE url LIKE '%mozilla.org%'

Count me in among the people who would like to see the first visit date and time a specific website was visited on in the history view (and bookmark) in Library in future versions of Firefox. Please add this column if the information is recorded in the places database anyway.

Here is another example of a query that lists all dates and times that a website was visited on.

SELECT url, datetime(visit_date/1000000,'unixepoch') AS Time
FROM moz_historyvisits, moz_places
WHERE
moz_historyvisits.place_id=moz_places.id
AND
url LIKE 'http://www.domain.com/'
ORDER BY Time DESC

Hi Fractalogic, this support forums doesn't work very well as a suggestion box because of the volume of posts and the audience reading it. You can try the following to get more visibility on the proposal:

• Help > Submit Feedback

• Filing a request for enhancement on https://bugzilla.mozilla.org/

You might also try recruiting any developer that created a useful history-related add-on to incorporate this feature.