#MYSQL#ERROR#<br>Out of range value for column 'herds' at row 1<br>
        insert into temp
        select year,'england' as `area`,england*1000 as herds from `cattle_and_calves`
        where year>=1996
        union
        select year,'scotland' as `area`,scotland*1000 as herds from `cattle_and_calves`
        where year>=1996
        union
        select year,'wales' as `area`,wales*1000 as herds from `cattle_and_calves`
        where year>=1996
        order by year asc