Pontifications

Here’s the SQL query from roland-ds1.glitch.me from the previous post, HowTo: Datasette on Glitch for Firefox Desktop support questions January 1 to May 25, 2020

select
  created,
  url,
  title,
  content,
  tags
from
  [sorted-all-desktop-en-us-2020-01-01-2020-05-25-firefox-creator-answers-desktop-all-locales]
where
  "created" >= :p2
  and "created" < :p3
  AND ( "content" like :p0
  or "tags" like :p4
  or "title" like :p6)
order by
  rowid
limit
  1000

where:

p2 = 2020-04-30 16:00:00
p3 = 2020-05-26 00:00:00
p0 = %sync%
p4 = %sync%
p6 = %sync%

And here’s the CSV file (as a Google Spreadsheet)