
-- pubs
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'a%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'b%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'c%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'd%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'e%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'f%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'g%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'h%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'i%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'j%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'k%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'l%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'm%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'n%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'o%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'p%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'q%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'r%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 's%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 't%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'u%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'v%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'w%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'x%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'y%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like 'z%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '0%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '1%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '2%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '3%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '4%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '5%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '6%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '7%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '8%' group by token, match_value;
insert into lookup_term_frequency (cnt, token, pos) select count(*) cnt, token, match_value from machine_annotations_pubs where match_source = 'pos' and token like '9%' group by token, match_value;
