This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env sh | |
# autocmd BufWritePost * execute ":silent ! git-commit-file %" | |
FILE="$1" | |
test -e "$FILE" || exit | |
if [ "${FILE#/}" = "${FILE}" ]; then | |
FILE="./${FILE}" | |
fi |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |