1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| SELECT DISTINCT trk.TrkTypeID,
trk.TrkID as TrkID,
tst.TrkStatusTypeID,
jb.StatusTypeID,
trk.JobID as Job,
jb.StartDate as Date_Création,
CASE WHEN trkt.LabelID IS NULL THEN trkt.Alias ELSE trklabel.Fr END as Document,
CASE WHEN tstlabel.LabelID IS NULL THEN tst.Alias ELSE tstlabel.Fr END as Statut
FROM tracking trk FORCE INDEX ( IDX_EnvID_TrkTypeID_JobID )
INNER JOIN TrackingStatusType as tst on tst.TrkStatusTypeID = trk.TrkStatusTypeID
INNER JOIN Job as jb on trk.JobID = jb.JobID
INNER JOIN trackingtype as trkt on trkt.TrkTypeID = trk.TrkTypeID
LEFT JOIN label as tstlabel on tstlabel.LabelID = tst.LabelID
LEFT JOIN label as trklabel on trklabel.labelID = trkt.labelID
INNER JOIN TrackingEnv as trkenv on trk.TrkID = trkenv.TrkID
WHERE trkenv.EnvID IN ( 1,40,41,22,21,23,24,37,25,26,32,31,36,30,34,20,27,35,29,28,43,33,45,47,46,50,62,52,54,57,56,59,60,58,61,39,38,48,44,49,42,51 )
AND trk.TrkTypeID IN ( 2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,47,48 )
Order BY trk.JobID DESC LIMIT 20
; |
Partager