SELECT form.id, form.nome, cur.nome AS curso, eve.nome AS evento_nome, CASE WHEN form.status = 1 THEN "A se Formar" WHEN form.status = 2 THEN "Formado" WHEN form.status = 3 THEN "Desistente" WHEN form.status = 4 THEN "Aguardando" END AS formando_status, form.contato, form.email FROM eventos_formando form LEFT OUTER JOIN cursos cur ON cur.id = form.curso_id LEFT OUTER JOIN eventos eve ON eve.id = form.evento_id WHERE form.curso_id IN ( SELECT id FROM cursos WHERE nome LIKE '%engenharia%' OR id IN (134, 86) )