<entity name="products_product"
        query="SELECT id, merchant_id, product_id, retail_price, date_created FROM products_product"
        transformer="script:generate_resource_uri">


    <entity name="merchant"
            query="SELECT merchant_name, commission, commission_type FROM products_merchant"
            cacheKey='id' cacheLookup='products_product.merchant_id'
             cacheImpl="SortedMapBackedCache">
            <!-- where="id=products_product.merchant_id"> -->
        <field column="merchant_name" name="merchant_name"/>
        <field column="commission" name="commission"/>
        <field column="commission_type" name="commission_type"/>
    </entity>
</entity>