SELECT DISTINCT a.*,uc.name AS uEditor,`#__mentoring_schools_2746931`.`name` AS schools_fk_value_2746931,`#__mentoring_programs_2745182`.`name` AS programs_fk_value_2745182,CONCAT(`#__mentoring_users_2745183`.`first_name`, ' ', `#__mentoring_users_2745183`.`middle_name`, ' ', `#__mentoring_users_2745183`.`last_name`) AS users_fk_value_2745183,CONCAT(`#__mentoring_users_2745185`.`first_name`, ' ', `#__mentoring_users_2745185`.`middle_name`, ' ', `#__mentoring_users_2745185`.`last_name`) AS users_fk_value_2745185,CONCAT(`#__mentoring_users_2745184`.`first_name`, ' ', `#__mentoring_users_2745184`.`middle_name`, ' ', `#__mentoring_users_2745184`.`last_name`) AS users_fk_value_2745184
FROM `#__mentoring_teams` AS a
LEFT JOIN #__users AS uc ON uc.id=a.checked_out
LEFT JOIN #__mentoring_schools AS #__mentoring_schools_2746931 ON #__mentoring_schools_2746931.`id` = a.`school`
LEFT JOIN #__mentoring_programs AS #__mentoring_programs_2745182 ON #__mentoring_programs_2745182.`id` = a.`program`
LEFT JOIN #__mentoring_users AS #__mentoring_users_2745183 ON #__mentoring_users_2745183.`id` = a.`mentor`
LEFT JOIN #__mentoring_users AS #__mentoring_users_2745185 ON #__mentoring_users_2745185.`id` = a.`smentor`
LEFT JOIN #__mentoring_users AS #__mentoring_users_2745184 ON #__mentoring_users_2745184.`id` = a.`mentee`
LEFT JOIN #__users AS created_by ON created_by.id = a.created_by
LEFT JOIN #__users AS modified_by ON modified_by.id = a.modified_by
LEFT JOIN #__mentoring_companies AS mc ON mc.id = #__mentoring_users_2745183.company
WHERE a.state = 1
ORDER BY #__mentoring_programs_2745182.`id` desc,#__mentoring_programs_2745182.name DESC,#__mentoring_schools_2746931.name ASC,#__mentoring_users_2745183.last_name DESC
Participants
Our Schools
High School Participants in the Her Honor Program
We have partnered with a diverse group of high schools across Westchester, Rockland, and Bronx Counties, as well as Binghamton, NY, Burlington, NJ, and St. Louis, MO.
- Academy of Mount Saint Ursula
- Barack Obama School for Social Justice
- Binghamton High School
- Burlington City High School
- Cardinal Ritter College Preparatory High School
- Denzel Washington School of the Arts
- Earl Monroe High School
- Francis Howell High School
- Gorton High School
- Greenburgh-Graham UFSD
- Harrison High School
- Hazelwood East High School
- Lift for Life Academy
- Lincoln High School
- Mamaroneck High School
- Mount Vernon High School
- Mount Vernon STEAM Academy
- Nelson Mandela/Zollicoffer High School
- New Rochelle High School
- North Rockland High School
- Parkway North High School
- Port Chester High School
- Rye Neck High School
- Saunders High School
- Sleepy Hollow High School
- STEAM at McCluer South Berkeley
- University City High School
- Westminster Christian Academy
- White Plains High School
- Wings Academy High School