SELECT serreg, nivel_id, zonaescola, ct_id
FROM cambios_centro_trabajo
WHERE (
mid( ct_id, 3, 3 ) = 'EJN'
OR mid( ct_id, 3, 3 ) = 'DJN'
OR mid( ct_id, 3, 3 ) = 'PJN'
OR mid( ct_id, 3, 3 ) = 'DPR'
OR mid( ct_id, 3, 3 ) = 'EPR'
OR mid( ct_id, 3, 3 ) = 'PPR'
OR mid( ct_id, 3, 3 ) = 'DES'
OR mid( ct_id, 3, 3 ) = 'DST'
OR mid( ct_id, 3, 3 ) = 'DTV'
OR mid( ct_id, 3, 3 ) = 'EES'
OR mid( ct_id, 3, 3 ) = 'EST'
OR mid( ct_id, 3, 3 ) = 'ETV'
OR mid( ct_id, 3, 3 ) = 'PES'
OR mid( ct_id, 3, 3 ) = 'PST'
OR mid( ct_id, 3, 3 ) = 'PTV'
OR mid( ct_id, 3, 3 ) = 'SES'
)
AND (
status_ct_id = '1'
OR status_ct_id = '4'
)
ORDER BY serreg, nivel_id, zonaescola, ct_id