sync ads impression

unknown

pgsql

21 days ago

514 B

Indexable

Never

update ads_impressions
set logs = logs || ' '|| (select ads_id from advertises where advertises.id = ads_impressions.advertise_id) || ' '|| (select name from advertises where advertises.id = ads_impressions.advertise_id)
where ads_impressions.advertise_id != 0;

update ads_impressions
set logs = logs || ' '|| (select id_listing from projects where projects.id = ads_impressions.project_id) || ' '|| (select name from projects where projects.id = ads_impressions.project_id)
where ads_impressions.project_id != 0;