TRUNCATE TABLE [ST-TJMT].Proteus.Processos_Meta_4;

DECLARE @DataMaximaDistribuicao DATE = '2013-12-31';
DECLARE @ClassesMeta4 TABLE (IDCLASSE INT);
DECLARE @AssuntosMeta4 TABLE (IDASSUNTO INT);

INSERT INTO @ClassesMeta4 VALUES
(64),(198),(202),(208),(199),(1728),(1208),(213),(1689),(211),(216),(218),
(221),(1230),(1232),(1231),(228),(230),(231),(1702),(232),(233),(236),(457),
(283),(10943),(10944),(11037),(317),(328),(326),(327),(1715),(1178),(11787),
(325),(432),(11788),(11789),(11790),(332),(432),(11788),(11789),(11790),(332),
(433),(333),(417),(427),(421),(420),(11038),(307),(1710),(11035),(11036),(420);

INSERT INTO @AssuntosMeta4 VALUES
(10012),(10013),(10014),(3580),(3577),(3576),(3595),(3585),(11797),(3593),(3579),(3582),(3589),(3592),(3594),
(3535),(11006),(10007),(3533),(10995),(3536),(3531),(10998),(3529),(11005),(3530),(3541),(3531),(3524),(3545),
(10993),(3527),(10994),(3540),(3539),(5905),(5909),(5903),(10991),(5904),(10990),(590),(5910),(5906),(907),(3430),
(5571),(3432),(10982),(3561),(3559),(3553),(3558),(3555),(3552),(3554),(3562),(3551),(3556),(3596),(3597),(3548),
(3550),(3557),(3564),(3563),(3560),(10983),(3574),(3568),(3569),(3570),(3598),(3571),(3567),(3565),(10984),(5876),
(5877),(3651),(3614),(10985),(10986),(3612),(3642),(3628),(3606),(3604),(3650),(11072),(11073),(11167),(11166),(11152);

INSERT INTO [ST-TJMT].Proteus.Processos_Meta_4 ( NumeroProtocolo, AnoProtocolo, IDMagistrado, IDCamara, IDClasseFeito, NumeroUnico, IDUltimaOcorrencia )
SELECT P.nmrprtc, P.anoprtc, PR.DSMRLT, PR.CMRFTO, PR.CLSFTO, P.NumeroUnico,
  (SELECT TOP 1 O.Sequencia FROM [ST-TJMT].Proteus.Ocorrencia O WHERE O.anoprt = P.anoprtc AND O.numprt = P.nmrprtc ORDER BY O.dtaand DESC, O.dtdigp DESC)
FROM [ST-TJMT].Proteus.Protocolo P
  INNER JOIN [ST-TJMT].Proteus.Processo PR ON P.anoprtc = PR.ANOPRTC AND P.nmrprtc = PR.NUMPRTC
  INNER JOIN [ST-TJMT].Proteus.Tipo_Classe_Feito TCF ON TCF.TPOFTO = 5 AND TCF.CLSFTO = PR.CLSFTO
  INNER JOIN [ST-TJMT].Proteus.Camara C ON C.IDCamara = PR.CMRFTO
  INNER JOIN [ST-TJMT].Proteus.Magistrado M ON M.IDMagistrado = PR.DSMRLT
  INNER JOIN [ST-TJMT].Proteus.TituloMagistrado TM ON M.IDTituloMagistrado = TM.IDTituloMagistrado
WHERE PR.DTAULTDST <= @DataMaximaDistribuicao
  AND PR.TPOFTO= 5
  AND (P.dscprtc LIKE '%IMPROBIDADE ADMINISTRATIVA%'
    --Qualquer classe
    OR PR.CLSFTO in (SELECT IDCLASSE FROM @ClassesMeta4) )
    --Qualquer assunto
    AND EXISTS ( SELECT NULL FROM [ST-TJMT].Proteus.AssuntoProcesso AP
       WHERE AP.Ano = PR.ANOPRTC
         AND AP.Numero = PR.NUMPRTC
         AND AP.Instancia= 2
         AND AP.seq_Assunto IN (SELECT IDASSUNTO FROM @AssuntosMeta4)
        )