SELECT * FROM(
SELECT 1 AS id_tipo, 'Urgente' AS nombre
UNION
SELECT 2 AS id_tipo, 'Libre' AS nombre
UNION
SELECT 3 AS id_tipo, 'Medio' AS nombre
UNION
SELECT 4 AS id_tipo, 'Alto' AS nombre) AS tipos
WHERE 1
