SELECT COUNT(*) FROM emailbody WHERE YEARWEEK(DATE_FORMAT(sendTime,'%Y-%m-%d')) = YEARWEEK(NOW());
SELECT COUNT(*) FROM emailbody WHERE YEARWEEK(DATE_FORMAT(sendTime,'%Y-%m-%d')) = YEARWEEK(NOW())-1;
SELECT COUNT(*) FROM emailbody WHERE YEARWEEK(DATE_FORMAT(sendTime,'%Y-%m-%d')) != YEARWEEK(NOW()) AND YEARWEEK(DATE_FORMAT(sendTime,'%Y-%m-%d')) != YEARWEEK(NOW())-1
SELECT COUNT(*) FROM emailbody WHERE YEARWEEK(DATE_FORMAT(sendTime,'%Y-%m-%d')) = YEARWEEK(NOW())-1;
SELECT COUNT(*) FROM emailbody WHERE YEARWEEK(DATE_FORMAT(sendTime,'%Y-%m-%d')) != YEARWEEK(NOW()) AND YEARWEEK(DATE_FORMAT(sendTime,'%Y-%m-%d')) != YEARWEEK(NOW())-1