UPDATE auction a
 JOIN company c on c.id=a.company_id
 JOIN lib_city ct on ct.id=c.lib_town_id
 JOIN lib_region rg on rg.id=ct.lib_region_id
 JOIN stock s on s.id=a.stock_id
 JOIN vehicle_type t on t.id=s.vehicle_type_id
 JOIN vehicle_model mdl on mdl.id=t.vehicle_model_id
 JOIN vehicle_make mak on mak.id=mdl.vehicle_make_id
 JOIN vehicle_year y on y.id=s.vehicle_year_id
 LEFT JOIN auction_bid b on b.id=a.auction_bid_id
SET a.region_id = rg.id,
    a.make_id = mak.id,
    a.auction_company_id = c.id,
    a.auction_company_name = c.name,
    a.model_name = mdl.name,
    a.type_name = t.name,
    a.reference_no = s.reference_no,
    a.registration_number = s.registration_number,
    a.stockKm = s.km,
    a.current_bid_company_id = b.company_id,
    a.stock_company_id = s.company_id,
    a.region_name = rg.name,
    a.make_name = mak.name,
    a.year_name = y.name,
    a.stock_created = s.created;