SELECT * from promotions where mfcr =4 and show = 0 and active = 1 and convert(datetime, expdt, 101) >='4/26/2025' and convert(datetime, expdt, 101) >='4/26/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))) and id=37620 ORDER BY display
Dentsply Sirona Preventive 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.
0 items
