SELECT discount_rate, campaign_name FROM campaigns WHERE product_id = 145   AND customer_group_id = 700 AND CURDATE() BETWEEN date_from AND date_to AND automatic = 1