select * FROM pt_affinities_products JOIN pt_products on prod_pk = affprod_prod_pk JOIN pt_products_modules on mod_pk = affprod_mod_pk where affprod_enabled = 'Y' and affprod_aff_pk ='528' and affprod_enabled_only_cc='N' and getdate()>=prod_valid_from and getdate()<=dateadd("d",1,prod_valid_to) and affprod_pk = 0