compliance-alerts-email-15days

compliance-alerts-email-15days :

Query-1 (2 records):

SELECT
    `id`
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL
    AND `15_day_email_sent` IS NULL
    AND `compliance_alerts`.`deleted_at` IS NULL;

-------------------------------------------------------------------

Query-2 (2 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL
    AND `15_day_email_sent` IS NULL
    AND `compliance_alerts`.`deleted_at` IS NULL;

-------------------------------------------------------------------

Query-3 (2 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL;


-------------------------------------------------------------------

Query-4 (2 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `filing_status` IS NULL
    AND `15_day_email_sent` IS NULL;

-------------------------------------------------------------------

Query-5 (4 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `15_day_email_sent` IS NULL;

-------------------------------------------------------------------

Query-6 (4 records):

SELECT
    *
FROM
    `compliance_alerts`
WHERE
    due_date = '2021-12-24'
    AND `compliance_alerts`.`deleted_at` IS NULL;