Eu tenho a tabela GetTicketNumbers
i UID TicketNumber
2 09901a22c7c3acc6786847c775f1d113 10
6 00dad28bef21f916240d6e8c1c1bd67d 5
12 00dad28bef21f916240d6e8c1c1bd67d 20
Preciso produzir 35 linhas (o UID também deve estar presente no resultado, pois esta é apenas uma tabela e esta tabela precisa ser unida na camada superior)
10 sequence number started from 1 (row i=2)
than next 5 sequence number (row i=6)
than next 20 sequence number (row i=12)
Preciso de algo assim, mas não concluo esta consulta
With RECURSIVE cte (i, UID, TicketNumbers) as
(
Select i, UID, TicketNumbers from GetTicketNumbers
union all
Select i + 1, UID, TicketNumbers from cte where ?????
) select * from cte order by i;
Eu uso MySQL.