SELECT sum(numlog) FROM table1 WHERE date IN ( '20071204', '20071205', ... 30 days)