A Database Error Occurred

Error Number: 1054

Unknown column 'course_name' in 'order clause'

SELECT crs.crse_name, crs.crse_manager, c_cls.class_id, c_cls.course_id, c_cls.total_seats, c_cls.classroom_trainer, c_cls.class_name, c_cls.class_start_datetime, c_cls.class_end_datetime, c_cls.description, c_cls.classroom_venue_oth, c_cls.total_classroom_duration, c_cls.total_lab_duration, c_cls.assmnt_duration, c_cls.class_fees, c_cls.classroom_location, c_cls.lab_location, c_cls.class_language, c_cls.class_pymnt_enrol, c_cls.class_status, c_cls.training_aide FROM course_class c_cls JOIN course crs ON crs.course_id = c_cls.course_id and c_cls.tenant_id=crs.tenant_id WHERE crs.crse_status = 'ACTIVE' AND c_cls.class_status != 'INACTIV' AND crs.display_on_portal = '1' AND c_cls.display_class_public = '1' AND c_cls.tenant_id = 'T04' AND c_cls.class_start_datetime >= '2024-03-28 19:19:00' ORDER BY course_name DESC LIMIT 10

Filename: models/Course_public_model.php

Line Number: 5826