$options['joins'] = array(
                array('table' => 'ca_competence_language',
                        'alias' => 'CompetenceLanguage',
                        'type' => 'left',
                        'conditions' => array(
                                'Competence.com_id = CompetenceLanguage.com_id'
                        )
                )
        );

        $options['conditions'] = array(
                'OR' => array
                (
                'AND' => array ('Competence.com_id' => 114949, 'CompetenceLanguage.competence LIKE' => "% a%"),
                'AND' => array ('Competence.com_id' => 114950, 'CompetenceLanguage.competence LIKE' => "% %")
                )
        );
        $options['fields'] = array('Competence.com_id', 'CompetenceLanguage.competence');



// generated SQL is

// SELECT `Competence`.`com_id`, `CompetenceLanguage`.`competence` FROM `ca_competence` AS `Competence` left JOIN ca_competence_language AS `CompetenceLanguage` ON (`Competence`.`com_id` = `CompetenceLanguage`.`com_id`)  WHERE ((`Competence`.`com_id` = 114950) AND (`CompetenceLanguage`.`competence` LIKE '% %'))

// the expected SQL i am trying to get is

// SELECT `Competence`.`com_id`, `CompetenceLanguage`.`competence` FROM `ca_competence` AS `Competence` left JOIN ca_competence_language AS `CompetenceLanguage` ON (`Competence`.`com_id` = `CompetenceLanguage`.`com_id`)  WHERE (((`Competence`.`com_id` = 114950) AND (`CompetenceLanguage`.`competence` LIKE '% %')) OR ((`Competence`.`com_id` = 114951) AND (`CompetenceLanguage`.`competence` LIKE '% a%')))