Category "recursive-cte"

Crafting a Subquery-able UNION ALL based on the results of a query

Data I have a couple of tables like so: CREATE TABLE cycles ( `cycle` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cycle_type` varchar(140) COLLATE