Unnamed

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'");