Report of Coupons

Overview

This document provides information about Report of Coupons.

Every month DeRose requires a report of coupons in CSV format

SELECT
 i.name AS publicacion,
 c.code AS cupon,
 u.email AS usuario
FROM
 issues AS i,
 users_plans AS up,
 users AS u,
 coupons AS c
WHERE
 i.tenant_id = 1117
 AND i.id = up.issue_id
 AND up.user_id = u.id
 AND up.coupon_id = c.id
 AND up.coupon_id IS NOT NULL
 AND up.created_at BETWEEN '2020-10-01 00:00:00' and '2021-02-28 23:59:59'

---