Categories
Development

Return mixed non-series items + next upcoming in series

I’m looking for the best way to handle the following query. I have a table of items, some (but not all) of which are part of a series of items (one per day). The ones in a series are grouped by a shared series ID: Table “items”: id series_id (may be NULL) title date etc. […]