<entity name="branches"

				query="SELECT branch_pl, branch_en, SUBSTR(branch_code, 0, 3) AS branch_root;
				FROM catalogue.exhibitors_branches eb
				LEFT OUTER JOIN catalogue.branches b ON b.id = eb.branch_id where eb.order_id = '${offer.id}'"

				deltaImportQuery="SELECT branch_pl, SUBSTR(branch_code, 0, 3) AS branch_root;
				FROM catalogue.exhibitors_branches eb
				LEFT OUTER JOIN catalogue.branches b ON b.id = eb.branch_id where eb.order_id = '${offer.id}'">

			<field name="branch_pl" column="branch_pl" />

			<field name="branch_en" column="branch_en" />

			<field name="branch_root" column="branch_root />

		</entity>