historySQL property

@override String get historySQL

Implementation

@override
String get historySQL {
  return """
         SELECT
              datetime(
                  visits.visit_time/1000000-11644473600, 'unixepoch', 'localtime'
              ) as 'visit_time',
              urls.url,
              urls.title
          FROM
              visits INNER JOIN urls ON visits.url = urls.id
          WHERE
              visits.visit_duration > 0
          ORDER BY
              visit_time DESC
      """;
}