How to write an SQL query for SQLite Manager for Firefox places.sqlite?
Use this code to get a list of all the dates and times this specific URL has been 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/?id=1234'
ORDER BY Time DESC
Latest visit will be displayed at top you can invert it by replacing DESC by ASC.