Correct SQL query if the product is a promotion