pomoc pri vytvoreni right join

Mam dve tabulky:
courses a courses_partners.

V courses su vlastnosti kurzov a v courses_partners je course_id(foreign key do courses) a partner_id(foreign key do partnerov). Mozete mi pomoct ako vykonat tento dotaz:
vybrat vsetky tie kurzy, ktorych pocet partnerov(pocet riadkov v courses_partners) je mensi ako courses.maxAmount(atribut v tabulke courses.) ?

Mam nieco taketo(ale neide to):

$this->database->query(„SELECT courses_partners.course_id, courses.title, courses.maxAmount FROM courses_partners RIGHT JOIN courses ON (courses_partners.course_id=courses.course_id) GROUP BY courses_partners.course_id HAVING COUNT(*) < courses.maxAmount“);