'How to execute complex sql query in laravel 8 with eleqount orm

I have a query which can be executed in simple sql like this :

SELECT DISTINCT course_title, course_description, img FROM course_categories RIGHT JOIN course_lessions ON course_categories.id = course_lessions.course_category_id WHERE course_lessions.is_published =1 AND course_categories.is_published =1 ;

I am not able to execute this query in laravel 8 with eleqount. Does anyone know how to run complex queries in Laravel?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source