historySQL property

@override String get historySQL

Implementation

@override
String get historySQL => """
      SELECT
          datetime(
              visit_time + 978307200, 'unixepoch', 'localtime'
          ) as visit_time,
          url,
          title
      FROM
          history_visits
      INNER JOIN
          history_items
      ON
          history_items.id = history_visits.history_item
      ORDER BY
          visit_time DESC
      LIMIT (?) OFFSET (?);
  """;