SELECT products.id FROM products INNER JOIN products_varriants ON products.id = products_varriants.pid WHERE products_varriants.pid = :id