INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (1,'CONTRACT_ID','Identificador del contrato');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (2,'ORIGIN_ID','Identificador de llamadas');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (3,'REQUEST_ID','Demanda ID de tipo de peticiones');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (4,'INCIDENT_ID','Demanda ID de tipo de incidentes');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (5,'DEFAULT_DEPTO_ID','Estándar de identificación de la unidad');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (6,'DEFAULT_SLA','Acuerdo de nivel de servicio de identificacion estándar');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (56,'DEFAULT_REASON_ID','Identificación justificación situación estándar para el cambio');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (106,'DEFAULT_SERVICE_ID','Por defecto el servicio de identificación');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (107,'CHANGE_USER','Vamos a cambiar el solicitante');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (108,'CHANGE_GROUP','Permite la redirección');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (109,'CHANGE_SERVICE','Permite la reclasificación');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (156,'DEFAULT_GROUP_ID','Grupo ejecutor por defecto ID');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (157,'DEFAULT_DESCRIPTION','Complementar la descripción estándar');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (356,'USER','SQL recuperar la conexión del usuario');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (357,'REQUEST_BY_ID','SQL recuperarse de solicitud / incidente por ID');
INSERT INTO rest_parameter (idrestparameter,identifier,description) VALUES (358,'REQUEST_BY_DESCRIPTION','SQL recuperarse de solicitud / incidente por la descripción');

INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (1,NULL,'addServiceRequest','Creación de solicitud de servicio','Sync','Java','br.com.centralit.citsmart.rest.operation.RestAddServiceRequest',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (2,NULL,'listTasks','Lista de tareas','Sync','Java','br.com.centralit.citsmart.rest.operation.RestListTasks',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (3,NULL,'notification_getByUser','Lista de notificaciones de móvil vuelve','Sync','Java','br.com.centralit.citsmart.rest.operation.RestMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (4,NULL,'notification_getById','Devuelve los detalles de una notificación para móviles','Sync','Java','br.com.centralit.citsmart.rest.operation.RestMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (5,NULL,'notification_feedback','Renders notificación retroalimentación a Mobile','Sync','Java','br.com.centralit.citsmart.rest.operation.RestMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (6,NULL,'notification_new','Crear una notificación para móviles','Sync','Java','br.com.centralit.citsmart.rest.operation.RestMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (7,NULL,'notification_getReasons','Devuelve posibles justificaciones de una notificación','Sync','Java','br.com.centralit.citsmart.rest.operation.RestMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (8,NULL,'bicitsmart_recuperarTabelas','Devuelve todas las tablas de datos necesarios para BI Citsmart','Sync','Java','br.com.centralit.citsmart.rest.operation.RestBICitsmart',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (9,NULL,'service_coordinates','Recibe la unidad de accionamiento coordinar el check-in','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTOperation',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (10,NULL,'service_listContracts','Volver contratos lista activa de Citsmart','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTOperation',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (11,NULL,'service_listDeniedReasons','Lista Justificación','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTOperation',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (12,NULL,'service_listSolicitationStatus','Estado de la Lista de la solicitud de servicio','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTOperation',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (13,NULL,'service_listUnits','Lista de unidades para un contrato','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTOperation',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (14,NULL,'notification_attendantLocation','Localización de un asistente','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (15,NULL,'notification_getNewest','Nueva lista de solicitudes','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (16,NULL,'notification_getOldest','Lista de solicitudes destinadas al nuevo usuario','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (17,NULL,'notification_checkin','Check - solicitar por','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (18,NULL,'notification_checkinDenied','La negación Check - en una solicitud sugerencia de servicio','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (19,NULL,'notification_checkout','Check - out, la finalización de una solicitud de servicio','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (20,NULL,'notification_getByCoordinates','Nueva lista de peticiones - Coordenadas','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (21,NULL,'notification_attendRequest','Solicitud asistir','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (22,NULL,'service_deviceDisassociate','Operador de disociar dispositivo','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTOperation',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (23,NULL,'notification_updateNotification','Restaurar tareas y permisos de una solicitud de servicio','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (24,NULL,'notification_getById_v2','Devuelve los detalles de una notificación para móviles','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile',NULL,'A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (59,NULL,'request_create','Crear nuevas solicitudes de servicio','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTOperation','','A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (159,NULL,'request_update','Solicitud de cambio de servicio','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTOperation','','A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (209,NULL,'request_updateStatus','Actualizaciones de estado de una solicitud','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTOperation','','A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (259,NULL,'request_getByUser','Peticiones de consulta por usuario','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTOperation','','A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (309,NULL,'request_getById','Solicitud de información por el número','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTOperation','','A','N');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (359,NULL,'request_create_occurrence','Crear una solicitud de incidentes','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTOperation','','A','N');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (360,NULL,'request_list_occurrences','Instancias de lista de una solicitud','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTOperation','','A','N');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (409,NULL,'request_getNotSynchronized','Recuperar solicitudes no sincronizadas','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTSynchronize','','A','N');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (410,NULL,'synchronize','La sincronización de datos','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTSynchronize','','A','N');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (411,NULL,'occurrence_getNotSynchronized','Recuperar eventos no sincronizadas','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTSynchronize','','A','N');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (412,NULL,'occurrence_synchronize','Sincroniza eventos','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTSynchronize','','A','N');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (459,NULL,'synchronize_find','Recuperar la lista de objetos de sincronización','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTSynchronize','','A','N');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (509,NULL,'synchronize_delete','Eliminar la sincronización','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTSynchronize','','A','N');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (609,NULL,'data_query','Ejecutar consultas en la base de datos','Sync','Java','br.com.centralit.citsmart.rest.v3.operation.RESTDataQuery','','A','Y');
INSERT INTO rest_operation (idrestoperation,idbatchprocessing,name,description,operationtype,classtype,javaclass,javascript,status,generatelog) VALUES (710,NULL,'notification_buscaNotificacao','Servicio de b�squeda de solicitudes para el Citsmart mobile','Sync','Java','br.com.centralit.citsmart.rest.v2.operation.RESTMobile','','A','Y');

INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (1,1,'1');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (1,6,'1');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (1,59,'1');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (2,1,'7');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (2,6,'10');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (3,1,'1');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (3,6,'1');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (3,59,'1');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (4,1,'3');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (4,6,'3');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (4,59,'3');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (5,1,'3');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (5,6,'3');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (6,59,'1421');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (6,159,'1421');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (56,209,'7');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (106,59,'5136');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (107,159,'N');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (108,159,'N');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (109,159,'N');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (156,59,'159');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (157,59,'Requisición creado por ESI centralizador');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (356,609,'select idusuario, login, nome, idempregado, status from usuario where login = ${login}');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (357,609,'SELECT      sol.idSolicitacaoServico,     sol.idbaseconhecimento,     sol.idServicoContrato,     sol.idSolicitante,     sol.idItemConfiguracao,     sol.idItemConfiguracaoFilho,     sol.idtipodemandaservico,     sol.idcontatosolicitacaoservico,     sol.idOrigem,     sol.idResponsavel,     sol.idTipoProblema,     sol.idPrioridade,     sol.idUnidade,     sol.idFaseAtual,     sol.idGrupoAtual,     sol.dataHoraSolicitacao,     sol.dataHoraLimite,     sol.atendimentoPresencial,     sol.prazoCapturaHH,     sol.prazoCapturaMM,     sol.prazoHH,     sol.prazoMM,     sol.descricao,     sol.resposta,     sol.dataHoraInicio,     sol.dataHoraFim,     sol.situacao,     sol.idSolicitacaoPai,     sol.detalhamentoCausa,     sol.idCausaIncidente,     sol.idCategoriaSolucao,     sol.seqreabertura,     sol.enviaEmailCriacao,     sol.enviaEmailFinalizacao,     sol.enviaEmailAcoes,     sol.idgruponivel1,     sol.solucaoTemporaria,     sol.houveMudanca,     sol.slaACombinar,     sol.prazohhAnterior,     sol.prazommAnterior,     sol.idCalendario,     sol.tempoDecorridoHH,     sol.tempoDecorridoMM,     sol.dataHoraSuspensao,     sol.dataHoraReativacao,     sol.impacto,     sol.urgencia,     sol.dataHoraCaptura,     sol.tempoCapturaHH,     sol.tempoCapturaMM,     sol.tempoAtrasoHH,     sol.tempoAtrasoMM,     sol.tempoAtendimentoHH,     sol.tempoAtendimentoMM,     sol.idacordonivelservico,     sol.idultimaaprovacao,     sol.datahorainiciosla,     sol.datahorasuspensaosla,     sol.datahorareativacaosla,     sol.situacaosla,     sol.idtarefaencerramento,     sol.justificativavencimentosla,     aprov.aprovacao,     s.idservico,     s.nomeServico,     td.idTipoDemandaServico,     td.nomeTipoDemandaServico,     c.idContrato,     c.numero as numeroContrato,     e1.nome as solicitante,     u1.nome as unidade,     e2.nome as responsavel,     g1.sigla as grupoAtual,     g2.sigla as grupoNivel1,     cs.nomecontato,     cs.emailcontato,     cs.telefonecontato,     cs.localizacaofisica,     cs.idlocalidade,     sol.idSolicitacaoRelacionada,     e3.email as emailResponsavel,     sol.codigoExterno FROM     solicitacaoservico sol         INNER JOIN     tipodemandaservico td ON td.idtipodemandaservico = sol.idtipodemandaservico         LEFT JOIN     servicocontrato sc ON sc.idservicocontrato = sol.idservicocontrato         LEFT JOIN     contratos c ON c.idcontrato = sc.idcontrato         LEFT JOIN     servico s ON s.idservico = sc.idservico         LEFT JOIN     empregados e1 ON e1.idempregado = sol.idsolicitante         LEFT JOIN     unidade u1 ON u1.idunidade = e1.idunidade         LEFT JOIN     usuario usu ON usu.idusuario = sol.idresponsavel         LEFT JOIN     empregados e2 ON e2.idempregado = usu.idempregado         LEFT JOIN     unidade u2 ON u2.idunidade = e2.idunidade         LEFT JOIN     origematendimento oa ON oa.idorigem = sol.idorigem         LEFT JOIN     prioridade p ON p.idprioridade = sol.idprioridade         LEFT JOIN     faseservico fs ON fs.idfase = sol.idfaseatual         LEFT JOIN     grupo g1 ON g1.idgrupo = sol.idgrupoatual         LEFT JOIN     grupo g2 ON g2.idgrupo = sol.idgruponivel1         LEFT JOIN     empregados e3 ON e3.idempregado = sol.idresponsavel         LEFT JOIN     contatosolicitacaoservico cs ON cs.idcontatosolicitacaoservico = sol.idcontatosolicitacaoservico         LEFT JOIN     aprovacaosolicitacaoservico aprov ON aprov.idaprovacaosolicitacaoservico = sol.idultimaaprovacao WHERE sol.idsolicitacaoservico = ${id}');
INSERT INTO rest_domain (idrestparameter,idrestoperation,value) VALUES (358,609,'SELECT      sol.idSolicitacaoServico,     sol.idbaseconhecimento,     sol.idServicoContrato,     sol.idSolicitante,     sol.idItemConfiguracao,     sol.idItemConfiguracaoFilho,     sol.idtipodemandaservico,     sol.idcontatosolicitacaoservico,     sol.idOrigem,     sol.idResponsavel,     sol.idTipoProblema,     sol.idPrioridade,     sol.idUnidade,     sol.idFaseAtual,     sol.idGrupoAtual,     sol.dataHoraSolicitacao,     sol.dataHoraLimite,     sol.atendimentoPresencial,     sol.prazoCapturaHH,     sol.prazoCapturaMM,     sol.prazoHH,     sol.prazoMM,     sol.descricao,     sol.resposta,     sol.dataHoraInicio,     sol.dataHoraFim,     sol.situacao,     sol.idSolicitacaoPai,     sol.detalhamentoCausa,     sol.idCausaIncidente,     sol.idCategoriaSolucao,     sol.seqreabertura,     sol.enviaEmailCriacao,     sol.enviaEmailFinalizacao,     sol.enviaEmailAcoes,     sol.idgruponivel1,     sol.solucaoTemporaria,     sol.houveMudanca,     sol.slaACombinar,     sol.prazohhAnterior,     sol.prazommAnterior,     sol.idCalendario,     sol.tempoDecorridoHH,     sol.tempoDecorridoMM,     sol.dataHoraSuspensao,     sol.dataHoraReativacao,     sol.impacto,     sol.urgencia,     sol.dataHoraCaptura,     sol.tempoCapturaHH,     sol.tempoCapturaMM,     sol.tempoAtrasoHH,     sol.tempoAtrasoMM,     sol.tempoAtendimentoHH,     sol.tempoAtendimentoMM,     sol.idacordonivelservico,     sol.idultimaaprovacao,     sol.datahorainiciosla,     sol.datahorasuspensaosla,     sol.datahorareativacaosla,     sol.situacaosla,     sol.idtarefaencerramento,     sol.justificativavencimentosla,     aprov.aprovacao,     s.idservico,     s.nomeServico,     td.idTipoDemandaServico,     td.nomeTipoDemandaServico,     c.idContrato,     c.numero numeroContrato,     e1.nome solicitante,     u1.nome unidade,     e2.nome responsavel,     g1.sigla grupoAtual,     g2.sigla grupoNivel1,     cs.nomecontato,     cs.emailcontato,     cs.telefonecontato,     cs.localizacaofisica,     cs.idlocalidade,     sol.idSolicitacaoRelacionada,     e3.email as emailResponsavel,     sol.codigoExterno FROM     solicitacaoservico sol         INNER JOIN     tipodemandaservico td ON td.idtipodemandaservico = sol.idtipodemandaservico         LEFT JOIN     servicocontrato sc ON sc.idservicocontrato = sol.idservicocontrato         LEFT JOIN     contratos c ON c.idcontrato = sc.idcontrato         LEFT JOIN     servico s ON s.idservico = sc.idservico         LEFT JOIN     empregados e1 ON e1.idempregado = sol.idsolicitante         LEFT JOIN     unidade u1 ON u1.idunidade = e1.idunidade         LEFT JOIN     usuario usu ON usu.idusuario = sol.idresponsavel         LEFT JOIN     empregados e2 ON e2.idempregado = usu.idempregado         LEFT JOIN     unidade u2 ON u2.idunidade = e2.idunidade         LEFT JOIN     origematendimento oa ON oa.idorigem = sol.idorigem         LEFT JOIN     prioridade p ON p.idprioridade = sol.idprioridade         LEFT JOIN     faseservico fs ON fs.idfase = sol.idfaseatual         LEFT JOIN     grupo g1 ON g1.idgrupo = sol.idgrupoatual         LEFT JOIN     grupo g2 ON g2.idgrupo = sol.idgruponivel1         LEFT JOIN     empregados e3 ON e3.idempregado = sol.idresponsavel         LEFT JOIN     contatosolicitacaoservico cs ON cs.idcontatosolicitacaoservico = sol.idcontatosolicitacaoservico         LEFT JOIN     aprovacaosolicitacaoservico aprov ON aprov.idaprovacaosolicitacaoservico = sol.idultimaaprovacao WHERE sol.descricao like ${description}');