~[wc:commonscripts] "Student Id","Last Name","First Name","Type","Address","City","State","Zip","Home Phone","Work Phone","Cell Phone","Email" ~[TLIST_SQL; SELECT REPLACE(s.student_number, '"', '""'), REPLACE(u.parent1_last_name, '"', '""'), REPLACE(u.parent1_first_name, '"', '""'), REPLACE('1', '"', '""'), REPLACE(s.mailing_street, '"', '""'), REPLACE(s.mailing_city, '"', '""'), REPLACE(s.mailing_state, '"', '""'), REPLACE(s.mailing_zip, '"', '""'), REPLACE(u.parent1_home_phone, '"', '""'), REPLACE(u.parent1_work_phone, '"', '""'), REPLACE(u.parent1_cell_phone, '"', '""'), REPLACE(u.parent1_email, '"', '""') FROM students s, u_studentsuserfields u WHERE s.student_number IS NOT NULL AND s.dcid = u.studentsdcid AND u.parent1_last_name IS NOT NULL ]"~(1;T)","~(2;T)","~(3;T)","~(4;T)","~(5;T)","~(6;T)","~(7;T)","~(8;T)","~(9;T)","~(10;T)","~(11;T)","~(12;T)" [/TLIST_SQL]~[TLIST_SQL; SELECT REPLACE(s.student_number, '"', '""'), REPLACE(u.parent2_last_name, '"', '""'), REPLACE(u.parent2_first_name, '"', '""'), REPLACE('2', '"', '""'), REPLACE(u.mailing_street_2, '"', '""'), REPLACE(u.mailing_city_2, '"', '""'), REPLACE(u.mailing_state_2, '"', '""'), REPLACE(u.mailing_zip_2, '"', '""'), REPLACE(u.parent2_home_phone, '"', '""'), REPLACE(u.parent2_work_phone, '"', '""'), REPLACE(u.parent2_cell_phone, '"', '""'), REPLACE(u.parent2_email, '"', '""') FROM students s, u_studentsuserfields u WHERE s.student_number IS NOT NULL AND s.dcid = u.studentsdcid AND u.parent2_last_name IS NOT NULL ]"~(1;T)","~(2;T)","~(3;T)","~(4;T)","~(5;T)","~(6;T)","~(7;T)","~(8;T)","~(9;T)","~(10;T)","~(11;T)","~(12;T)" [/TLIST_SQL]