fixed the inner joins to be left outer joins for ordercoupons