fixed this issue http://stackoverflow.com/questions/20363043/web2py-dal-left-join-and-operator-precedence