select `mst_batches`.`id`, `name`, `course_name`, `description`, `start_from`, `end_at`, `starting_time`, `ending_time` from `mst_batches` inner join `course_centres` on `course_centres`.`id` = `mst_batches`.`course_id` inner join `lms_courses` on `lms_courses`.`id` = `mst_batches`.`course_id` where (`mst_batches`.`vendor_id` = ? and `mst_batches`.`centre_id` = ? and `mst_batches`.`status` = ?) and date(`mst_batches`.`start_from`) >= ?