{% for hl in rows %} {% set book = sql("SELECT * FROM book where id = :book_id", { "book_id": hl.book_id })[0] %} {% if hl.note != None %} {% else %} {% endif %} {% endfor %}

Cover	Book Title	Highlight	Note
	{{ book.title }}	{{ hl.text }}	{{ hl.note}}