update fanfield set value = (select value from bser where id = fanfield.id) where value = '';SELECT
date(now()) as 'date',
date(SUBDATE(now(), 1)) as 'date1',
date(SUBDATE(now(), 2)) as 'date2',
date(SUBDATE(now(), 3)) as 'date3',
date(SUBDATE(now(), 4)) as 'date4'