Skip to content

Instantly share code, notes, and snippets.

#!/usr/bin/env sh
# autocmd BufWritePost * execute ":silent ! git-commit-file %"
FILE="$1"
test -e "$FILE" || exit
if [ "${FILE#/}" = "${FILE}" ]; then
FILE="./${FILE}"
fi
SELECT
me.title, rel_b.title, rel_b.obj, object.title, object.info
FROM
subject me
LEFT JOIN rel_a rel_a ON rel_a.title = me.title
LEFT JOIN object object ON object.title = rel_a.obj
LEFT JOIN rel_b rel_b ON rel_b.title = me.title
LEFT JOIN object object_2 ON object_2.title = rel_b.obj
ORDER BY rel_b.title