SELECT id_product
                    FROM ps_product_lang
                    WHERE link_rewrite = 'blog' AND id_lang = 1 AND id_shop = 1