SELECT PK_wid, aut_id, aut_enable FROM ps_autoemail a WHERE a.aut_enable = 1 AND a.aut_email_1 IS NOT NULL AND a.PK_wid NOT IN(
            SELECT DISTINCT(el.eml_wid)
            FROM ps_email_log el
        WHERE el.eml_cycle = '{$cycle}' and el.eml_codtpl = '{$payslip_type}'
        );