Technologist in Chemistry C (ASCP) Certification

Any--<-->==chem--Select `wp_mts_sb_school_data`.*, `wp_mts_sb_program_details`.* FROM `wp_mts_sb_school_data` JOIN `wp_mts_sb_program_details` ON `wp_mts_sb_school_data`.s_id = `wp_mts_sb_program_details`.s_id WHERE (`wp_mts_sb_program_details`.p_current_degrees = 'hsd' OR `wp_mts_sb_program_details`.p_current_degrees like '%,hsd,%' OR `wp_mts_sb_program_details`.p_current_degrees like 'hsd,%' OR `wp_mts_sb_program_details`.p_current_degrees like '%,hsd' OR`wp_mts_sb_program_details`.p_current_degrees = 'bach' OR `wp_mts_sb_program_details`.p_current_degrees like '%,bach,%' OR `wp_mts_sb_program_details`.p_current_degrees like 'bach,%' OR `wp_mts_sb_program_details`.p_current_degrees like '%,bach') AND ( `wp_mts_sb_program_details`.p_concentration_name = 'chem' OR `wp_mts_sb_program_details`.p_concentration_name like '%,chem,%' OR `wp_mts_sb_program_details`.p_concentration_name like 'chem,%' OR `wp_mts_sb_program_details`.p_concentration_name like '%,chem' ) AND `wp_mts_sb_school_data`.s_active = 'Yes'AND `wp_mts_sb_program_details`.p_active = 'yes' ORDER BY CASE `wp_mts_sb_school_data`.s_id WHEN 33 THEN 1 WHEN 34 THEN 2 WHEN 35 THEN 3 WHEN 36 THEN 4 WHEN 37 THEN 5 WHEN 38 THEN 6 WHEN 39 THEN 7 WHEN 40 THEN 8 WHEN 41 THEN 9 WHEN 54 THEN 10 WHEN 26 THEN 11 WHEN 55 THEN 12 WHEN 48 THEN 13 WHEN 6 THEN 14 WHEN 87 THEN 15 WHEN 85 THEN 16 WHEN 16 THEN 17 WHEN 13 THEN 18 WHEN 12 THEN 19 WHEN 50 THEN 20 WHEN 77 THEN 21 WHEN 27 THEN 22 WHEN 32 THEN 23 WHEN 90 THEN 24 WHEN 1 THEN 25 WHEN 31 THEN 26 WHEN 62 THEN 27 WHEN 9 THEN 28 WHEN 53 THEN 29 WHEN 86 THEN 30 WHEN 76 THEN 31 WHEN 60 THEN 32 WHEN 69 THEN 33 WHEN 88 THEN 34 WHEN 89 THEN 35 WHEN 81 THEN 36 WHEN 64 THEN 37 WHEN 84 THEN 38 WHEN 30 THEN 39 WHEN 82 THEN 40 WHEN 72 THEN 41 WHEN 83 THEN 42 WHEN 67 THEN 43 WHEN 61 THEN 44 WHEN 65 THEN 45 WHEN 8 THEN 46 WHEN 75 THEN 47 WHEN 14 THEN 48 WHEN 7 THEN 49 WHEN 28 THEN 50 WHEN 80 THEN 51 WHEN 66 THEN 52 WHEN 57 THEN 53 WHEN 79 THEN 54 WHEN 59 THEN 55 WHEN 68 THEN 56 WHEN 63 THEN 57 WHEN 70 THEN 58 WHEN 43 THEN 59 WHEN 71 THEN 60 WHEN 44 THEN 61 WHEN 73 THEN 62 WHEN 45 THEN 63 WHEN 58 THEN 64 WHEN 29 THEN 65 WHEN 56 THEN 66 WHEN 51 THEN 67 WHEN 3 THEN 68 WHEN 5 THEN 69 WHEN 4 THEN 70 WHEN 42 THEN 71 WHEN 74 THEN 72 WHEN 10 THEN 73 WHEN 15 THEN 74 WHEN 17 THEN 75 WHEN 18 THEN 76 WHEN 19 THEN 77 WHEN 49 THEN 78 WHEN 2 THEN 79 WHEN 20 THEN 80 WHEN 21 THEN 81 WHEN 22 THEN 82 WHEN 23 THEN 83 WHEN 24 THEN 84 WHEN 25 THEN 85 WHEN 11 THEN 86 WHEN 78 THEN 87 WHEN 47 THEN 88 WHEN 52 THEN 89 WHEN 46 THEN 90 ELSE 99 END ASC, `wp_mts_sb_program_details`.p_name