Problem sql show data

0

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?

    
asked by Oswuell 14.05.2018 в 23:44
source

0 answers