Seguimiento de Servicio Seguimiento

SELECT req.id_ticket, req.id_tipo_ticket, req.acontecido as id_acontecido, req.nombre_area, req.solicitante, req.email_solicitante, req.tel_solicitante, req.empresa_solicitante, us.usuario, req.empresa, req.cliente, req.servicio, req.referencia, req.costo, us.id, em.nombre, em.ap_paterno, em.ap_materno, em.id_oficina, req.descripcion_falla, req.status, req.proveedor, req.fecha_solicitud, req.hora_solicitud, req.fecha_atencion, req.fecha_compromiso, req.fecha_solucion, req.responsable, req.status, req.accion_solucion, ti.nombre_servicio, ti.tipo_requerimiento, req.id_autorizante, ae.acontecido , ta.nombre_area as area_responsable, r.tipo_requerimiento as nombre_requerimiento FROM c_tickets AS req LEFT JOIN usuarios AS us ON us.id=req.id_user_solicitante LEFT JOIN empleados AS em ON em.id_empleado=req.id_autorizante LEFT JOIN c_tipo_tickets AS ti ON ti.id=req.id_tipo_ticket LEFT JOIN requerimiento as r ON r.id=ti.tipo_requerimiento LEFT JOIN acontecido_en as ae ON ae.id=req.acontecido LEFT JOIN ticket_arearesp as ta ON ta.id=req.nombre_area WHERE req.id_ticket = ''