Reporte de Tickets Filtrar

SELECT req.id_ticket, req.costo, req.servicio, req.referencia, req.nombre_area, req.acontecido as id_acontecido, req.solicitante, req.tel_solicitante, req.cliente as no_cliente, ti.tipo_requerimiento, ti.nombre_servicio, us.usuario, em.nombre, em.ap_paterno, em.ap_materno, req.descripcion_falla, req.status, req.fecha_solicitud, req.fecha_vencimiento, req.hora_solicitud, req.fecha_atencion, req.fecha_solucion, req.nombre_responsable, req.email_responsable, req.accion_solucion, ti.garantia, Cte.cliente, E.marca, concat(RFC.calleCliente,' No ' ,RFC.NExtCliente,' ', RFC.NInteriorCliente, ' ', RFC.ColoniaCliente, ' , ' ,RFC.MunicipioCliente ,' , ', RFC.EstadoCliente,' ', RFC.TelefonoCliente) as DirCliente, ae.acontecido, ta.nombre_area as area_responsable, 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 c_cliente AS Cte ON req.cliente=Cte.id_cliente LEFT JOIN c_empresa AS E ON req.empresa=E.id LEFT JOIN rfc_cliente AS RFC ON Cte.id_cliente=RFC.idcliente LEFT JOIN acontecido_en as ae ON ae.id=req.acontecido LEFT JOIN ticket_arearesp as ta ON ta.id=req.nombre_area GROUP BY req.id_ticket