CODE EXAMPLE FOR PHP

join cakphp

'joins' => array(
        array(
            'table' => Environment::read('table_prefix') . 'image_type_languages', 
            'alias' => 'language',
            'type' => 'INNER',
            'conditions'=> array(
                'ImageType.id = language.image_type_id',
                'language.alias = '' . $language . ''',
            )
        ),
    ),