Still for fun, yet another one, via the [JSON1 extension](https://sqlite.org/json1.html#jeach), whose benefit is that one writes the p.id array only once (albeit as a string, requiring parsing): ``` sqlite> select p.* from p join json_each('[3,2,4]') a on p.id = a.value order by a.key; id other ---------- ---------- 3 three 2 two 4 four ```