gistfile1.php

            $results = $arosAcos->find('all',array(
                'fields' => array('Acos.foreign_key'),
                'conditions' => array(
                    'Aros.alias' => "clients/{$user['client_id']}/{$user['id']}",
                    'Acos.alias LIKE' => "campaigns/%"
                ),
                'joins' => array(
                    array(
                        'type' => 'left',
                        'table' => 'acos',
                        'alias' => 'Acos',
                        'conditions' => 'ArosAco.aco_id = Acos.id'
                    ),
                    array(
                        'type' => 'left',
                        'table' => 'aros',
                        'alias' => 'Aros',
                        'conditions' => 'ArosAco.aro_id = Aros.id'
                    )
                )
            ));