namibia
c449ac80b48405f72fd700d5cd406397b3a17d8a
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
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; |
Commits for namibia/data/old_b4c stuff/update-auction-fields.sql
Revision | Author | Commited | Message |
---|---|---|---|
df0489 ... | Mark | Fri 14 Oct, 2016 10:01:00 +0000 | initial commit |