SELECT * from promotions where mfcr =282 and show = 0 and active = 1 and convert(datetime, expdt, 101) >='5/3/2025' and convert(datetime, expdt, 101) >='5/3/2025' and id in(select promo_id from product_promo where pid in(select pid from product where pid in(select prodid from item where active=1 and mfg is not NULL))) ORDER BY display
Ansell/Perry Qurterly Promotions | Pearson Dental
This website uses cookies to ensure you get the best experience on our website. By continuing to browse the site, you agree to our use of cookies. More Info.