<table name="company">
    <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
    <column name="name" type="varchar" size="255" required="true"/>

    [...]

 </table>

<table name="verticalcain_company" isCrossRef="true">
    <column name="company_id" type="integer" primaryKey="true"/>
    <column name="verticalchainsubelement_id" type="integer" primaryKey="true"/>
    <foreign-key foreignTable="company" phpName="CompanyElement">
        <reference local="company_id" foreign="id" />
    </foreign-key>
    <foreign-key foreignTable="verticalchainsubelement" phpName="SubVerticalChainElement">
        <reference local="verticalchainsubelement_id" foreign="id" />
    </foreign-key>
</table>

<table name="verticalchain">
    <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
    <column name="name" type="varchar" size="128"/>
    <column name="sequence" type="integer"/>
</table>

<table name="verticalchainsubelement">
    <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
    <column name="name" type="varchar" size="128"/>
    <column name="verticalChain_id" type="integer"/>
    <foreign-key foreignTable="verticalchain" phpName="PartoOf">
        <reference local="verticalChain_id" foreign="id"/>
    </foreign-key>
</table>

$vc_sub = VerticalchainsubelementQuery::create()->findByName("Holding");
$vc = VerticalcainCompanyQuery::create()->filterBySubVerticalChainElement($vc_sub)->find();
$comp = CompanyQuery::create()->filterByVerticalcainCompany($vc)->find();