What is the best way to make this query

I three have tables

Products table id title e.tc

sub_category table id prodouct_id e.tc

collections table here i save all products that will go live under a subcategory

id product_id subcategory_id

i want query that will pull all products under a subcategory form the collections table.

Thanks guys.

via Chebli Mohamed