Create collection and query SQL

Hi!

I searched a lot and could not find how to create a collection within a list and use the collection to do an IN in the query in my summary.Here in Brazil we not have a large community...

I'm doing a pagination in my query for show someone products in each page.

Thanks!!