Getting data with CActiveDataProvider in yii?

Question

Yii

There are 3 tables, a standard many-to-many relationship.
Users(id,...) -> Users_Has_Courses(Users_id, Courses_id) -> Courses(id,...)
Relationship in Courses model
'users' => array(self::MANY_MANY, 'Users', 'users_has_courses(Courses_id , Users_id)')
in the model Users
'courses' => array(self::MANY_MANY, 'Courses', 'users_has_courses(Users_id, Courses_id)'), Tell me
how to get a list of courses that the user with the specified id is not subscribed to, those. analogue of the usual query
select * from Courses where id not in (select Courses_id from users_has_courses where Users_id = 2)

Answer 1

If the subquery returns many records, then the following will be the fastest:

$courses = Courses::model()->findAllBySql(
"SELECT * FROM Courses WHERE id NOT IN (SELECT courses_id FROM users_has_courses WHERE users_id=:u)",
array(':u'=>2));

Answer 2

Thanks, I already did something like this:
$criteria = new CDbCriteria();
$criteria->addNotInCondition('id', $coursesIds);
$unsubscribedCourses = new CActiveDataProvider('Courses', array('criteria' => $criteria));