SELECT id, idPrimario, assunto, observacao, vendedor, DATE(dataCriacao), data, horario_inicial, horario_final, status, usuario, supervisor, diario, clientes FROM agenda_tarefa WHERE supervisor = ? AND data >= DATE_SUB(NOW(), INTERVAL 6 MONTH)