TFTP and Emulate view I enhance a bit Markus' SQL query with ( SELECT COUNT(*) FROM ( SELECT MIN(a.download) AS download FROM downloads AS a JOIN connections AS b ON(a.connection = b.connection) GROUP BY a.download_md5_hash HAVING strftime('%Y-%m-%d',MIN(b.connection_timestamp),'unixepoch','localtime') = strftime('%Y-%m-%d',connections.connection_timestamp,'unixepoch','localtime') ) AS newdownloads NATURAL JOIN downlo
personal rants, technology updates and random stuffs in mind