gistfile1.txt

; the query
(d/q '[:find ?price ?pt ?type
                            :in $ $shard ?cid ?type
                            :where
                            [$shard ?e :content/collection ?coll]
                            [$shard ?e :content/price_tier ?pt]
                            [$shard ?coll :collection/organization ?user]
                            [$ ?user :user/prices ?p]
                            [$ ?p :price/price ?price]
                            [$ ?p :price/type ?type]
                            [$ ?p :price/tier ?pt]]
                          _db _shard id usage)
                          
; the inputs
db1 db2 17592186045769 :print

; the result
[[600.0 2 :print], [400.0 1 :print], [800.0 3 :print]]