select ss.*,concat(ms.first_name,' ',ms.middle_name,' ',ms.last_name) as name from stud_standard ss,mast_students ms where ms.id=ss.student_id and ss.standard_id=:sid and ss.division_id=:did and ss.year=:yr and ss.roll_no!='0' and ms.last_name=:lname and left_on_date <'2000-01-01' and (isnull(ms.new_stud_id) || ms.new_stud_id =0)   order by ss.roll_no