DELETE FROM tblemailtemplates_static WHERE type IN (
        'appointly',
        'contract',
        'credit_note',
        'gdpr',
        'project',
        'proposals',
        'subscriptions'
    );

DELETE FROM tblemailtemplates WHERE type IN (
        'appointly',
        'contract',
        'credit_note',
        'gdpr',
        'project',
        'proposals',
        'subscriptions'
    ) OR language != 'english';