Retrieving ids with offset per customer

[Michał Kłoda]

Hello. First time here. I hope to get answer on my question.
I couldn't find answer on my question in google and I don't know is it possible to do. Let's say customer has many products and I would like to get all product ids with offset of 10.

E.g

customer_id | product_ids
1 | 2,3,4,5
2 |.8,1,2,3
...
or even better just get ids like 2,3,4,5,8,29,54
Why do I need this ids? Product with offset will be updated with specific status.

http://hastebin.com/kafibumolo.sql
This query doesn't work because I'm getting error 'subquery returns more than 1 row'