gistfile1.xml

<dataConfig>
  <dataSource encoding="UTF-8" driver="com.mysql.jdbc.Driver"/>
    <document name="solrIndex">
      
        <entity name="artist" query="select id, name, stats_total, stats_popindex from artist where namevariation_id is null and deleted = 0" >
            <field column="id" name="id_i" />
            <field column="name" name="name_t" />
            <entity name="recording" query="select recording_id from recording_artist where artist_id=${artist.id}">
              <field column="recording_id" name="recs_i" />
            </entity>
        </entity>
        <entity name="brand" query="select id, title, type from brand where deleted = 0" >
            <field column="id" name="id_i" />
            <field column="title" name="title_t" />
            <entity name="recording" query="select recording_id from recording_artist where artist_id in (select artist_id from brand_artist where brand_id=${brand.id})">
              <field column="recording_id" name="recs_i" />
            </entity>            
        </entity>
        
    </document>
</dataConfig>