<dataConfig>
    <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://path" user="user" password="pwd" />
    <document name="offers">
       <entity name="offers"
                 query="SELECT o.* FROM offers o inner join offer_group g on o.offer_group_id = g.id where g.status = 0"
                 deltaQuery="select id from offers where updated_at > '${dataimporter.last_index_time}'">

          <field column="id" name="id" />
          <field column="product_code" name="product_code" />
          <field column="gender" name="gender" />
          <field column="colors" name="colors" />
          <field column="year" name="year" />
          <field column="tags" name="tags" />
          <field column="size" name="size" />
          <field column="size_typology" name="size_typology" />
          <field column="season" name="season" />
          <field column="quantity" name="quantity" />
          <field column="price" name="price" />
          <field column="typology" name="typology" />
          <field column="model" name="model" />

          <entity name="brands"
                    query="select name from brands where id='${offers.brand_id}'"
                    deltaQuery="select id from brands where updated_at > '${dataimporter.last_index_time}'" >
               <field name="brand_name" column="name" />
          </entity>

          <entity name="materials"
                    query="select name from materials where id='${offers.type_material}' OR '${offers.type_material}' = NULL">
                <field name="material_name" column="name" />
          </entity>

          <entity name="offer_group"
                    query="select shop_id from offer_group where id='${offers.offer_group_id}'"
                    deltaQuery="select id from offer_group where updated_at > '${dataimporter.last_index_time}'" >
               <field name="shop_id" column="shop_id" />
          </entity>

       </entity>
    </document>
</dataConfig>