SELECT id_product
                    FROM ps_product_lang
                    WHERE link_rewrite = 'zena-lip-balm-ball' AND id_lang = 1 AND id_shop = 1