All pastes #382720 Raw Edit

Anonymous

public sql v1 · immutable
·published 2007-03-05 21:21 UTC
rendered paste body
SELECT t.teacherID, CONCAT(t.firstName,' ',t.lastName) fullName FROM teachers t, teachers_booking tb, guests_booking gb WHERE t.teacherID=tb.teacherID AND t.teacherID!='". $responsibleTeacherID ."' AND tb.teacherBookingID=gb.teacherBookingID AND (gb.fromDate BETWEEN '". $arrayWeekDates[0] ."' AND '". $arrayWeekDates[6] ."') AND (gb.tilDate BETWEEN '". $arrayWeekDates[0] ."' AND '". $arrayWeekDates[6] ."') GROUP BY t.teacherID ORDER BY fullNameSELECT t.teacherID, CONCAT(t.firstName,' ',t.lastName) fullName FROM teachers t, pass_teachers_new tb, guests_booking gb WHERE t.teacherID=tb.teacherId AND t.teacherID!='". $responsibleTeacherID ."' AND (gb.fromDate BETWEEN '". $arrayWeekDates[0] ."' AND '".$arrayWeekDates[6] ."') AND (gb.tilDate BETWEEN '". $arrayWeekDates[0] ."' AND '". $arrayWeekDates[6] ."') GROUP BY t.teacherID ORDER BY fullName