fixes mistake on promotion query