-----
(select
  (columns
    (col edges
         label
         edge-from-node-id
         edge-from-seqno
         edge-to-node-id
         edge-to-seqno
         created
         created-by-node-id
         created-by-seqno
         deleted
         deleted-by-node-id
         deleted-by-seqno)
    (col objects
         name
         type
         description
         node-id
         seqno
         version-ts
         version-node-id
         created
         last-modified
         created-by-node-id
         created-by-seqno
         last-modified-by-node-id
         last-modified-by-seqno))
  (from (join inner
              objects
              edges
              (on (and (= (col edges edge-to-node-id) (col objects node-id))
                       (= (col edges edge-to-seqno) (col objects seqno))))))
  (where (= (col edges deleted) 0))
  (order (col objects last-modified)))
-----

Constriant:

(and (= (col edges label) "member-in")
     (= (col edges edge-from-node-id) 5)
     (= (col edges edge-from-seqno) 1594)
     (= (col edges edge-to-node-id) 1)
     (= (col edges edge-to-seqno) 3))

(scope-table 'objects constraint q)

-----
(select
  (columns
    (col edges
         label
         edge-from-node-id
         edge-from-seqno
         edge-to-node-id
         edge-to-seqno
         created
         created-by-node-id
         created-by-seqno
         deleted
         deleted-by-node-id
         deleted-by-seqno)
    (col objects
         name
         type
         description
         node-id
         seqno
         version-ts
         version-node-id
         created
         last-modified
         created-by-node-id
         created-by-seqno
         last-modified-by-node-id
         last-modified-by-seqno))
  (from (join inner
              objects
              edges
              (on (and (= (col edges edge-to-node-id) (col objects node-id))
                       (= (col edges edge-to-seqno) (col objects seqno))))))
  (where (and (and (= (col edges label) "member-in")
                   (= (col edges edge-from-node-id) 5)
                   (= (col edges edge-from-seqno) 1594)
                   (= (col edges edge-to-node-id) 1)
                   (= (col edges edge-to-seqno) 3))
              ((= (col edges deleted) 0))))
  (order (col objects last-modified)))
-----