historySQL property

@override String get historySQL

Implementation

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