1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| SELECT
base.CallRef,
base.StartTime,
base.EndTime,
base.CustInfo,
base.UserQualif,
base.FirstServiceName,
base.FirstDistribServiceName,
base.FirstAgentName,
base.FirstAgentGroupName,
cool2.nombre,
id
FROM
base
inner join
(select
min(id) as ID, count(cool1.id) as nombre
from
(SELECT
CustInfo, Id
FROM
base
WHERE
StartTime between '2014-05-01 00:00:00'
AND '2014-06-01 00:00:00'
AND Direction = 'in'
AND Reason != 'planningclosed'
AND FirstAgentGroupId in ('11' , '20', '9', '10', '8', '7')) as cool1
group by CustInfo having nombre > 1) as cool2
USING (id)
order by nombre desc |
Partager