select sum(`uploaded_requestlog`.`filesizebyte`) AS `Byte` from `uploaded_requestlog` where (`uploaded_requestlog`.`timestampX` between concat(date_format((curdate() - interval 1 day),'%Y-%m-%d'),' 00:00:00') and concat(last_day((curdate() - interval 1 day)),' 23:59:59') and `uploaded_requestlog`.`clicked` = 1 ) order by `uploaded_requestlog`.`filesizebyte` desc