SELECT `tw_farms`.`farm_id`, CONVERT_TZ(`tw_farms`.`last_farmed`,'+00:00','+01:00'), `tw_farms`.`village_id`, `tw_villages`.`name`, `tw_village
`tw_farms`.`clay`, `tw_farms`.`timber`, `tw_farms`.`iron`, `tw_farms`.`wall`
FROM `tw_farms`
INNER JOIN `tw_villages`
ON `tw_villages`.`village_id` = `tw_farms`.`village_id`
WHERE `tw_farms`.`account_id` = '1'");