historySQL property
Implementation
@override
String get historySQL {
return """
SELECT
datetime(
visit_date/1000000, 'unixepoch', 'localtime'
) AS 'visit_time',
url,
moz_places.title
FROM
moz_historyvisits
INNER JOIN
moz_places
ON
moz_historyvisits.place_id = moz_places.id
WHERE
visit_date IS NOT NULL AND url LIKE 'http%' AND title IS NOT NULL
""";
}