7105   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7105'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7105'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7105'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7105'] ~(Choice3;i)[/tlist_sql]   CloseUp (8/16) 7110   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7110'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7110'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7110'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7110'] ~(Choice3;i)[/tlist_sql]   Songwriting 101 (10/20) 7115   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7115'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7115'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7115'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7115'] ~(Choice3;i)[/tlist_sql]   Walden West Camp (8/8) 7120   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7120'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7120'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7120'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7120'] ~(Choice3;i)[/tlist_sql]   Visual Effects (8/16) 7125   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7125'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7125'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7125'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7125'] ~(Choice3;i)[/tlist_sql]   Vandu Paaru India (12) 7128   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7128'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7128'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7128'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7128'] ~(Choice3;i)[/tlist_sql]   Culinary School (20/24) 7130   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7130'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7130'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7130'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7130'] ~(Choice3;i)[/tlist_sql]   Home Improvement (8/16) 7135   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7135'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7135'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7135'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7135'] ~(Choice3;i)[/tlist_sql]   Web Design (8/16) 7140   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7140'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7140'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7140'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7140'] ~(Choice3;i)[/tlist_sql]   Costa Rica (6/16) 7145   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7145'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7145'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7145'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7145'] ~(Choice3;i)[/tlist_sql]   Scuba Diving (6/8) 7150   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7150'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7150'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7150'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7150'] ~(Choice3;i)[/tlist_sql]   Leisure Recreation (8/24) 7155   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7155'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7155'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7155'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7155'] ~(Choice3;i)[/tlist_sql]   Skiing & Service (8/18) 7160   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7160'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7160'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7160'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7160'] ~(Choice3;i)[/tlist_sql]   Window Art (6/10) 7170   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7170'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7170'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7170'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7170'] ~(Choice3;i)[/tlist_sql]   New Orleans (12) 7173   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7173'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7173'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7173'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7173'] ~(Choice3;i)[/tlist_sql]   Yosemite Institute (8/12) 7180   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7180'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7180'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7180'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7180'] ~(Choice3;i)[/tlist_sql]   The Real World (8/16) 7185   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7185'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7185'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7185'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7185'] ~(Choice3;i)[/tlist_sql]   Death Valley (8/12) 7195   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7195'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7195'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7195'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7195'] ~(Choice3;i)[/tlist_sql]   College Recruiting (8/16) 7200   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7200'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7200'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7200'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7200'] ~(Choice3;i)[/tlist_sql]   Blackfeet Reservation (10) 7220   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7220'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7220'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7220'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7220'] ~(Choice3;i)[/tlist_sql]   El Salvador 7240   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7240'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7240'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7240'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7240'] ~(Choice3;i)[/tlist_sql]   Hockey Experience (8/16) 7250   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7250'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7250'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7250'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7250'] ~(Choice3;i)[/tlist_sql]   Hip Hop (8/16) 7255   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7255'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7255'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7255'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7255'] ~(Choice3;i)[/tlist_sql]   Stained Glass Art (6/10) 7260   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7260'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7260'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7260'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7260'] ~(Choice3;i)[/tlist_sql]   Golf (8/14) 7275   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7275'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7275'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7275'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7275'] ~(Choice3;i)[/tlist_sql]   Capoeira (8/16) 7277   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7277'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7277'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7277'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7277'] ~(Choice3;i)[/tlist_sql]   Driver Education (30/40) 7290   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7290'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7290'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7290'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7290'] ~(Choice3;i)[/tlist_sql]   Career in Athletics (8/16) 7300   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7300'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7300'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7300'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7300'] ~(Choice3;i)[/tlist_sql]   Style and Soph. (30/32) 7310   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7310'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7310'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7310'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7310'] ~(Choice3;i)[/tlist_sql]   Paris, France (8/12) 7320   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7320'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7320'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7320'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7320'] ~(Choice3;i)[/tlist_sql]   Circus Fun (8/20) 7332   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7332'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7332'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7332'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7332'] ~(Choice3;i)[/tlist_sql]   IIP 7335   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7335'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7335'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7335'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7335'] ~(Choice3;i)[/tlist_sql]   Streets of SF (8/16) 7340   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7340'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7340'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7340'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7340'] ~(Choice3;i)[/tlist_sql]   Figurative Sculpture (8/15) 7345   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7345'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7345'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7345'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7345'] ~(Choice3;i)[/tlist_sql]   Skateboard (8/16) 7350   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7350'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7350'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7350'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7350'] ~(Choice3;i)[/tlist_sql]   Venaver - East Bay (8/16) 7355   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7355'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7355'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7355'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7355'] ~(Choice3;i)[/tlist_sql]   Culture - Bay Area (8/16) 7360   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7360'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7360'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7360'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7360'] ~(Choice3;i)[/tlist_sql]   New Horizons (8/8) 7365   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7365'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7365'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7365'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7365'] ~(Choice3;i)[/tlist_sql]   Culinary School (12/16) 7370   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7370'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7370'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7370'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7370'] ~(Choice3;i)[/tlist_sql]   American Movies (5/20) 7375   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7375'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7375'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7375'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7375'] ~(Choice3;i)[/tlist_sql]   Joy of Eating (8/16) 7380   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7380'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7380'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7380'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7380'] ~(Choice3;i)[/tlist_sql]   Video and Film (8/16) 7385   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7385'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7385'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7385'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7385'] ~(Choice3;i)[/tlist_sql]   Mural Painting (6/16) 7390   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7390'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7390'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7390'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7390'] ~(Choice3;i)[/tlist_sql]   Pilates (5/12) 7420   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7420'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7420'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7420'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7420'] ~(Choice3;i)[/tlist_sql]   New York City (8/16) 7423   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7423'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7423'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7423'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7423'] ~(Choice3;i)[/tlist_sql]   SAT Prep (6/18) 7425   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7425'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7425'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7425'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7425'] ~(Choice3;i)[/tlist_sql]   Extreme Sports (8/16) 7450   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7450'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7450'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7450'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7450'] ~(Choice3;i)[/tlist_sql]   Caritas Creek (8/20) 7460   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7460'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7460'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7460'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7460'] ~(Choice3;i)[/tlist_sql]   Giant Killer Robots (8/20) 7465   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Number_Current')) as NumCur FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Number_Current') = '7465'] ~(NumCur;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice1')) as Choice1 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7465'] ~(Choice1;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice2')) as Choice2 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7465'] ~(Choice2;i)[/tlist_sql]   ~[tlist_sql; SELECT COUNT(ps_customfields.getStudentscf(id,'Eweek_Choice3')) as Choice3 FROM Students WHERE Enroll_Status=0 AND ps_customfields.getStudentscf(id,'Eweek_Choice1') = '7465'] ~(Choice3;i)[/tlist_sql]   Biking (6/16)