SELECT * FROM tb_promotion WHERE promotion_ID='42'