SELECT D.*,B.id as course_id, Z.name as learning_mode, B.short_title, E.id as class_id, B.selling_price_inr,B.offered_price_inr,B.selling_price_usd,B.offered_price_usd,B.best_seller,C.name as course_title,E.event_date as c_event_date,E.start_time,E.end_time,F.name as t_language,G.first_name,G.last_name,G.profile_image,H.name as stream FROM course_title_codes B JOIN course_titles C ON C.id=B.course_title_id JOIN course_title_code_details D ON D.course_title_code_id=B.id JOIN course_title_classes E ON E.course_title_code_id=B.id JOIN course_learning_modes Z ON E.learning_mode_id=Z.id LEFT JOIN course_language_modes F ON F.id=B.course_language_mode_id LEFT JOIN user_personal_details G ON G.user_id=E.trainer_user_id JOIN course_streams H ON H.id=C.stream_id WHERE B.status='1' AND C.status='1' AND E.status='1' AND B.course_audience_id='1' AND B.learning_mode_id='3' and E.last_registration_date >='2026-04-25' and E.id='6900' ORDER BY C.id DESC
Cart