sync ads impression

 avatar
unknown
pgsql
a year ago
514 B
7
Indexable
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;
Editor is loading...
Leave a Comment