i need proper mysql query to fetch record from mysql : i have THREE tables.

Table : products  column : id, productname

Table :attribute_master column : id, attributename

Table : assignedproductfilter column :  id productid  <-- this is from products table filterid   <-- this is from attribute_master

table "assignedproductfilter" may contain same productid with multiple filterid.

Example :
id   productid   filterid
1   105        56
2   105        50
3   105        34
4   200        56
5   201        22

Now suppose i want to get all those products where filterid is 56,50 and 34. All these three filter id should be assigned to products.

How to write query for this in mysql ?