--- a/inserttgid.txt
+++ b/inserttgid.txt
@@ -1,1 +1,2 @@
+insert into tgids (tgid,alpha_tag) (SELECT distinct tgid, tgname as alpha_tag FROM recordings WHERE NOT EXISTS (SELECT tgid FROM tgids WHERE tgid=recordings.tgid));