string(1838) "SELECT Idestagiario, e.DataInicio, v.Nome, CASE
WHEN CPF IS NOT NULL THEN
CONCAT('***.', SUBSTR(CPF,4,3), '.', SUBSTR(CPF,7,3), '-**')
ELSE
CONCAT(' ')
END, g.DescCargo, s.Descricao as DescSecretaria, CASE
WHEN e.CargaHoraria IS NOT NULL THEN
e.CargaHoraria
ELSE
CONCAT(' ')
END, CONCAT('R$ ',FORMAT(COALESCE(Valor, 0),2,'de_DE')) as ValorFormatado, CASE
WHEN e.DataInicio IS NOT NULL THEN
CONCAT(DATE_FORMAT(e.DataInicio,'%d/%m/%Y'), ' ',COALESCE(DATE_FORMAT(e.DataFim,'%d/%m/%Y'), ''))
WHEN e.DataInicio IS NULL THEN ' '
WHEN e.DataFim IS NULL THEN ' '
ELSE CONCAT(DATE_FORMAT(e.DataInicio,'%d/%m/%Y'), ' ',DATE_FORMAT(e.DataFim,'%d/%m/%Y'))
END, CASE
WHEN e.DataInicio IS NOT NULL AND e.DataFim IS NULL THEN
CONCAT(' VIGENTE')
WHEN
(e.DataInicio < CURDATE()) AND (e.DataFim > CURDATE()) THEN CONCAT(' VIGENTE')
ELSE CONCAT(' RESCINDIDO')
END"
string(283) " FROM tabestagiario e INNER JOIN tabvereador v ON(e.NAgente = v.IdVereador)
INNER JOIN TabSecretarias s ON(e.NSecretaria = s.IdSecretarias)
INNER JOIN tabcargo g ON(e.NCargo = g.IdCargo)
WHERE e.Idestagiario > 0 AND e.DtDelete IS NULL "
string(43) " ORDER BY e.DataInicio DESC, e.DataFim DESC"
Câmara Municipal Modelo
exportação
estagiarios
Olá! bem-vindo ao nosso ambiente exportação de dados - estagiarios