add misisng where clause to promotion list