I have the following sql where I show depending on the company what is causing me a problem that contractors technicians bring me
SELECT
e.idtickets,
e.empresa,
e.status,
e.tipo_ticket,
e.cierre_ticket,
t.idtickets,
t.asigno,
t.asignado,
u.idusuario AS idusuario,
u.nombre AS nombre_usuario,
count(t.asignado) AS todos
FROM tickets_asignado AS t
LEFT JOIN tickets AS e ON e.idtickets = t.idtickets
LEFT JOIN usuario AS u ON u.idusuario = t.asignado
WHERE ((e.empresa='3' AND e.tipo_ticket='Propios' AND e.idtickets=t.idtickets AND e.status = '4' AND e.cierre_ticket BETWEEN '2018-01-01' AND '2018-05-31')
OR
(e.empresa='3' AND e.tipo_ticket='Partner' AND e.idtickets=t.idtickets AND e.status = '4' AND e.cierre_ticket BETWEEN '2018-01-01' AND '2018-05-31'))
GROUP BY t.asignado
How do I remove what is shaded because I do not need to show them?