How to get all February 2026 SUMO Thunderbird Desktop Questions from my CSV files (updated via a github action once per hour)l use 'select all' to unify the 28 CSVs once per day and TIL you can add fields using 'select'

Draft created: Mar 10, 2026 14:21 (UTC).
A lite.datasette.io SQLite query to get all 42 support.mozilla.org (aka SUMO) Thunderbird Desktop questions in February 2026 that mention ‘yahoo’
How to use multiple CSVs in datasette: Simon Willison:: 2022:: Joining CSV files in your browser using Datasette Lite
geeksforgeeks Union All: QUOTE: “SQLite UNION ALL operator combines multiple select statements and fetches the entire data. Union All fetches the duplicate rows too. The select statement must have the same number of columns with the same data type and the first select statement column names are used as the result set column names. It helps to unite the multiple select statements to retrieve the specified output. In simple words, it is used to fetch data from multiple tables.”

I like this example of adding a field called “Type” in a “select” statement from sqlitetutorial.net’s UNION ALL tutorial at: https://www.sqlitetutorial.net/sqlite-union/

SELECT
  FirstName,
  LastName,
  'Employee' AS Type
FROM employees
UNION
SELECT
  FirstName,
  LastName,
  'Customer'
  FROM customers
  ORDER BY
      FirstName,
      LastName;

Thank you Simon Willison for your wonderful datasette software!

The actual query for SQLite nerds :-)

select * from [2026-02-01-2026-02-01-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-02-2026-02-02-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-03-2026-02-03-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-04-2026-02-04-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-05-2026-02-05-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-06-2026-02-06-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-07-2026-02-07-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-08-2026-02-08-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-09-2026-02-09-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-10-2026-02-10-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-11-2026-02-11-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-12-2026-02-12-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-13-2026-02-13-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-14-2026-02-14-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-15-2026-02-15-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-16-2026-02-16-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-17-2026-02-17-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-18-2026-02-18-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-19-2026-02-19-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-20-2026-02-20-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-21-2026-02-21-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-22-2026-02-22-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-23-2026-02-23-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-24-2026-02-24-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-25-2026-02-25-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-26-2026-02-26-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-27-2026-02-27-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'
union all
select * from [2026-02-28-2026-02-28-thunderbird-creator-answers-desktop-all-locales] where content like '%yahoo%'