SELECT * FROM tb_promotion WHERE promotion_ID='47'