{% for row in sql("select * from dss_job WHERE crawl_id = ? AND finished_at IS NULL", [dss_id], database=database) %}

Job #{{row['id']}} ({{row['status']}})

Pending: {{ "{:,}".format(sql('select count(*) FROM dss_crawl_queue WHERE job_id = ?', [row['id']])[0][0]) }} Crawled: {{ "{:,}".format(sql('select count(*) FROM dss_crawl_queue_history WHERE job_id = ?', [row['id']])[0][0]) }}
{% else %}

No job currently running {% for row in sql("select id from dss_job where crawl_id = ? order by id desc limit 1", [dss_id], database=database) %} (previous job #{{row['id']}}) {% endfor %}

{% endfor %}