SELECT id_product
                    FROM ps_product_lang
                    WHERE link_rewrite = 'bamboo-house-of-cheese-set' AND id_lang = 1 AND id_shop = 1