Untitled

--- province

update leads
set province_id = (select province_id from advertises where id = leads.ads_id)
where province_id is null;

update shares
set province_id = (select province_id from advertises where id = shares.ads_id)
where province_id is null;

update views
set province_id = (select province_id from advertises where id = views.ads_id)
where province_id is null;

--- city
update leads
set city_id = (select city_id from advertises where id = leads.ads_id)
where city_id is null;

update shares
set city_id = (select city_id from advertises where id = shares.ads_id)
where city_id is null;

update views
set city_id = (select city_id from advertises where id = views.ads_id)
where city_id is null;

--- subdis
update leads
set subdis_id = (select district_id from advertises where id = leads.ads_id)
where subdis_id is null;

update shares
set subdis_id = (select district_id from advertises where id = shares.ads_id)
where subdis_id is null;

update views
set subdis_id = (select district_id from advertises where id = views.ads_id)
where subdis_id is null;