historySQL property

@override String get historySQL

Implementation

@override
String get historySQL => """
        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
        LIMIT (?) OFFSET (?);
      """;