--- a/generateConvos.php
+++ b/generateConvos.php
@@ -1,4 +1,5 @@
 <?php
+//select tgid, extract(hour from call_timestamp) ahour, date_trunc('day', call_timestamp) aday, count(filename), array_to_string(array_agg(filename), ' ') from recordings group by tgid, ahour, aday order by  aday, ahour, tgid
 include('common.inc.php');
 $sth = $conn->prepare('select * from recordings limit 100;');