<?php
$dbDataBase               = new IDataBase;
$dbDataBase->Name         = "dbDataBase ";
$dbDataBase->DataBaseName = 'dbTeste';
$dbDataBase->Driver       = 'MySql';
$dbDataBase->Host         = HOST;
$dbDataBase->User         = USER
$dbDataBase->Password     = SENHA;
$dbDataBase->Connect();

$qrShadow           = new IQuery;
$qrShadow->Name     = 'qrShadow';
$qrShadow->DataBase = &$dbDataBase;
$qrShadow->Sql->Clear();
$stmt = "SELECT
            CONVERT(char(12),h.dtRecebimentoForum,103 ) as dtRecebimentoForum,
            devolvido = ( SELECT
                              nuProcesso
                          FROM
                              processo
                          WHERE
                              nuProcesso NOT IN (SELECT nuProcesso FROM historico_processo) AND
                              nuProcesso = :nuProcesso and
                              stForo     = :stForo)
         FROM
            historico_processo h  
         RIGHT OUTER JOIN 
            Processo p
         ON
            p.nuProcesso = h.nuProcesso and
            p.stForo     = h.stForo
         WHERE
            p.nuProcesso = :nuProcesso and
            p.stForo     = :stForo";
$qrShadow->Sql->Add($stmt);
$qrShadow->ParamByName('nuProcesso',$EdNuProcesso,'%d');
$qrShadow->ParamByName('stForo',$CbStForo);
$qrShadow->Open();
?>