@cronjobs.register
def unconfirmed():
    log.debug("Removing user accounts that haven't been confirmed "
              "for two weeks...")
    cursor = connection.cursor()
    cursor.execute("""
        DELETE users
        FROM users
        LEFT JOIN addons_users on users.id = addons_users.user_id
        LEFT JOIN addons_collections ON users.id=addons_collections.user_id
        LEFT JOIN collections_users ON users.id=collections_users.user_id
        WHERE users.created < DATE_SUB(CURDATE(), INTERVAL 2 WEEK)
        AND users.confirmationcode != ''
        AND addons_users.user_id IS NULL
        AND addons_collections.user_id IS NULL
        AND collections_users.user_id IS NULL
    """)
Make a ZIP file
dataset/ETHPy150Open mozilla/addons-server/src/olympia/amo/cron.py/unconfirmed--crossover with--dataset/ETHPy150Open jakev/dtf/src/dtf/core/cmds/archive.py/archive.make_zip