SELECT sum(numlog) FROM table1 WHERE date >= 20071204 AND date < 20080112

##</code><code>##

SELECT sum(numlog) FROM table1 WHERE date BETWEEN 20071204 AND 20080112