select date_format(reg_date, '%Y-%m-%d') as upload_date, count(*) from photo_indexes group by upload_date;
select date_format(reg_date, '%Y-%m-%d') as join_date, count(*) from member_details group by join_date;