I used a sub select to get the data I want. I'm struggling to merge it all into one row now though.
This is an example of the result where its bike but there are loads on them:
bike bike null null bike 6 6 bike bike null null bike null null bike bike 2 2 bike null null
Any idea how I can merge or 'join', if you will, these rows together to act as one?
Output would ideally be
bike 2 2 6 6.
The large data output above is literally the output of the query I ran.