{literal}
<script>
new Chart(document.getElementById("myChart"),
{"type":"doughnut",
"data":{"labels":["Red","Blue","Yellow"],
"datasets":[{"label":"My First Dataset",
"data":[0,0,{/literal}{$total_views}{literal}],
"backgroundColor":["rgb(255, 99, 132)",
"rgb(54, 162, 235)",
"rgb(255, 205, 86)"]}]}});
</script>
{/literal}
create table file1(line text);
create index if1 on file1(line ASC);
create table file2(line text);
create index if2 on file2(line ASC);
.import 'c:\sql\r\mail.txt' file1
.import 'c:\sql\r\r.txt' file2
.output res.txt
select * from file2 where line not in (select line from file1);