gistfile1.txt

unknown column 'term.end_date' in 'where clause': SELECT `groups`.`id` AS t0_r0, `groups`.`course_id` AS t0_r1, `groups`.`term_id` AS t0_r2, `groups`.`created_at` AS t0_r3, `groups`.`updated_at` AS t0_r4, `terms`.`id` AS t1_r0, `terms`.`number` AS t1_r1, `terms`.`start_date` AS t1_r2, `terms`.`created_at` AS t1_r3, `terms`.`updated_at` AS t1_r4, `terms`.`end_date` AS t1_r5, `courses`.`id` AS t2_r0, `courses`.`course_type` AS t2_r1, `courses`.`course_name` AS t2_r2, `courses`.`date` AS t2_r3, `courses`.`created_at` AS t2_r4, `courses`.`updated_at` AS t2_r5, `courses`.`day` AS t2_r6, `courses`.`time` AS t2_r7 FROM `groups`  LEFT OUTER JOIN `terms` ON `terms`.id = `groups`.term_id  LEFT OUTER JOIN `groups` courses_terms_join ON (`terms`.`id` = `courses_terms_join`.`term_id`)  LEFT OUTER JOIN `courses` ON (`courses`.`id` = `courses_terms_join`.`course_id`) WHERE (term.end_date >= '2010-06-29 00:00:00')